When exporting a database grid using Excel automation, the Excel file contains the field names as the first row in the export. However, when exporting using TAdvGridExcelIO through Flexcel, only the data rows are exported, no headers. I can't see any setting in TAdvGridExcelIO that would enable this - I even tried setting GridStartRow to zero. Have I missed something, or is this just the way it works?
With properties AdvGridExcelIO.GridStartCol, AdvGridExcelIO.GridStartRow you can control from which column & row of the TAdvStringGrid the export starts.
Thanks Bruno - working now.
I had actually tried setting start row to zero, as I mentioned in my first post, but it didn't work then. I'm wondering is it was just silently failing to overwrite a previous export, or if my upgrading to yesterdays release had anything to do with it. Either way, it's working now.