Hi,
I m using Infragistics3 Excel ver9, trying to load a workbook/worksheet into a datatable. I found out that a cell that has cell format as custom Date, after loading into the Infragistics cell, it displayed as Double and the value is disorted. I also tried to change the Infragistics cell format to empty or General, but the value still is distorted as double.
How can i get the exact value as stored in MS Excel which has custom format ?
I have the same problem too: "How understand if a cell contain a Date" ?
The only solution I could implement so far is to custom parsing the CellFormat.FormatString property of the cell; although this is a very ugly workaround, that's the only one I saw.
Any better suggestions?Thanks in advance
Gianni
I see, ok I will try to workaround it and maybe will come back with question later.
thanks
No, any import into a data structure must be done manually. I don't think it would be possible for automatic support like this anyway, because those data sources are row-based and the Excel grid is cell-based.
I can try to workaround that with manual convert the cell back to date value by detecting the format string.
Besides, is there any ready built class from infragistics to Import Excel file into datatable/dataset ?
Thanks
You can submit a feature request to DS for us to auto-parse the value into it's correct type based on the format string. Other than that, I recommend reading the format string property of the cell. If it is a common date format string, use the conversion method.