Exporting a Report as a Microsoft Excel File (Report Builder 1.0)
The Excel export option in Report Builder is compatible with Microsoft Excel 97 and later; it saves the report as an Excel spreadsheet and tries to preserve the layout and original design of the report. Because of this, you need to take certain considerations into account when saving your report as an Excel file.
Note
The format for reports rendered as Microsoft Excel is Binary Interchange File Format (BIFF).
When a report is saved as an Excel file, each page in the report becomes a worksheet and looks similar to the report you exported. There is a limit to the number of worksheets that Excel can have per workbook, and an error is generated if the limit is exceeded.
Excel supports only a predefined set of colors. When the report is saved as an Excel file, Excel takes the colors used in the report and maps them to the best match.
In This Section
Topic |
Description |
|---|---|
Describes limitations in Excel that may cause errors in the report when saving it to Excel. |
|
Report Item Behavior When Exporting to Excel (Report Builder 1.0) |
Describes how Excel saves charts, tables, matrices, and text. |
Describes the page orientation, pagination, and section breaks. |