[Solved] Exporting numbers in string format to Excel

[Reden]

I'm trying to use the export feature of RadGridView to send data from the grid to Excel.  One of the columns is a string type data where it can contain alphanumeric characters.  If one of the rows has all numbers that starts with a series of zeros (e.g. 000012345), when it gets exported to Excel the output is only 12345, the zeroes are chopped-off.  If it contains letters and numbers (e.g. 00001234a), it exports the entire data in Excel correctly.  Is there a way to handle this scenario during exporting (like special code in the RadGridView_Exporting event) so it works both ways?

Thank you,
Reden

[Vlad]

Hi Reden,

Possible solution will be to use ExcelML export instead.

Greetings,
Vlad
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Reden]

Thanks for the quick reply.  I'll do instead of using ExportToExcel.