xlsio exception

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.


15 Replies

XI xieyun 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.





XI xieyun 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~



GM Geetha M Syncfusion Team 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



XI xieyun 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


XI xieyun 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


GM Geetha M Syncfusion Team September 17, 2008 10:20 AM UTC

Hi,

I am not able to download the attachments you sent. Could you please email them to [email protected] with the forum id as subject?

Regards,
Geetha



AD Administrator Syncfusion Team 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 [email protected] with the forum id as subject?

Regards,
Geetha





GM Geetha M Syncfusion Team 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



XI xieyun 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





XI xieyun 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





XI xieyun 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





GM Geetha M Syncfusion Team September 19, 2008 12:12 PM UTC

Hi,

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

Regards,
Geetha



GM Geetha M Syncfusion Team September 19, 2008 12:12 PM UTC

Hi,

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

Regards,
Geetha



MD MOHAMEDALAA DOUZI replied to xieyun 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


AV Abirami Varadharajan Syncfusion Team 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.  


Loader.
Up arrow icon