Saving an Excel workbook as HTML document is necessary whenever it is required to publish reports generated in Excel on Web portals.
The following are the steps to save an Excel sheet as HTML document.
1) Open the Excel workbook which you want to save as HTML.
2) Select File menu and click "Save As" from drop down menu.
3) Now in "Save as" window pop up, type the name of the file and in "save as type" field select
"save as single file web page".
4) Once the "save as type" is selected, check "selection :sheet" and click on publish as
shown below.
5) Now, In "publish as" pop up window, select the sheet which you want to publish as html document and change the name and path where you want to save document. Make sure that AutoRepublish checkbox is checked (to keep original file and HTML document synchronized) and click on Publish.
6) Now, the saved HTML page can be viewed in web browser. Changes made in the original file are automatically reflected in web page on refreshing.
2) Select File menu and click "Save As" from drop down menu.
3) Now in "Save as" window pop up, type the name of the file and in "save as type" field select
"save as single file web page".
4) Once the "save as type" is selected, check "selection :sheet" and click on publish as
shown below.
5) Now, In "publish as" pop up window, select the sheet which you want to publish as html document and change the name and path where you want to save document. Make sure that AutoRepublish checkbox is checked (to keep original file and HTML document synchronized) and click on Publish.
6) Now, the saved HTML page can be viewed in web browser. Changes made in the original file are automatically reflected in web page on refreshing.
0 comments:
Post a Comment