We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

get per cell''s value as string however

Thread ID:

Created:

Updated:

Platform:

Replies:

76649 Sep 17,2008 10:05 PM Sep 19,2008 08:13 AM Windows Forms 5
loading
Tags: XlsIO
xieyun
Asked On September 17, 2008 10:05 PM

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
Replied On September 17, 2008 11:00 PM

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
Replied On September 17, 2008 11:27 PM

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 [Syncfusion]
Replied On September 18, 2008 06:33 AM

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
Replied On September 18, 2008 07:31 AM

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 [Syncfusion]
Replied On September 19, 2008 08:13 AM

Hi,

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

Regards,
Geetha


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;