Read, write and convert XLSX, XLSM, XLSB, XLS, XML, HTML, CSV and TXT files. Spreadsheets without MS Excel! Excel library and Excel component for .NET and Java!
Express Excel Writer library for Java, JSP, JSF, ColdFusion to export ResultSet to Excel file and export List to Excel file! XLSX, XLS, XLSB files.
Import Excel sheet to ResultSet in ColdFusion by EasyXLS library! XLSX, XLSM, XLSB, XLS spreadsheets in ColdFusion.
https://www.easyxls.com/manual/tutorials/coldfusion/import-excel-sheet-to-resultset.html
Import Excel to ResultSet in ColdFusion by EasyXLS library! XLSX, XLSM, XLSB, XLS spreadsheets in ColdFusion.
https://www.easyxls.com/manual/tutorials/coldfusion/import-excel-to-resultset.html
Import Excel file to ResultSet in Java by EasyXLS! XLSX, XLSM, XLSB, XLS spreadsheets in Java.
https://www.easyxls.com/manual/tutorials/java/import-excel-to-resultset.html
Export ResultSet to Excel file in Java with cell formatting by EasyXLS library! XLSX, XLSM, XLSB, XLS spreadsheets in Java.
https://www.easyxls.com/manual/tutorials/java/export-resultset-to-excel-with-formatting.html
Export ResultSet to Excel file in Java by EasyXLS library! XLSX, XLSM, XLSB, XLS spreadsheets in Java.
https://www.easyxls.com/manual/tutorials/java/export-resultset-to-excel.html
Import Excel file to ResultSet in Java or Coldfusion! Learn how to do it and save valuable time with EasyXLS!
http://www.easyxls.com/manual/basics/import-excel-to-resultset.html
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.
EasyXLS Excel library makes easier the export of Excel reports in XLSX file format.
The Excel reports can be formatted to have an attractive look, exactly in the preferred mode, or one of the predefined looks can be selected.
The Excel library works without Excel installed and without Interop and it is perfect to be used from server environments or desktop applications.
Data structures like GridView, DataGridView, DataGrid, DataTable, DataSet, JTable and ResultSet can be exported to XLSX file with one single line of code.
EasyXLS can be used from programming languages like C#, VB.NET, C++.NET, J#, Java, PHP, ASP classic, C++, VB6, VBS or ColdFusion.
EasyXLS allows not only the export of data and formatting, but also offers other Excel features like conditional formatting, data validation, comments, images and print options.
Moreover, the data can be exported as charts, pivot tables or pivot charts.
The data can be protected with password and the Excel file can be encrypted.
The export of XLSX file is fast, so it is the best solution for exporting large xlsx files.
Read more details on how to export data to xlsx file in C#, VB.NET, Java, C++, PHP.