Category / Section
How to Exclude Report Headers in Excel Export Using Bold Reports
Published:
Updated:
By default, Bold Reports Designer includes the report header when exporting reports to Excel. However, you can exclude the header section using the HideExcelHeader custom attribute resulting in cleaner Excel outputs. This is useful for data-focused reports or when headers are unnecessary.
This guide provides step-by-step instructions to configure the HideExcelHeader attribute in Bold Reports.
Steps to Exclude Report Header in Excel Export
- Open the Properties Panel:
- Click the Settings icon to open the Properties panel.
- Navigate to the Miscellaneous section and expand it, locate Custom Attributes and click Set Attributes.
- Add the HideExceHeader Custom Attribute:
- In the Custom Attributes dialog, click Add to create new attribute fields.
- In the Name field, enter
HideExcelHeader
(case-sensitive). and set the Value field totrue
to exclude the report header during Excel export. - Click OK to save the changes.
Attribute Name | Value | Description |
---|---|---|
HideExcelHeader |
true |
Hides report headers when exporting to Excel |
- Preview and Export the Report
- Click Preview, then on export and Export the report as an Excel file format.
- Open the exported Excel file to verify that the header section is excluded.
- Click Preview, then on export and Export the report as an Excel file format.
Download the sample report here for further reference.