Posted 14 September 2017, 12:10 pm EST
Dear support,
my customer wants to export FlexGrid data as an excel file, then edit the excel and import it again to update the data.
Therefore they need to export the column ID of the datasets and hide this column in the exported excel. How is this possible? My first attempt was using the includeColumns function, but then the columns are not exported anymore. I need to export them, but hide the column in Excel because I need the ID for the mapping of the updated items.
Furthermore, some of the columns are mandatory to be filled out. So I want to add '[*] ’ in front of the exported column headers. I tried this with the IFlexGridXlsxOptions ‘formatItem’ but I found that this is only for the data rows and not for the headers. Am I right with this? How can I achieve my requirement?
Thank you