• Article

Limitations with Exporting to Excel (Report Builder 1.0)

When exporting report data to Microsoft Excel, you should be aware of the following limitations:

  • The maximum number of rows in Excel is 65,536. This is checked by the Excel export option, and an error is displayed in Excel if the limit is exceeded.

  • The maximum number of columns in Excel is 256. This is checked by the Excel export option, and an error is displayed in Excel if the limit is exceeded.

  • The maximum column width in Excel is 255 characters or 1,726.5 points. This is not checked by the Excel export option.

  • The maximum number of characters in a cell is 32,767. This is not checked by the Excel export option.

  • There is a limit to the number of worksheets that Excel can have per workbook. Each page of the rendered report becomes a worksheet; an error is displayed in Excel if the limit is exceeded.

  • Excel supports only the following border line widths: 0.5 pt., 1.0 pt., and 1.5 pt.

Converting Formulas to Excel

When saving your report data to Excel, Report Builder formulas are not converted to Excel formulas. Instead, the value is placed directly in the cell.