Hidden columns are not rendering as hidden

Support,

We are attempting to render Excel Worksheets to HTML for web viewing. In our testing, we found hidden columns are not rendering hidden.

I have included a sample Excel document which will allow you to reproduce the issue.

Please use the “Sheet 1” worksheet for your testing.

Thank you

/* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin;}

<![endif]–>

Hi Abby,

Thank you for using Aspose products.

If you do not wish to render the hidden columns and rows, please set the HtmlSaveOptions.HiddenColDisplayType property accordingly. Please check the below provided complete code snippet and attached output for your reference.

C#


Workbook book = new Workbook(myDir + “Document+10±+Hidden+Columns.xlsx”);
HtmlSaveOptions option = new HtmlSaveOptions();
option.HiddenColDisplayType = HtmlHiddenColDisplayType.Hidden;
book.Save(myDir + “output.html”, option);


Please note, we have verified this scenario with latest build of Aspose.Cells for .NET 7.7.1.2.