The Excel Export library is designed to quickly generate a spreadsheet document in code and export it to Excel formats. This library is developed to significantly improve performance and reduce memory consumption while generating spreadsheets. To maintain high performance standards, it does not create an internal document model, and writes data directly to a memory or file stream.
Unlike the multi-purpose Spreadsheet Document API, which can load and edit spreadsheet documents, the Excel Export library is designed only for generating spreadsheet files in code, so that you can use the Excel Export API to export data from your application to Excel formats in the most efficient manner and with minimal memory usage (that is important to those of you who need to generate numerous Excel documents on the server side).
To learn more about the Excel Export library capabilities and restrictions, refer to the Overview section.
The most significant Excel Export library features are:
The Excel Export library supports the following file formats for data export.
Microsoft Office Open XML format - the default file format of Microsoft Excel, starting with Microsoft Excel 2007.
Microsoft Excel 97-2003 binary file format.
Comma Separated Values - the plain text format that uses comma characters as separators between cells.