ExportDataTable Problems

Aspose.Cells Product Family
1

I am attempting to utilize the ExportDataTable method and am coming accros some difficulties.

In some cases it works fine. In others I get type conversion errors.

Most of the Worksheets I am dealing with will have mixed data type contents in a column. I just want to load all the data into a DataTable as text while doing the appropriate conversions, as needed.

Is there a way to specify this in the method call?

Thanks,

-Steven Perry
Tongue Tied

2

If you use ExportDataTable method, the data type in a column should be same. Otherwise, please try ExportDataTableAsString method.