Column titles not exported using XLSX Data File

adyble · February 2022

Hi
Is there a way to add column titles to XLSX Data File exports ?
The data is ok in the columns. We've tried title, header, column headers in the options but none work.
Thanks
Andy

nardmoseley · February 2022

Hi Andy,

By default only detail band elements are exported. To override the default, use the DefaultBands property to specify which bands to export or or use the Print To File Setup dialog to define which elements to export.

For details check out the RBuilder Help topic for TppXlsxDataDevice

adyble · February 2022

Hi Nard
in defaultbands we have btHeader, btTitle, btColumnHeader and btDetail set to True already.

adyble · February 2022

It's actually the Advanced options of the export form. If check "Include singe header" it works ok. Just need to work out how to set that by default.

nardmoseley · February 2022

Hi Andy,

Set Report.XlsSettings.IncludeSingleHeader to True

Column titles not exported using XLSX Data File

Comments