Hi,
I have a function that reads an excel file, and loads the data into the PivotGrid.
Is there any way to find out the data type of the values read in. For example I want to be able to differentiate between strings and doubles and dates. The is no way to get the data type of the cell from WorksheetCell.
Thanks
Sangeetha
Hello,
Excuse us for the delay. We have a direct way to use excel files into pivot grid. Have you tried to use FlatDataSource with ExcelDataConnectionSettings?
Regards.
Plamen.
Hi Plamen,
Yes I just tried this alternative and it works great. I don't have to know the data/data type and do any kind of conversion - very neat.
I would like some clarification about FlatDataSource to help me better understand it though. I notice that when FlatDataSource is created through a stream its ItemsSource is null, so if I want to retrieve this data how can I do it?