export grid to Excel

[svonmiller]

We are using SmartClient_80_Pro.

One problem with grid.exportdata is that the exported data are not formated in the Excel even though the data is formated correctly in the grid on browser. Is there any way to export the data with the exact format as what is shown on browser?

Can we export other ui elements together with the grid, for example, can we export the search criteria ( a label element) and the search result ( a grid) together to one Excel spreadsheet?

Thanks.

[Isomorphic]

For specifically date fields, if the date format you want is one of the built-in formats, you can specify it on the DataSourceField and it will be used for Excel export.

Otherwise, there is the option of exportClientData(), which essentially transmits the data to export from the client to the server so that all client-side formatting is preserved. The disadvantage of this is that it's only going to work for the volume of data that's reasonable to transmit server to client and back, around 2000 rows is a reasonable maximum if you need to support IE6.