14. Publishing Data on the Web

What You'll Do

Open a Workbook as a Web Page

Preview a Web Page

Create a Hyperlink

Format a Hyperlink

Change Web Page Options

Save a Worksheet as a Web Page

Publish a Web Page

Copy a Web Table to a Worksheet

Create Refreshable Web Queries

Get Data from Web Queries

Save Web Queries

Access Office Information on the Web

Get Documents from the Web

Introduction

Microsoft Office Excel provides you with the tools you need to create and save your workbook as a Web page and to publish it on the Web. The Save As command allows you to format your workbook in Hypertext Markup Language (HTML), a simple coding system used to format documents for an intranet or the Internet. Saving your workbook in HTML format means you can ...

Get Microsoft Office Excel 2007 On Demand now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.