Write peoducure to convert exiting exel worksheet data and charts to an HTML documventswtite procedure to point only an embledded chart in a work sheet
Answers
Answered by
0
Convert Excel tables to HTML using "Save as Web Page" option.
Using this method you can save an entire workbook or any portion of it, such as a selected range of cells or chart, to a static web page (.htm or .html) so that anyone can view your Excel data on the web.
For example, you have created a feature-rich report in Excel and now want to export all the figures along with a pivot table and chart to your company's web-site, so that your workmates can view it online in their web-browsers without opening Excel.
To convert your Excel data to HTML, perform the following steps. These instructions apply to all "ribboned" versions of Excel 2016, 2013, 2010 and 2007:
On the workbook, go to the File tab and click Save As.
If you want to export some portion of data only, e.g. a range of cells, pivot table or graph, select it first.
In the Save As dialog, choose one of the following:Web Page (.htm; .html). This will save your workbook or the selection to a web page and create a supporting folder that will store all of the page's supporting files such as images, bullets and background textures.Single File Web Page (.mht; .mhl). This will save your workbook or the selection to a single file with supporting files embedded into the web page.
If you selected a range of cells, a table or a chart before clicking Save as, then select the Selectionradio button, click Save and you are close to finished.
If you have not selected anything yet, continue with the following steps.
To save the entire workbook, including all the worksheets, graphics and tabs for navigating between sheets, select Entire Workbook.To save the current worksheet, chooseSelection: Sheet. In the next step you will be given a choice whether to publish the whole worksheet or some of the items.
You can also set a title for your web-page now by clicking the Change Title... button in the right-hand part of the dialog window. You will also be able to set or change it later, as described in step 6 below.
Click the Publish button and this will open thePublish as Web Page dialog window. Let's briefly go through each of the available options, from top to bottom.Items to publish. Here you choose what portion(s) of your Excel workbook you want to export to a web-page.
In the drop-down list next to Choose, you have the following choices:
Entire workbook. The whole workbook will be published, including all of the worksheets and tabs to navigate between sheets.Entire worksheet or certain items on a worksheet, such as pivot tables, charts, filtered ranges and External data ranges. You select "Items on SheetName", and then choose either "All contents" or particular items.
Ranges of cells. Select Range of cells in the drop-down list and then click the Collapse Dialogicon to select the cells you want to publish.Previously published items. Select this option if you want to republish a worksheet or items you have already published. If you'd rather not republish a certain item, select the item in the list and click the Remove button.Title of the web-page. To add a title that will be displayed in the title bar of the browser, click theChange button next to Title: and type in the title you want.
Click the Browse button next to File name and choose the hard drive, folder, web folder, web server, HTTP site, or FTP location where you want to save your web page.
Tips: If you are converting an Excel workbook to an HML file for the first time, it makes sense to save the web page onto your local hard drive first so that you can make the needed corrections before publishing the page on the web or your local network.
You can also choose to export your Excel file to an existing web page provided that you have permissions to modify it. In this case, upon clicking the Publish button, you will see a message prompting you to choose whether you want to overwrite the content of the existing web-page or append your data to the end of the web page. If the former, clickReplace; if the latter, click Add to file.
R
Using this method you can save an entire workbook or any portion of it, such as a selected range of cells or chart, to a static web page (.htm or .html) so that anyone can view your Excel data on the web.
For example, you have created a feature-rich report in Excel and now want to export all the figures along with a pivot table and chart to your company's web-site, so that your workmates can view it online in their web-browsers without opening Excel.
To convert your Excel data to HTML, perform the following steps. These instructions apply to all "ribboned" versions of Excel 2016, 2013, 2010 and 2007:
On the workbook, go to the File tab and click Save As.
If you want to export some portion of data only, e.g. a range of cells, pivot table or graph, select it first.
In the Save As dialog, choose one of the following:Web Page (.htm; .html). This will save your workbook or the selection to a web page and create a supporting folder that will store all of the page's supporting files such as images, bullets and background textures.Single File Web Page (.mht; .mhl). This will save your workbook or the selection to a single file with supporting files embedded into the web page.
If you selected a range of cells, a table or a chart before clicking Save as, then select the Selectionradio button, click Save and you are close to finished.
If you have not selected anything yet, continue with the following steps.
To save the entire workbook, including all the worksheets, graphics and tabs for navigating between sheets, select Entire Workbook.To save the current worksheet, chooseSelection: Sheet. In the next step you will be given a choice whether to publish the whole worksheet or some of the items.
You can also set a title for your web-page now by clicking the Change Title... button in the right-hand part of the dialog window. You will also be able to set or change it later, as described in step 6 below.
Click the Publish button and this will open thePublish as Web Page dialog window. Let's briefly go through each of the available options, from top to bottom.Items to publish. Here you choose what portion(s) of your Excel workbook you want to export to a web-page.
In the drop-down list next to Choose, you have the following choices:
Entire workbook. The whole workbook will be published, including all of the worksheets and tabs to navigate between sheets.Entire worksheet or certain items on a worksheet, such as pivot tables, charts, filtered ranges and External data ranges. You select "Items on SheetName", and then choose either "All contents" or particular items.
Ranges of cells. Select Range of cells in the drop-down list and then click the Collapse Dialogicon to select the cells you want to publish.Previously published items. Select this option if you want to republish a worksheet or items you have already published. If you'd rather not republish a certain item, select the item in the list and click the Remove button.Title of the web-page. To add a title that will be displayed in the title bar of the browser, click theChange button next to Title: and type in the title you want.
Click the Browse button next to File name and choose the hard drive, folder, web folder, web server, HTTP site, or FTP location where you want to save your web page.
Tips: If you are converting an Excel workbook to an HML file for the first time, it makes sense to save the web page onto your local hard drive first so that you can make the needed corrections before publishing the page on the web or your local network.
You can also choose to export your Excel file to an existing web page provided that you have permissions to modify it. In this case, upon clicking the Publish button, you will see a message prompting you to choose whether you want to overwrite the content of the existing web-page or append your data to the end of the web page. If the former, clickReplace; if the latter, click Add to file.
R
Similar questions