Loading

List to export to excel with multiple sheets using EPPLUS C#

siva nathan

Hi All,

am having a list with multiple columns need to export excel with multiple sheets using EPPLUS C# code

can any one suggest how to export with multiple sheets from list

2 Replies

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

Mageshwaran R6y ago
Hi Siva,
please refer below link:

https://www.c-sharpcorner.com/UploadFile/rahul4_saxena/how-to-export-multiple-data-tables-to-multiple-worksheets-in/
Sapna Girish6y ago
Try Free Spire.XLS for .NET (https://www.nuget.org/packages/FreeSpire.XLS/ ). It offers a Worksheet.InsertArrayList() method to import date from a list to the specified worksheet.
Workbook wb = new Workbook();
Worksheet sheet = wb.Worksheets[0];
sheet.InsertArrayList();