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.

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.

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

best wish~

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

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

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

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

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

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

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

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

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

Hi,

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

Regards,
Geetha

Hi,

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

Regards,
Geetha

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