Hi,
I have data grid and I am exporting data source using excel exporter.
It export all visible columns (bound columns) but I want to export all field of my datasource into excel.
Is it possible? If yes then please provide proper code sample to me.
Thanks in advance.
Hi omidixit,
I think you have two options. The first would be to temporarily bind the entire web data grid to all of the data before exporting. So you could either add more bound columns. Or remove all and set autogenerate to true. The second option would be to handle row exported on the excel exporter. In here, you could get access to the worksheet row and add the pieces of data that are missing from the grid. You'd need to do this to the header, footer, and data rows. This would be slightly more difficult as you would also have to style the cells. And if it was hierarchical, make sure group rows had the appropriate col span.
regards,
David Young