Importing Excel 2010 file fails

[Richard]

Hi,

I'm trying to use XlsIO v6.302.0.6 to open an Excel 2010 file as follows:

IApplication application = new ExcelEngine().Excel;
IWorkbook workbook = application.Workbooks.Open(filename, ExcelOpenType.Automatic);

This works for Excel 2007 files, but fails with the following error for 2010:

System.NotImplementedException: extLst
at Syncfusion.XlsIO.Implementation.XmlReaders.Excel2007Parser.ParseStyles(XmlReader reader, Stream& streamDxfs)
at Syncfusion.XlsIO.Implementation.XmlSerialization.FileDataHolder.ParseWorkbook()
at Syncfusion.XlsIO.Implementation.XmlSerialization.FileDataHolder.ParseDocument()
at Syncfusion.XlsIO.Implementation.WorkbookImpl.ParseExcel2007Stream(Stream stream)
at Syncfusion.XlsIO.Implementation.WorkbookImpl..ctor(IApplication application, Object parent, Stream stream, ExcelParseOptions options, ExcelVersion version)
at Syncfusion.XlsIO.Implementation.WorkbookImpl..ctor(IApplication application, Object parent, Stream stream, ExcelVersion version)
at Syncfusion.XlsIO.Implementation.ApplicationImpl.CreateWorkbook(Object parent, Stream stream, ExcelVersion version)
at Syncfusion.XlsIO.Implementation.Collections.WorkbooksCollection.Open(Stream stream, ExcelVersion version)
at Syncfusion.XlsIO.Implementation.Collections.WorkbooksCollection.DetectFileFromStream(Stream stream)
at Syncfusion.XlsIO.Implementation.Collections.WorkbooksCollection.Open(Stream stream, ExcelOpenType openType)
at Syncfusion.XlsIO.Implementation.Collections.WorkbooksCollection.Open(String fileName, ExcelOpenType openType)


I assume "extLst" is a new element type, introduced in 2010.

Is there any way I can work around this error?

Thanks.

---
Richard

[Geetha M]

Hi Richard,

Thank you for your interest in Syncfusion products.

Excel 2010 files cannot be opened in v6.3.0.6. But this issue has been fixed in the later versions. Could you please consider upgrading to the latest version?

http://www.syncfusion.com/downloads/latest-version

Currently there is no possible workaround available to open such files in v6.3.0.6 Please let us know if you have any questions.

Regards,
Geetha

[Richard]

Hi Geetha,

Is it possible to use the latest version of XlsIO when exporting v6.302.0.6 of the grids found in Essential Grid for WinForms suite?

I would like to avoid upgrading the grids, as we had a number of problems upgrading in the past.

Thanks for the help.

[Geetha M]

Hi Richard,

It is not possible to refer different versions of Syncfusion assemblies in a single application.

Regards,
Geetha

[Richard]

Thanks again, Geetha.

[Geetha M]

Hi Richard,

Thank you for the update.

Regards,
Geetha

[Bijal]

Hi,

I am using XlsIo v10.103.0.44. I am trying to open Excel 2010 (.xlsx) file containing more than 65K rows and 6 sheets.

when I try to open using;

//Step 1 : Instantiate the spreadsheet creation engine.

ExcelEngine excelEngine = new ExcelEngine();

//Step 2 : Instantiate the excel application object.

IApplication application = excelEngine.Excel;

IWorkbook workbook = null;

workbook = application.Workbooks.Open("myExcelFile.xlsx", ExcelOpenType.Automatic);

//other code....

It throws Overflow exception at 'Workbooks.Open' as; "Value was either too large or too small for an Int32."

Kindly suggest to resolve the issue.

Can I not use XlsIO v10.1 for opening Excel 2010 (.xlsx) file?

Thanks in advance.

-Bijal

[Sridhar]

Hi Bijal,

Thank you for using Syncfusion products.

We regret for the inconvenience caused. Could you please send us a sample Excel(.xlsx) document which  reproduces the above reported exception with XlsIO so that we are able to proceed further and we will provide a solution at the earliest for the same.

Please let me know if you require any further clarifications.

Regards,
Sridhar.S

[Bijal]

Thanks Sridhar.

Attaching my excel template file (.xlsx), I am trying to open using syncfusion version 10.103.0.44.

any sample code, which is opening attached .xlsx file using C#.NET would be very helpful.

Thanks in advance.

-Bijal

 

 

mytemplate_3_64406bab.zip

[Bijal]

Can some one respond to the query I've posted/

unable to open .xlsx file using syncfusion v10.103. attached xlsx template for reference.

[Sridhar]

Hi Bijal,

 

Thank you so much for the update.

 

We are able to reproduce the exception “stack over flow exception while opening the excel file” with XlsIO. Please open a new direct-trac incident with a simple issue reproducing excel file  and stack trace of an error for further follow up on this issue.

 

Direct-Trac Link:
https://www.syncfusion.com/account/login?ReturnUrl=%2fsupport%2fdirecttrac%2fincidents

Please let me know if you require any further clarifications.

 

Thanks,

Sridhar.S

[Bijal]

Could you kindly share sample code top open same .xlsx file thru C#.Net ?

Does Syncfusion v10.103 not supporting to work with .xlsx file?

Thanks

-Bijal

[Sridhar]

Hi Bijal,

 

Please get the following code for opening the above reported excel file.

 

ExcelEngine excelEngine = new ExcelEngine();

 IApplication application = excelEngine.Excel;
                           
IWorkbook workbook = application.Workbooks.Open((string)textBox1.Tag, ExcelOpenType.Automatic);

 

We could see the issue with 10.3.0.43 version. We have already posted this query in the incident 100509 for further follow-up on this issue. Please updaet and follow-up the incident 100509 for further more updates.

 

Let me know if you require any further clarifications.

 

Thanks,

Sridhar.S