public static bool AppendExcel(string path, string sheetName, List <Object> datas)
{
if (datas == null || datas.Count <= 0)
{
return(false);
}
IWorkbook workbook = NPOIOpenExcel(path);
ISheet sheet = workbook.GetSheet(sheetName);
int rowIndex = sheet.LastRowNum + 1;
datas.ForEach(a => {
ExcelAssit.WriteRow(a, workbook, sheet, rowIndex);
rowIndex++;
});
return(WriteToDisk(path, workbook));
}
public static bool WriteExcel(string path, string sheetName, List <Object> datas)
{
if (datas == null || datas.Count <= 0)
{
return(false);
}
HSSFWorkbook workbook = new HSSFWorkbook();
ISheet sheet1 = workbook.CreateSheet(sheetName);
ExcelAssit.CreateTitle(sheet1, datas[0]);
int rowIndex = 1;
datas.ForEach(a => {
ExcelAssit.WriteRow(a, workbook, sheet1, rowIndex);
rowIndex++;
});
return(WriteToDisk(path, workbook));
}