XlsIO not compatible with Win8

[Wang Jianwei]

Hi Syncfusion,

I'm using XlsIO to read an excel file.

 Syncfusion.XlsIO.ExcelEngine excelEngine = new Syncfusion.XlsIO.ExcelEngine();
 Syncfusion.XlsIO.IApplication application = excelEngine.Excel;
 Syncfusion.XlsIO.IWorkbook workbook = application.Workbooks.OpenReadOnly(toDir + fileName);
 Syncfusion.XlsIO.IWorksheet sheet = workbook.Worksheets["Custody Positions"];

When I run the program on Win7, it works perfect. But I got the following error when I run on an windows 8 machine.

Description: The process was terminated due to an unhandled exception.
Exception Info: System.OverflowException
Stack:
   at Syncfusion.CompoundFile.XlsIO.Native.PropVariant.FreeName()
   at Syncfusion.CompoundFile.XlsIO.Native.PropVariant.Finalize()

Is it a known compatibility issue? I'm using product version 11.4450.0.26

Thanks.

Jianwei

[Ishwarya Narayanan]

Hi  Wang,

 

Thank you for using Syncfusion products.

 

The reported issue has been fixed in our 12.2 and later versions. But your working version is mentioned as 11.4. To avail this functionality along with other enhancements, we strongly recommend you to upgrade to the latest version.

 

Please let us know if you need any clarification.

 

Regards,

Ishwarya N

[Ilgiz]

Hello,

Can you describe what could be the cause of that exception? as i'm having this exception on Win Server 2008 R2, and upgrading Syncfusion will be hard on my application

[Mathu Mohan Vijayakumar]

Hi Ilgiz,

The improper conversion of IntPtr to Int32 inside the library causes the overflow exception in your application.

Thanks,
Mathu Mohan V A

[Ilgiz]

Thank you. So i can't really find something in used excel document and change it to avoid this exception, can i?

[Mathu Mohan Vijayakumar]

Hi Ilgiz,

Disabling the UseNativeStorage property resolves this issue. This property indicates whether we should use native storage (standard windows COM object) or .NET implementation to open Excel 97-2003 files.

Following code example illustrates this.

// New instance of XlsIO is created[Equivalent to launching MS Excel with no workbooks open].

// Instantiate the spreadsheet creation engine.

ExcelEngine excelEngine = new ExcelEngine();

// Instantiate the Excel application object.

IApplication application = excelEngine.Excel;

// Disabling UseNativeStorage property.

Application.UseNativeStorage = false ;

Thanks,
Mathu Mohan V A

[Abirami Varadharajan]

Hi Richard, 

 

The reported issue has been fixed in our latest versions.It is also recommended to upgrade to our latest version 16.4.0.52 which has more bug fixes, enhancements and features. Latest version can be downloaded from following link. 

 

https://www.syncfusion.com/forums/142466/essential-studio-2018-volume-4-service-pack-release-v16-4-0-52-available-for-download  

 

Regards, 

Abirami.