EasyXLS is an Excel component that can be used to export Excel files programmatically. It also permits the export of large amount of data to Excel file.



EasyXLS is an optimal solution to:

• export large volume of data from MS SQL, MySQL, MS Access, Oracle database
• export large GridView to Excel
• export large DataSet to Excel
• export large DataTable to Excel
• export large ResultSet to Excel

The Excel component supports all MS Excel file formats: XLSX, XLS, XLSM, XLSB and XML Spreadsheet. The below links explains with source code samples how to export data to these file formats:

• How to export data to XLSX file format?
• How to export data to XLS file format?
• How to export data to XLSM file format?
• How to export data to XLSB file format?

However, the recommended file format for large Excel files is the binary format like XLSB or XLS formats. Binary files are faster by default.

For a fast export and better memory management, some steps must be followed. Check the below link for more technical details:
How to export large Excel file?

The Excel component can be used from C#, VB.NET, C++.NET, PHP, ASP classic, C++, Java, VBS, VB6 or ColdFusion.