Column titles not exported using XLSX Data File

adyble

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

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

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

adyble

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

Hi Andy,

Set Report.XlsSettings.IncludeSingleHeader to True