Excel Export Library
- 2 minutes to read
The Excel Export Library allows you to generate spreadsheet documents in code and export them to Excel formats. This library is developed to significantly improve performance and reduce memory consumption while generating spreadsheets. To maintain high performance standards, the Excel Export Library does not create an internal document model and writes data directly to a memory or file stream.
Unlike the multi-purpose Spreadsheet Document API that can load and edit spreadsheet documents, the Excel Export Library only generates spreadsheet files in code. 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).
Refer to the following topics to get started with the Excel Export Library:
Warning
The Office File API (Basic Edition), which included the Word Processing Document API and Excel Export API libraries, was discontinued on October 17, 2024. If you purchased a DevExpress Universal, DXperience, WinForms, WPF, Office File API, Reporting and ASP.NET subscription prior to October 17, 2024, our Office File API (Basic Edition) will remain available to you. If you are new to DevExpress and are interested in our Office File API, please refer to the following webpage for pricing/licensing information: DevExpress Office File API
Main Features
The Excel Export Library allows you to execute the following actions:
- Create basic elements of a spreadsheet document: worksheets, columns, rows, and cells.
- Specify cell formatting: background color, alignment, borders, font settings, and number formats.
- Apply different fonts to specific text regions within a cell.
- Add formulas and hyperlinks to cells.
- Create merged cells.
- Apply conditional formatting to worksheet cells.
- Freeze worksheet columns and rows.
- Display a worksheet from right to left.
- Insert pictures and add hyperlinks to them.
- Filter and group data.
- Create data validation criteria.
- Insert and modify sparklines.
- Define print options: add headers and footers to a worksheet printout, set a print area, and specify print titles.
- Create and format tables.
Supported Formats
The Excel Export Library supports the following file formats for data export:
- XLSX
- Microsoft Office Open XML format - the default file format of Microsoft Excel, starting with Microsoft Excel 2007.
- XLS
- Microsoft Excel 97-2003 binary file format.
- CSV
- Comma Separated Values - the plain text format that uses comma characters as separators between cells.