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