Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Wed Jun 14, 2017 4:30 am

Hi Spire Team,

I am having some difficulty on loading the excel file. The hidden row is still visible on the HTML output.

I have an excel file (.xlsx) with hidden rows and columns. When I tried to open the file on HTML the hidden column is fine it's not visible on the output, but the hidden row is visible on HTML. I can't hide the row since there is no isVisible on row property to check its current state.

Is there any work around to exclude the hidden rows on HTML output?

I am using the following libraries:

Spire.Xls.dll 7.12.0.6040
Spire.pdf.dll 3.9.64.6040

Hope for your immediate response.

Cheers.
Attachments
Excel_Hidden_Row_Col.PNG
Excel_Hidden_Row_Col.PNG (16.59 KiB) Viewed 2452 times

redmap
 
Posts: 7
Joined: Sun Jun 28, 2015 10:33 pm

Wed Jun 14, 2017 8:07 am

Dear redmap,

Thanks for your inquiry.
I have noticed the issue and posted it to our Dev team, once there is any progress, we will inform you.
Sorry for the inconvenience.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Wed Jun 14, 2017 8:27 am

Thanks for your response. Will wait for your feedback then.

Have a great day.

redmap
 
Posts: 7
Joined: Sun Jun 28, 2015 10:33 pm

Thu Jul 27, 2017 7:21 am

Dear redmap,

Thanks for waiting.
Now there is a hotfix which solves your issue, please download it and have a try.
www.e-iceblue.com/downloads/TempVersion ... 2.16.8.zip
If there is any question, please let us know.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Return to Spire.XLS