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.
Unfortunately, activation email could not send to your email. Please try again.

Cannot open slightly large excel file.

Thread ID:

Created:

Updated:

Platform:

Replies:

103665 May 23,2012 04:53 AM Jun 15,2012 06:02 AM Silverlight 5
loading
Tags: XlsIO
Jaeyeol Shin
Asked On May 23, 2012 04:53 AM

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 [Syncfusion]
Replied On May 24, 2012 08:43 AM

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:
 

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
Replied On June 11, 2012 01:33 AM

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 [Syncfusion]
Replied On June 12, 2012 09:29 AM

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
Replied On June 14, 2012 05:05 AM

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 [Syncfusion]
Replied On June 15, 2012 06:02 AM

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


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.

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.

;