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 ProgressEventArgs values explained

Thread ID:





126041 Sep 20,2016 11:05 AM UTC Sep 22,2016 02:06 PM UTC ASP.NET Web Forms 4
Tags: XlsIO
Asked On September 20, 2016 11:05 AM UTC

I'm  currently investigating the ProgressEventHandler for the XlsIO. I see that the ProgressEventArgs has two readonly values, Position and FullSize. Does anyone know what these values actually mean? There is a massive difference in the values that are returned when processing an XLSX and XLS. The XLS value looks like it might be rows, but the XLSX is a puzzle as it seems to be more than the number of worksheets in the file, but a lot less than the number of rows.

private void ActionProgressEvent(object sender, ProgressEventArgs args)
    string x = string.Format("{1} - {0}", args.FullSize, args.Position);

excelEngine.Excel.ProgressEvent += ActionProgressEvent;

The reason I'm look at this, is that I have problematic Excel files that I'm trying to open unsuccessfully. I'm hoping that once I understand the values I can use the information to narrow down where the issue preventing me from opening the file.

Thanks in advance for any help or advice you can provide.

Abirami Varadharajan [Syncfusion]
Replied On September 21, 2016 01:32 PM UTC

Hi Gareth, 
Thank you for contacting Syncfusion support. 
The parameters Position and FullSize denotes the cursor position and full size of the file stream while parsing. It doesn’t mean the rows and worksheets count of the Excel document. 
It would be better if you could share us the file that cause the issue at your end. This which will be helpful for us to provide a prompt solution at the earliest. 

Replied On September 21, 2016 03:21 PM UTC

Hi Abirami,

I'm not trying to use this on a specific issue, but use it to aid in diagnosing an issue. Rather than try and guess where an issue is, I was hoping this would allow use to narrow the location so we can investigate.

We have the issue that due to company policy we can't send client documents, so we need to understand the issue so we can create a clean document to send to Syncfusion.


Abirami Varadharajan [Syncfusion]
Replied On September 22, 2016 12:52 PM UTC

Hi Gareth, 
Thank you for updating us. 
Kindly provide us the duplicate copy of the input document with dummy element content in the place of your confidential data. So that we could analyze the exact cause of the issue and will provide you the prompt solution at the earliest. 
Note: This document will be used only for reproducing issue and testing purposes to avoid such issue in future. 

Replied On September 22, 2016 02:06 PM UTC

Thanks for your reply Abirami. I think we can close this thread. You answered my question.



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.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

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