get per cell''s value as string however

[xieyun]

hi,
i want to reading all the sheet's data to a datatable via ExportDataTable method,but it seem automaticly to detect the datatype of the sheet's column.but sometimes the exception occured,so i can't read the content from this sheet.if there is a way to reading the data to datatable but every cell's value represents as string?need your help.

Regards,
xieyun

[xieyun]

I had set work sheet's property:xlsWorkbook.Worksheets[i].IsStringsPreserved = true;
but got the same nullrefrenceexception when i want to getproperty or alll the method ExportDataTable(xlsWorkbook.Worksheets[i].UsedRange, ExcelExportDataTableOptions.ComputedFormulaValues).at least 50 excel files met this.

Regards,
xieyun

[xieyun]

Now i copied those file to Data directory and import with the sample "$SamplesInstallationDirectory\EssentialStudio\6.3.1.8\Windows\XlsIO.Windows\Samples\2.0\Data Binding\ImportExportDataTable\CS\ImportExportDataTable_2005.sln" project,but i got the same exception.
:( i'm waitting for this to dealing with my excel files.because this product excellent at the processing speed both read and write.
the only problem i used many means with it,but it seems no use.If i modified some content it'll be pass,but so many files has the same problem.

Regards,
xieyun

[Geetha M]

Hi,

Thank you for your interest in Syncfusion products.

I have created a simple sample that exports Excel to Datatable by using one of the file you sent to us. But I am not able to reproduce the issue. Could you please try running the sample at you end?

http://websamples.syncfusion.com/samples/XlsIO.Windows/F76578/main.htm

If you still face any issues, could you please send us a sample Excel file along code snippet?

Please let me know if you have any concerns.

Regards,
Geetha

[xieyun]

hello,Geetha
the project i sent on my incident,please check,thx whatever.

Regards,
xieyun

>Hi,

Thank you for your interest in Syncfusion products.

I have created a simple sample that exports Excel to Datatable by using one of the file you sent to us. But I am not able to reproduce the issue. Could you please try running the sample at you end?

http://websamples.syncfusion.com/samples/XlsIO.Windows/F76578/main.htm

If you still face any issues, could you please send us a sample Excel file along code snippet?

Please let me know if you have any concerns.

Regards,
Geetha

[Geetha M]

Hi,

Could you please followup with the direct trac incident you created on this regard?

Regards,
Geetha