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. (Last updated on : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

xlsio exception

Thread ID:

Created:

Updated:

Platform:

Replies:

76578 Sep 15,2008 10:07 AM UTC Feb 19,2018 07:28 AM UTC WinForms 15
loading
Tags: XlsIO
xieyun
Asked On September 15, 2008 10:07 AM UTC

say hello to everybody,i met a exception when i export excel to datatable use xlsio.the stack trace like this:
At Syncfusion.XlsIO.Implementation.RangeImpl.GetStringValue()
At Syncfusion.XlsIO.Implementation.RangeImpl.get_Value()
At Syncfusion.XlsIO.Implementation.WorksheetImpl.GetValue(Int32 iRow, Int32 iColumn, ExcelExportType formatType, Boolean bExportFormulaValues, IMigrantRange range)
At Syncfusion.XlsIO.Implementation.WorksheetImpl.ExportDataTable(Int32 firstRow, Int32 firstColumn, Int32 maxRows, Int32 maxColumns, ExcelExportDataTableOptions options)

ps:i used the version of syncfusion is 6.2.0.40.
regards!
thanks.


xieyun
Replied On September 15, 2008 10:17 AM UTC

PS:the exception was:
System.NullReferenceException was unhandled
Message="Object reference not set to an instance of an object."

regards
XY.Pupiya

>say hello to everybody,i met a exception when i export excel to datatable use xlsio.the stack trace like this:
At Syncfusion.XlsIO.Implementation.RangeImpl.GetStringValue()
At Syncfusion.XlsIO.Implementation.RangeImpl.get_Value()
At Syncfusion.XlsIO.Implementation.WorksheetImpl.GetValue(Int32 iRow, Int32 iColumn, ExcelExportType formatType, Boolean bExportFormulaValues, IMigrantRange range)
At Syncfusion.XlsIO.Implementation.WorksheetImpl.ExportDataTable(Int32 firstRow, Int32 firstColumn, Int32 maxRows, Int32 maxColumns, ExcelExportDataTableOptions options)

ps:i used the version of syncfusion is 6.2.0.40.
regards!
thanks.




xieyun
Replied On September 16, 2008 12:54 AM UTC

please tell me why,how to dealing with it?
it's occured with high frequency!
hope your reply.

best wish~


Geetha M [Syncfusion]
Replied On September 16, 2008 11:46 AM UTC

Hi,

Thank you for your interest in Syncfusion products.

Could you please send us your Excel sheet so that we could be able to sort out the cause of the issue?

Regards,
Geetha


xieyun
Replied On September 17, 2008 02:20 AM UTC

ok,plz see the attachment
thanks very much!

>Hi,

Thank you for your interest in Syncfusion products.

Could you please send us your Excel sheet so that we could be able to sort out the cause of the issue?

Regards,
Geetha





07年数据_97607fd1.zip

xieyun
Replied On September 17, 2008 05:44 AM UTC

this file with the parsedoule exception:
at Syncfusion.XlsIO.Implementation.RangeImpl.ParseDouble(IDoubleValue value)
at Syncfusion.XlsIO.Implementation.RangeImpl.Parse(IList data, Int32& position, Boolean ignoreStyles)
at Syncfusion.XlsIO.Implementation.RangeImpl.Parse(BiffRecordRaw[] data, Int32& position)
at Syncfusion.XlsIO.Implementation.RangeImpl..ctor(IApplication application, Object parent, BiffRecordRaw[] data, Int32 position)
at Syncfusion.XlsIO.Implementation.RangeImpl..ctor(IApplication application, Object parent, BiffRecordRaw record, Boolean bIgnoreStyles)
at Syncfusion.XlsIO.Implementation.ApplicationImpl.CreateRange(Object parent, BiffRecordRaw record, Boolean bIgnoreStyles)
at Syncfusion.XlsIO.Implementation.WorksheetImpl.ConvertRecordToRange(BiffRecordRaw record)
at Syncfusion.XlsIO.Implementation.WorksheetImpl.InnerGetCell(Int32 column, Int32 row, Int32 iXFIndex)
at Syncfusion.XlsIO.Implementation.WorksheetImpl.InnerGetCell(Int32 column, Int32 row)
at Syncfusion.XlsIO.Implementation.RangeImpl.get_Item(Int32 row, Int32 column)
at Syncfusion.XlsIO.Implementation.WorksheetImpl.ExportDataTable(Int32 firstRow, Int32 firstColumn, Int32 maxRows, Int32 maxColumns, ExcelExportDataTableOptions options)
at Syncfusion.XlsIO.Implementation.WorksheetImpl.ExportDataTable(IRange range, ExcelExportDataTableOptions options)


Regards~thx
any sugession plz let me know

>Hi,

Thank you for your interest in Syncfusion products.

Could you please send us your Excel sheet so that we could be able to sort out the cause of the issue?

Regards,
Geetha





2月数据_f7c2b2e9.zip

Geetha M [Syncfusion]
Replied On September 17, 2008 10:20 AM UTC

Hi,

I am not able to download the attachments you sent. Could you please email them to support@syncfusion.com with the forum id as subject?

Regards,
Geetha


Administrator [Syncfusion]
Replied On September 17, 2008 11:39 AM UTC


ok,send out,plz check.

Best Wish!
xieyun
>Hi,

I am not able to download the attachments you sent. Could you please email them to support@syncfusion.com with the forum id as subject?

Regards,
Geetha




Geetha M [Syncfusion]
Replied On September 18, 2008 09:08 AM UTC

Hi,

Thank you for the details.

I am able to process the following Excel files successfully using Essential XlsIO v6.3.1.8
with item already exists exception.xls
with parsedouble exception.xls

The following file worked fine after re saving using MS Excel. So there is a possibility that the file could be a corrupted one. Could you please try the re saving using MS Excel and let me know?
车辋2月.xls

I am able to reproduce System.ArgumentException when opening the following two files:
榕佑12月.xls
榕右门诊.xls

Could you please create a new incident in Direct Trac with the forum id as subject so that we could send you the necessary information regarding the issue and fix for the two files (榕佑12月.xls and 榕右门诊.xls)?

Please let me know if you have any concerns.

Regards,
Geetha


xieyun
Replied On September 18, 2008 09:14 AM UTC

ok,thx,let me try.and report the result.

Regards,
xieyun

>Hi,

Thank you for the details.

I am able to process the following Excel files successfully using Essential XlsIO v6.3.1.8
with item already exists exception.xls
with parsedouble exception.xls

The following file worked fine after re saving using MS Excel. So there is a possibility that the file could be a corrupted one. Could you please try the re saving using MS Excel and let me know?
车辋2月.xls

I am able to reproduce System.ArgumentException when opening the following two files:
榕佑12月.xls
榕右门诊.xls

Could you please create a new incident in Direct Trac with the forum id as subject so that we could send you the necessary information regarding the issue and fix for the two files (榕佑12月.xls and 榕右门诊.xls)?

Please let me know if you have any concerns.

Regards,
Geetha




xieyun
Replied On September 18, 2008 09:21 AM UTC

Now i resaved the file "车辋2月.xls" as "车辋2月_bak.xls" with ms excel.It could be open,but when i export data as this:ExportDataTable(xlsWorkbook.Worksheets[i].UsedRange, ExcelExportDataTableOptions.ComputedFormulaValues);-------when load the spreadsheet named "Sheet2" the same exception(nullreferenceexception) occured again.

>Hi,

Thank you for the details.

I am able to process the following Excel files successfully using Essential XlsIO v6.3.1.8
with item already exists exception.xls
with parsedouble exception.xls

The following file worked fine after re saving using MS Excel. So there is a possibility that the file could be a corrupted one. Could you please try the re saving using MS Excel and let me know?
车辋2月.xls

I am able to reproduce System.ArgumentException when opening the following two files:
榕佑12月.xls
榕右门诊.xls

Could you please create a new incident in Direct Trac with the forum id as subject so that we could send you the necessary information regarding the issue and fix for the two files (榕佑12月.xls and 榕右门诊.xls)?

Please let me know if you have any concerns.

Regards,
Geetha




xieyun
Replied On September 18, 2008 09:31 AM UTC

Ok,new incident created,9 as the subject,thx for your help

Regards,
xieyun

>Hi,

Thank you for the details.

I am able to process the following Excel files successfully using Essential XlsIO v6.3.1.8
with item already exists exception.xls
with parsedouble exception.xls

The following file worked fine after re saving using MS Excel. So there is a possibility that the file could be a corrupted one. Could you please try the re saving using MS Excel and let me know?
车辋2月.xls

I am able to reproduce System.ArgumentException when opening the following two files:
榕佑12月.xls
榕右门诊.xls

Could you please create a new incident in Direct Trac with the forum id as subject so that we could send you the necessary information regarding the issue and fix for the two files (榕佑12月.xls and 榕右门诊.xls)?

Please let me know if you have any concerns.

Regards,
Geetha




Geetha M [Syncfusion]
Replied On September 19, 2008 12:12 PM UTC

Hi,

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

Regards,
Geetha


Geetha M [Syncfusion]
Replied On September 19, 2008 12:12 PM UTC

Hi,

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

Regards,
Geetha


MOHAMEDALAA DOUZI
Replied On February 16, 2018 02:51 PM UTC

ok,thx,let me try.and report the result.

Regards,
xieyun

>Hi,

Thank you for the details.

I am able to process the following Excel files successfully using Essential XlsIO v6.3.1.8
with item already exists exception.xls
with parsedouble exception.xls

The following file worked fine after re saving using MS Excel. So there is a possibility that the file could be a corrupted one. Could you please try the re saving using MS Excel and let me know?
车辋2月.xls

I am able to reproduce System.ArgumentException when opening the following two files:
榕佑12月.xls
榕右门诊.xls

Could you please create a new incident in Direct Trac with the forum id as subject so that we could send you the necessary information regarding the issue and fix for the two files (榕佑12月.xls and 榕右门诊.xls)?

Please let me know if you have any concerns.

Regards,
Geetha




thank you

Abirami Varadharajan [Syncfusion]
Replied On February 19, 2018 07:28 AM UTC

Hi Mohamedalaa, 
 
Thank you for contacting Syncfusion support. 
 
Could you please confirm us if you are facing issue similar to the one which was updated earlier in this post ? If your issue differs, please share us more details about the same which will be helpful for us to provide prompt solution at the earliest. 
 
Regards, 
Abirami.  


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.

Warning Icon 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.Close Icon

;