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.

XlsIO ProgressEventArgs values explained

Thread ID:

Created:

Updated:

Platform:

Replies:

126041 Sep 20,2016 07:05 AM Sep 22,2016 10:06 AM ASP.NET Web Forms 4
loading
Tags: XlsIO
Gareth
Asked On September 20, 2016 07:05 AM

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);
    Console.WriteLine(x);
}

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 09:32 AM

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. 
  
Regards, 
Abirami. 


Gareth
Replied On September 21, 2016 11:21 AM

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.

Gareth

Abirami Varadharajan [Syncfusion]
Replied On September 22, 2016 08:52 AM

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. 
 
Regards, 
Abirami. 


Gareth
Replied On September 22, 2016 10:06 AM

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

Gareth

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.

;