Write procedure to convert exting excel worksheet data and charts to an HTML document
Answers
Answered by
9
By Using Internet Assistant Wizard.
Steps :
1. click on file tab and click Save As.
2. In the save as dialog, choose Web Page(.html,.htm).
3. If you selected a range of cells, a table or a chart before clicking Save as then select the Selection radio button, click Save and you are close to finished.
4. To save the entire workbook, including all the worksheets, graphics and tabs for navigating between sheets, select Entire Workbook.
To save the current worksheet, choose Selection: Sheet. In the next step, you will be given a choice whether to publish the whole worksheet or some of the items.
5. Click the Publish button and this will open the Publish as Web Page dialog.
window
6. In the Items to publish section, you have the following choices :
(a) Entire workbook. The whole workbook will be published, including all of the worksheets and tabs to navigate between sheets.
(b) 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.
7. click the Change button next to Title: and type in the title you want.
8. 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.
9. Select "AutoRepublish every time this workbook is saved".
10. Select the "Open published Web page in browser" checkbox in case you want to view the web page right after saving.
11. Click the Publish button.
Hope this helps!
Steps :
1. click on file tab and click Save As.
2. In the save as dialog, choose Web Page(.html,.htm).
3. If you selected a range of cells, a table or a chart before clicking Save as then select the Selection radio button, click Save and you are close to finished.
4. To save the entire workbook, including all the worksheets, graphics and tabs for navigating between sheets, select Entire Workbook.
To save the current worksheet, choose Selection: Sheet. In the next step, you will be given a choice whether to publish the whole worksheet or some of the items.
5. Click the Publish button and this will open the Publish as Web Page dialog.
window
6. In the Items to publish section, you have the following choices :
(a) Entire workbook. The whole workbook will be published, including all of the worksheets and tabs to navigate between sheets.
(b) 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.
7. click the Change button next to Title: and type in the title you want.
8. 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.
9. Select "AutoRepublish every time this workbook is saved".
10. Select the "Open published Web page in browser" checkbox in case you want to view the web page right after saving.
11. Click the Publish button.
Hope this helps!
Similar questions