Home Devices
New Blog Posts: Merging Reports - Part 1 and Part 2

Column titles not exported using XLSX Data File

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

Comments

  • 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




    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • Hi Nard
    in defaultbands we have btHeader, btTitle, btColumnHeader and btDetail set to True already.
  • 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.
  • Hi Andy,

    Set Report.XlsSettings.IncludeSingleHeader to True


    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
Sign In or Register to comment.