Cannot open slightly large excel file.

[Jaeyeol Shin]

ExcelEngine.Excel.Workbooks.Open(FileStream, ExcelOpenType) method doesn't work. I tried to debug my silverlight application using XlsIO libraries and I knew that my program stopped at the code using Open(FileStream, ExcelOpenType) method. An excel file I Tried to open is 5,099KB. How can I open this file?

[Sridhar]

Hi Jaeyeol,

 

Thank you for using Syncfusion products.

 

We have tried the silverlight sample for openign the large excel file with Essential XlsIO and we could see the file is openign without any issues. We have attached the sample for your refernece with this update.

 

Sample Link:

 

http://www.syncfusion.com/downloads/Support/DirectTrac/94708/Open%20Excel1658960779.zip

Please try the sample and let us know if this helps you. If you still face the issue, please get back to us with the excel file which reproduces the issue and the simplified sample to proceed further on this.

Please let me know if you require any further clarifications.

 

Thanks,
Sridhar.S

Open Excel_67f76dc4.zip

[Jaeyeol Shin]

thank you for your kind answer.

But I didn't mean creating new excel file. I couldn't open an existing excel file using XlsIO libraries. An example that open an existing excel file can help me.

[Sridhar]

Hi Jaeyeol,

 

Thank you so much for the update.

 

The sample provided in our previous post is to demonstrate that the silverlight application for opening the largest excel file with Essential XlsIO.Can you please take a look and try the above attached sample at your side and let us know if this helps you.

 

If you still face the issue, please get back to  us with the excel file which reproduces the issue to proceed further on this.

 

Please let me know if you require any further more clarifications.

 

Thanks,

Sridhar.S

[Jaeyeol Shin]

Thank you for kind answer.

I have met a System.ArgumentOutOfRangeException while opening an excel file for test.

Below attachment contains a test excel file I used.

DiableToReadUsingXlsIO_605e7e37.zip

[Sridhar]

Hi Jaeyeol Shin,

 

Thank you so much for the update.

 

We are unable to reproduce the above reported exception “Argument out of range exception” while opening the excel file with Silverlight application. We have verified this with our latest versions 10.2.0.56 and 10.2.0.75. Please try to open the above excel file with our latest versions and let us know if this helps you. Also, please update us with the essential studio version you are using so that we are able to proceed further on this.

 

If you still face any issues with our latest version while opening the excel files, please open a new direct-trac incident with a simple issue reproducing excel file 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