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 : November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

XlsIO not compatible with Win8

Thread ID:

Created:

Updated:

Platform:

Replies:

118546 Mar 18,2015 09:22 AM UTC Oct 13,2015 08:47 AM UTC WPF 5
loading
Tags: XlsIO
Wang Jianwei
Asked On March 18, 2015 09:22 AM UTC

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 [Syncfusion]
Replied On March 19, 2015 06:46 AM UTC

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
Replied On October 9, 2015 06:45 AM UTC

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 [Syncfusion]
Replied On October 12, 2015 10:02 AM UTC

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
Replied On October 13, 2015 05:29 AM UTC

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 [Syncfusion]
Replied On October 13, 2015 08:47 AM UTC

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


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

;