Freepages-Help-L ArchivesArchiver > Freepages-Help > 2006-07 > 1154107241
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
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
"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
A more advanced procedure is to build a query that keeps the imported data
current - useful for things like market prices.
|Back at XLS --> HTML by "Ralph Taylor" <>|