export to excel

[Mahdi]

hello .I have a question about exporting a grid to excel

I have a grid with one numeric column(INT 32) and I want to show the content of this cell with comma (Like 10,000) and when it will export to excel it shows exactly like the content (I mean 10,000 in grid and in excel both) And the main part is I want it will be numeric cell in excel not string cell.

I have added this parts to column  :   DataType="System.Int32" DataFormatString="{0:n0}

but after exporting, this cell format is not numeric .it is string and I should change it to numeric cell manualy . I want it in numeric format .

Thanks in Advanced

[Doug]

maybe try as an sample test to put a number in the header row for that column. with the first row sometimes excel will determine its format type.

[Mahdi]

Hello Mr Doug

Unfortunately it didn't work and My Problem still Exist. but I'm sure there is a Trick to solve This Problem

Is There any  Other Solution(S)?

Please help me

 

 

 

 

[Viktor Tachev]

Hi,

In order for the values in the cells to be formatted correctly you need to ensure that the cell is formatted as number. Check out the following sample that illustrates how you can format the cells in the exported Excel file:

• http://docs.telerik.com/devtools/aspnet-ajax/controls/grid/functionality/exporting/export-formats/word-and-excel-export/excel-format-(html-based)#number-formats--formulas

Regards,
Viktor Tachev
Telerik by Progress