Freepages-Help-L Archives

From: "Ralph Taylor" <>
Subject: Back at XLS --> HTML
Date: Fri, 28 Jul 2006 11:20:41 -0600

The question was how to get a spreadsheet to a Web page.



I've (just now) been lucky enough to read a copy of "Microsoft Office Excel
2003: Level 2" by Robyn Francis. It's a workbook of how to do stuff with
Excel, well worth obtaining if you want to do serious work in Excel. (I
happen to be a Quattro Pro fan, so a little unfamiliar with Excel
procedures.)



In the spirit of "RTFM", here's what the book has to say on the matter:



Page 129, "LESSON 6, TOPIC B - Publish a Worksheet to the Web

.

"1. If necessary, select the worksheet or range of cells you want to
publish.

"2. Choose File --> Save As Web Page,

"3. From the Save In drop down list, select the location for the Web page.

"4. In the Save area, select Entire Workbook or Selection: Sheet.

"5. Click Publish in the Save As dialog box.

"6. If necessary, enter a title for the Web page.

"7. In the File Name text box, enter a name for the Web page.

"8. Click Publish.

"9. If necessary, change any publishing options.

"10. Click Publish."



The book also gives the procedure for the reverse - importing data from the
Web to a spreadsheet.



"1. Open the worksheet the data will be imported into.

"2. Choose Data --> Import External Data-->Import Data.

"3. From the Look In drop-down list, select the data source.

"4. In the File Name text box, enter a name for the file.

"5. Under Where Do You Want To Put The Data, choose a location for the
data."



A more advanced procedure is to build a query that keeps the imported data
current - useful for things like market prices.

-rt_/)

This thread:

• Back at XLS --> HTML by "Ralph Taylor" <>