How to Exclude Report Headers in Excel Export Using Bold Reports

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

1. 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.
     
     
2. 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 to true to exclude the report header during Excel export.
   • Click OK to save the changes.
     
     

3. 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.