When exporting a grid to Excel, is there anyway of manipulating the resulting columns in Excel (especially width and format) ?
On the browser screen I set the column width to allow for as much to be visible as possible, but take into consideration the total width of the grid. In excel this is not as important.
Also, It appears in a way as if the width and format of the grid columns are exported as well, and if that is the case, how would it be possible to change them for the export only ?
I can see from the Features Demo that it is possible to set the formatting, but how can I set column width and is it possible to change the cell contents as part of it as well. E.g.: the data in a cell could contain characters, not recognized by Excel, so I will want to "clean" the data before Excel gets them.
Is there anyway I can read about these options. I suppose the VCL AdvGrid has a similar Export function. Could I learn something from that description (if it exists) ?