When I export some data to excel, and open it with excel 2003, every number cell has a green triangle in the top left corner and has the error "Number stored as text". How do I specify that the cell contains a number?
The way I'm adding data to the excel file is:
Workbook workbook = new Workbook();workbook.Worksheets.Clear();Worksheet sheet = workbook.Worksheets.Add("Test");sheet.Rows[0].Cells[0].Value = "String"sheet.Rows[0].Cells[1].Value = 0.0;BIFF8Writer.WriteWorkbookToFile(workbook, filename);
Thanks.
-Nick
Hi Nick,
I just ran the code you have here and it works fine for me. You should not have to do anything special - numbers should be exported as numbers.
What version of the controls are you using? Perhaps you need to get the latest service release? How to get the latest service release - Infragistics Community
How do you set the export datatype when the grid is bound to a datatable that has double dataype columns.