xlsio exception

[xieyun]

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]

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]

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

best wish~

[Geetha M]

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]

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]

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]

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

[Administrator]

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

[Geetha M]

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]

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]

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]

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]

Hi,

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

Regards,
Geetha

[Geetha M]

Hi,

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

Regards,
Geetha

[MOHAMEDALAA DOUZI]

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]

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.