Excel: Problem with Datagrid-generated XML-file
C#
1
Posts
1
Posters
0
Views
1
Watching
-
Hi all, I read data from a database, fill a datagrid with them and create an XML-File via datagrid.RenderControl() So I get an XML-file with extension xls, which Excel can read.
But with some field values Excel gets lost. Example of such a file (save as test.xls): Text Date Value1 Value2 First 2006-01-26 0 0 +Second 2006-01-26 0 0 Third 2006-01-26 0 0The first line shows okay in Excel, but after the '+'-Sign in the second line all date- and numberfields are shown as text fields. Now for calculations all first have to be converted. Does anyone know how to avoid this problem? Thank you! Martin 2B||!2B?