Greetings,
I'm exporting data from a WebGrid to Excel via UltraWebGridExcelExporter. Some cells are strings and others are numbers. Does anyone have code examples of how to get UltraWebGridExcelExporter to properly export numeric values as actual Integer/Double Excel cells?
In other words, right now I'm getting the software to export an Excel spreadsheet but every cell is a String format. I must manually modify cells into Double format.
Thanks!
Hi Al,
I am just checking if you got the exporter working or you have any furthered questions.
Hello Dimi,
Thank you very much for following up with me. I'm still not able to solve this issue.
I applied the following formatting to each cell:
worksheet.Rows.Item(row).Cells.Item(col).CellFormat.FormatString = "#,##0.00"
When I open the exported Excel workbook, each of the cells are still formatted as text, not numbers. People that use these exported Excel workbooks must do something like the following: http://office.microsoft.com/en-us/excel-help/convert-numbers-stored-as-text-to-numbers-HP003055900.aspx
We're using Infragistics version 8.3 (2008), Excel 2003.
Thanks in advance!