Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
180
How to export non binded columns to excel...
posted

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.

 

  • 33839
    posted

    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