public static void Append(this IWorkbook workbook, string sheetName, DataTable dt) { ISheet sheet = workbook.GetSheet(sheetName); if (sheet == null || dt == null) { return; } sheet.AppendRows(dt); }
public static void Append(this IWorkbook workbook, DataSet ds) { for (int i = 0; i < workbook.NumberOfSheets; i++) { ISheet sheet = workbook.GetSheetAt(i); if (i < ds.Tables.Count) { sheet.AppendRows(ds.Tables[i]); } } }