[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Collapse]Office File API
  Demo Application
  Redistribution and Deployment
 [Expand]Spreadsheet Document API
 [Expand]Word Processing Document API
 [Expand]PDF Document API
 [Collapse]Excel Export Library
   Product Structure
   Getting Started
 [Expand]Snap Report API
 [Expand]Zip Compression and Archive API
 [Expand]Barcode Generation API
 [Expand]Unit Conversion API
 [Expand]API Reference
[Expand]Report and Dashboard Server
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

Excel Export Library

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.

Expanded Main Features

The most significant Excel Export library features are:

  • Create basic elements of a spreadsheet document: worksheets, columns, rows and cells.
  • Specify cell formatting: background color, alignment, borders, font settings, and number format.
  • Apply different fonts to specific text regions within a cell.
  • Add formulas and hyperlinks to a cell.
  • Create merged cells.
  • Add conditional formatting to worksheet cells.
  • Freeze worksheet columns and rows.
  • Display a worksheet from right to left.
  • Insert pictures and add hyperlinks to them.
  • Use filtering and grouping functionality.
  • 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 adjust tables.

Expanded 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.

Expanded See Also

Is this topic helpful?​​​​​​​