Excel Export Specifications and Limits

  • 3 minutes to read

The Excel Export Library provides unified classes and interfaces used for exporting data to the most popular spreadsheet formats (XLSX, XLS and CVS). But be aware that the content of the resulting document highly depends on the output file format. For example, XLSX format supports all the features provided by the Excel Export Library, while the CSV file format keeps only cell values by saving them as text and does not support formatting, pictures, hyperlinks and other important features. That is why you should always be sure that you use the appropriate file format to export your data to avoid loss of important information and format settings.

TIP

To verify whether the certain functionality is supported by the file format to which you export your document, use properties of the IXlDocumentOptions object accessible using the IXlDocument.Options property.

The table below lists feature and formatting differences between the XLSX, XLS and CSV file formats.

Feature

XLSX

XLS

CSV

Maximum number of rows

1,048,576

65,536

2,147,483,647[1]

Maximum number of columns

16,384

256

2,147,483,647[1]

Multi-part workbooks ** **(with several worksheets)

DocumentExportCapability_GreenTick

DocumentExportCapability_GreenTick

DocumentExportCapability_RedX

Columns

     Width

DocumentExportCapability_GreenTick

DocumentExportCapability_GreenTick

DocumentExportCapability_RedX

     Formatting options

DocumentExportCapability_GreenTick

DocumentExportCapability_GreenTick

Takes into account only number format settings.[2]

     Visibility state

DocumentExportCapability_GreenTick

DocumentExportCapability_GreenTick

DocumentExportCapability_RedX

Rows

     Width

DocumentExportCapability_GreenTick

DocumentExportCapability_GreenTick

DocumentExportCapability_RedX

     Formatting options

DocumentExportCapability_GreenTick

DocumentExportCapability_GreenTick

Takes into account only number format settings.[2]

     Visibility state

DocumentExportCapability_GreenTick

DocumentExportCapability_GreenTick

DocumentExportCapability_RedX

Cell Values

DocumentExportCapability_GreenTick

DocumentExportCapability_GreenTick

Cell values are exported as text.

Cell formatting

     Font

DocumentExportCapability_GreenTick

DocumentExportCapability_GreenTick

DocumentExportCapability_RedX

     Fill

DocumentExportCapability_GreenTick

DocumentExportCapability_GreenTick

DocumentExportCapability_RedX

     Alignment

DocumentExportCapability_GreenTick

DocumentExportCapability_GreenTick

DocumentExportCapability_RedX

     Borders

DocumentExportCapability_GreenTick

DocumentExportCapability_GreenTick

DocumentExportCapability_RedX

     Number format

DocumentExportCapability_GreenTick

DocumentExportCapability_GreenTick

DocumentExportCapability_GreenTick[2]

Merged cells

DocumentExportCapability_GreenTick

DocumentExportCapability_GreenTick

DocumentExportCapability_RedX

Formulas

DocumentExportCapability_GreenTick

DocumentExportCapability_GreenTick

DocumentExportCapability_RedX

Conditional formatting

DocumentExportCapability_GreenTick

DocumentExportCapability_GreenTick[3]

DocumentExportCapability_RedX

Pictures

DocumentExportCapability_GreenTick

DocumentExportCapability_GreenTick

DocumentExportCapability_RedX

Sparklines

DocumentExportCapability_GreenTick

DocumentExportCapability_RedX

DocumentExportCapability_RedX

Hyperlinks

DocumentExportCapability_GreenTick

DocumentExportCapability_GreenTick

DocumentExportCapability_RedX

Filtering

DocumentExportCapability_GreenTick

DocumentExportCapability_GreenTick

DocumentExportCapability_RedX

Grouping/Outline

DocumentExportCapability_GreenTick

DocumentExportCapability_GreenTick

DocumentExportCapability_RedX

Data Validation

DocumentExportCapability_GreenTick

DocumentExportCapability_GreenTick

DocumentExportCapability_RedX

Frozen panes

DocumentExportCapability_GreenTick

DocumentExportCapability_GreenTick

DocumentExportCapability_RedX

Page breaks/Page setup

DocumentExportCapability_GreenTick

DocumentExportCapability_GreenTick

DocumentExportCapability_RedX

Print area/options/titles

DocumentExportCapability_GreenTick

DocumentExportCapability_GreenTick

DocumentExportCapability_RedX

Headers/Footers

DocumentExportCapability_GreenTick

DocumentExportCapability_GreenTick

DocumentExportCapability_RedX

Encryption

DocumentExportCapability_GreenTick

DocumentExportCapability_GreenTick

DocumentExportCapability_RedX

Error checking options

DocumentExportCapability_GreenTick

DocumentExportCapability_GreenTick

DocumentExportCapability_RedX

Document properties

DocumentExportCapability_GreenTick

DocumentExportCapability_GreenTick

DocumentExportCapability_RedX

Footnotes
  1. Note that Microsoft® Excel® and other spreadsheet applications allow you to import only 1,048,576 rows and 16,384 columns, so that you will be unable to view or edit your remaining data and this data may be lost if you try to save the modified workbook.

  2. The specified number format settings will be used to convert a cell value into a string during export when the CsvDataAwareExporterOptions.UseCellNumberFormat property is true (the default value). But note that when you open a CSV file in Microsoft® Excel® or any other spreadsheet application, each data column in the loaded file will be interpreted and formatted according to the default data format settings specified in the application.

  3. Limited support: you cannot apply more than three conditional formats to a range of cells. Some conditional formatting types are not fully supported. For example, you cannot specify a data bar rule that uses a solid fill, border or bar direction settings, or contains negative bars. An icon set conditional formatting rule that uses an unsupported icon set arrangement (3 Triangles, 3 Stars, 5 Boxes, or custom icon set) will not be saved.