Export Workbook to HTML saves the active worksheet only?

[Edward Brown]

Hello,

I've been testing the export to HTML of an entire multi-sheet workbook. It appears that only the active worksheet is exported. I had hoped it would export each sheet and include in the exported HTML a way to move between the sheets. However I can't find anything online saying what should be exported under these circumstances. Any clarity and / or workarounds would be appreciated.

Thanks

Ed

[Abirami Varadharajan]

Hi Edward, 

Greetings from Syncfusion. 

You can export particular worksheet or an entire workbook to HTML using SaveAsHtml. Please find the code below to save the workbook as HTML. 

//Save the workbook as HTML file 

workbook.SaveAsHtml("Output.html", Syncfusion.XlsIO.Implementation.HtmlSaveOptions.Default); 

You can refer to below documentation and online sample to know more about Exporting excel file as HTML in detail. 

Documentation Link: https://help.syncfusion.com/file-formats/xlsio/working-with-excel-worksheet#save-worksheet-as-html  

Online Sample Link: https://asp.syncfusion.com/demos/web/xlsio/worksheettohtml.aspx  

Regards, 

Abirami 

[Edward Brown]

Thanks for the reply. However, my question was about the conversion of an entire workbook to HTML, and how this is supposed to behave.

For example, if a workbook is made up of three worksheets - then if I use SaveAsHTML on the workbook, it only appears to save the active sheet. I just want to know if this is the expected behaviour, and if there's any way to convert the entire workbook into HTML.

[Abirami Varadharajan]

Hi Edward, 

While converting entire workbook to HTML, active sheet’s content should be visible in the web page. You can switch to view other sheet’s content by clicking the sheet name in the sheet tab at bottom of the page.  

We have prepared video screenshot and sample for your reference which can be downloaded from following links. 

Sample Link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/HTMLConversion-79955478.zip  

Video Screenshot: http://www.syncfusion.com/downloads/support/directtrac/general/ze/145308-1712348792.zip  

If you still face issue, kindly modify the sample above to reproduce the issue and get back to us with an issue reproducing sample which will be helpful for us to validate further from our side. 

Regards, 

Abirami 

[Edward Brown]

Hello,

Thank you for the example. It pointed me in the right direction. The HTML file it produces works fine in Chrome - I get the tabs across the bottom and can click them to switch between the worksheets.

The program I am developing uses the classic ActiveX WebBrowser control (with registry settings to have it use IE11) to display the converted workbook. IE is finding the 'mark of the web' in the top level webpage, and preventing the Tabs frame from loading, as it contains javascript. Therefore, the WebBrowser displays the active worksheet but not the tab area, leading to my initial, incorrect conclusion.

I think I can take it from here, possibly by just removing the mark of the web line.

[Abirami Varadharajan]

Hi Edward, 

Thank you for updating us. 

Yes, you may face sheet navigation issue while opening the output file in Internet Explorer as we restrict running the javascript. We request you to remove below line from the generated file in order to switch between sheet tabs. 

<!-- saved from url=(0014)about:internet --> 

Regards, 

Abirami