Log In
[Expand]Welcome to DevExpress .NET Documentation
[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]Document Server
  Product Information
 [Expand]Redistribution and Deployment
 [Expand]Spreadsheet Document Server
 [Collapse]XL Export Library
   Product Structure
   Getting Started
 [Expand]Rich Edit Document Server
 [Expand]Snap Document Server
 [Expand]PDF Document Processor
 [Expand]Compression Library
 [Expand]Bar Code Library
 [Expand]Unit Conversion Library
 [Expand]API Reference
[Expand]Report Server
[Expand]eXpressApp Framework
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

XL Export Library

The XL 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 Server, which can load and edit spreadsheet documents, the XL Export library is designed only for generating spreadsheet files in code, so that you can use the XL 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 XL Export library capabilities and restrictions, refer to the Overview section.

Expanded Main Features

The most significant features of the XL Export library are listed below.

  • 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 XL 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?​​​​​​​