Question

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

Answer 1



Primary School

Computer science

5 points

Write procedure to convert existing Excel worksheet data and chart to an HTML document

Advertisement

Ask for details 

Follow

Report

 by Sanjaytodkar08.10.2017

Answers

Me · Beginner

Know the answer? Add it here!



MayankGBN

Virtuoso

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.