0
Answer

Asp.net C# best way to export excel with multiple sheets | Need ideas

Hi All,

I need to export multiple DataTables into a single Excel file (.xls or .xlsx).The number of sheets will be dynamic. I am considering two options:

1. Data only

  • No formatting

  • Just headers and data

2. Formatted Excel

  • Header colors

  • Bold headings

  • Borders

  • Column widths

  • Basic formatting

For .NET Framework 4.5.2, which approach and library would you recommend?

For example, EPPlus, NPOI, Open XML, or any other better option?

Also, which one is better for performance with large datasets? 😊