//copy row
public void CopyRow(ExcelDocument2007 excel2007, int startSourceCol, int stopSourceCol, int sourceRow, int startDesCol, int stopDesCol, int desRow)
{
for (int i = 0; i <= (stopDesCol - startDesCol); i++)
{
string value = excel2007.ReadValue(sourceRow, startSourceCol + i);
AddData(desRow, startDesCol + i, value);
}
}
//copy column
public void CopyColumn(ExcelDocument2007 excel2007, int startSourceRow, int stopSourceRow, int sourceCol, int startDesRow, int stopDesRow, int desCol)
{
for (int i = 0; i < (stopDesRow - startDesRow); i++)
{
string value = excel2007.ReadValue(startSourceRow + i, sourceCol);
AddData(startDesRow + i, desCol, value);
}
}