inputing an excel spreadsheet into Frontpage tables???

[Guest]

Hello,

I am working on a project where I have to input information from an excel
spreadsheet into table form on the internet. You can view what I have to do
here: http://jsis.washington.edu/canada/province.shtml I thought I could
easily cut and paste an excel spreadsheet into frontpage, but that reformats
everything and turns the page into a complete mess. I'm wondering if there
is an easier way to input information from an excel spreadsheet into tables
in frontpage without entering in all the data manually. Thanks and I
appreciate any assistance or ideas.

 

[Andrew Murray]

Save the excel work sheet as html (there's an option on the file menu,
possibly under the "export" option or similar, or even under "Save As",
which opens the Save File dialogue, you choose from the dropdown which
format to save as (including possibly, HTML format).

You may get mixed results and still get the "mess" you mention, so there may
be some tidying up of the HTML table to do afterwards.

However you will then need to export it to the HTML file every time you
update it as there's no OLE (object link embedding) feature like you would
have in Word/Excel where if you updat the excel file, the changes are
reflected in the Word doc.

The only other suggestion, is to do it manually in Frontpage from the
beginning (and don't worry about it in Excel at all).

 

[Kathleen Anderson [MVP - FrontPage]]

Here's another alternative: If you have a Gmail account, you can try this:
http://consumingexperience.blogspot.com/2006/03/tip-convert-word-to-html-and-convert.html
The HTML produced is pretty clean.

If you don't have a Gmail account, let me know - I'll send you an invite.
--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/