//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); } }