DataTable export to excel & Datatable append to worksheet

r k

Hi All,

As i am trying to code for Datatable export to excel worksheet. If file excel file exist, datatable need to append to the sheet.

Please help me to achive this

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

alice yang8y ago
Use Free Spire.Xls.dll.
If file doesn't exist, add data table to a new workbook:
Workbook workbook = new Workbook();

Worksheet sheet = workbook.Worksheets[0];

sheet.InsertDataTable(datatable, true, 1, 1);

workbook.SaveToFile("output.xlsx",ExcelVersion.Version2013);
If file exists, append Data table to the end of an existing worksheet of the workbook:
Workbook workbook = new Workbook();

workbook.LoadFromFile("input.xlsx");

Worksheet sheet = workbook.Worksheets[0];

sheet.InsertDataTable(datatable, true, sheet.LastRow + 1, 1);

workbook.SaveToFile("output.xlsx",ExcelVersion.Version2013);
Sai Kumar Koona8y ago
Can u please check below link? This is in VB... please understand the logic

https://www.codeproject.com/Tips/1165476/How-to-Use-EPPlus-in-VB