Save Excel file to HTML.

Which way would you save an Excel file to HTML ? Office 2007, Web
Expressions and FrontPage.

I first Saved.AS to CSV then to Html.

I also tried from XLS to HTM.

Then the file will be opened with Web Expressions and/or Front Page for more
configuration.

Thanks for your help and tips ; Novice @ New Orleans Louisiana

Hi New Orleans Novice,

If you have Excel 2007, click the Office button and Save As...
Choose save as web page (html) from the list of available file types.

Close Excel. Then you can edit the htm file in your favourite web editor (or
just keep using Excel).

Ed Ferrero
www.edferrero.com

The cleanest way to move date from Excel to Expression is to save your Excel
data as a CSV file (1 prefer comma separate) then post into code view.
After which use Tables Convert table to text. That way you get a nice
clean table with no Excel table formatting.

--
Cheryl D Wise
MS MVP Expression
Author: Foundations of Microsoft Expression Web
http://by-expression.com
mail list: http://groups.google.com/group/by-ex...n-web-designer


"New Orleans Novice" wrote in message
...
Save Excel file to HTML.

Which way would you save an Excel file to HTML ? Office 2007, Web
Expressions and FrontPage.

I first Saved.AS to CSV then to Html.

I also tried from XLS to HTM.

Then the file will be opened with Web Expressions and/or Front Page for
more configuration.

Thanks for your help and tips ; Novice @ New Orleans Louisiana

How can one woman be so smart? But it worked fine just as you said. I hope
I do not owe you Cajun Gumbo for every answer.

"The cleanest way to move date from Excel to Expression is to save your
Excel
data as a CSV file (1 prefer comma separate) then post into code view.
After which use Tables Convert table to text. That way you get a nice
clean table with no Excel table formatting"

I've been doing this stuff for 15 years so I suspect you have a ways to go
to catch up.

Does this mean I get some boudin to go with my gumbo? My husband prefers red
beans and rice.<g

--
Cheryl D Wise
MS MVP Expression
Author: Foundations of Microsoft Expression Web
http://by-expression.com
mail list: http://groups.google.com/group/by-ex...n-web-designer


"New Orleans Novice" wrote in message
...
How can one woman be so smart? But it worked fine just as you said. I
hope I do not owe you Cajun Gumbo for every answer.

"The cleanest way to move date from Excel to Expression is to save your
Excel
data as a CSV file (1 prefer comma separate) then post into code view.
After which use Tables Convert table to text. That way you get a nice
clean table with no Excel table formatting"

We have plenty of Gumbo and Crawfish.

Like in TEXAS everyone is Bar B Q'ing Beef. In Mississippi they are Bar B
Q'ing Chicken. Here in South Louisiana we are into Crawfish.

In New Orleans the ones on expensive crack are Car Jacking and Drive By
Murders which helped move us to Number 1 after passing Philadelphia and
Detroit. In the outlying areas of South Louisiana everyone is eating
Crawfish as this movie shows our local Cafes.

http://www.nola.com/photos/t-p/index...0419_crawfish/

You and the Swedes both.
Curious name Crawfish, since it isn't a fish?!
The Swedes import a lot of them from you.

Regards Jens Peter Karlsen.

On Wed, 23 Apr 2008 22:56:22 -0500, "New Orleans Novice"
wrote:

We have plenty of Gumbo and Crawfish.

Like in TEXAS everyone is Bar B Q'ing Beef. In Mississippi they are Bar B
Q'ing Chicken. Here in South Louisiana we are into Crawfish.

In New Orleans the ones on expensive crack are Car Jacking and Drive By
Murders which helped move us to Number 1 after passing Philadelphia and
Detroit. In the outlying areas of South Louisiana everyone is eating
Crawfish as this movie shows our local Cafes.

http://www.nola.com/photos/t-p/index...0419_crawfish/

Before I can answer: Is this a one time conversion or will it be on going?
What will the load, number of visitors, be that views the data within a
10-20 minute window? How large is the Excel data?

With those answers, you can be advised what would be the best way to
implement a solution to your needs (requirements).

--
Mike - FrontPage MVP '97 - '02
Expression Tools & Addin
http://www.j-moves.com
http://www.panemanager.com
FrontPage Tools & Addin
http://www.jbots.com
E-Commerce
http://www.candypress.com

"New Orleans Novice" wrote in message
...
Save Excel file to HTML.

Which way would you save an Excel file to HTML ? Office 2007, Web
Expressions and FrontPage.

I first Saved.AS to CSV then to Html.

I also tried from XLS to HTM.

Then the file will be opened with Web Expressions and/or Front Page for
more configuration.

Thanks for your help and tips ; Novice @ New Orleans Louisiana

The very smart wise woman solved it for 2 sacks of Osyters and 3 sacks of
Crawfish

So it is a one time conversion then.

--
Mike - FrontPage MVP '97 - '02
Expression Tools & Addin
http://www.j-moves.com
http://www.panemanager.com
FrontPage Tools & Addin
http://www.jbots.com
E-Commerce
http://www.candypress.com

"New Orleans Novice" wrote in message
...
The very smart wise woman solved it for 2 sacks of Osyters and 3 sacks of
Crawfish

saving excel 2007 file as a CSV file, resetting the columns, then saving as
htm file worked well. The htm file uploaded without changing the data to
website file manager and published without the error message " webpage not
found" after renaming the extension to .html. thanks for the idea.

"New Orleans Novice" wrote:

Save Excel file to HTML.

Which way would you save an Excel file to HTML ? Office 2007, Web
Expressions and FrontPage.

I first Saved.AS to CSV then to Html.

I also tried from XLS to HTM.

Then the file will be opened with Web Expressions and/or Front Page for more
configuration.

Thanks for your help and tips ; Novice @ New Orleans Louisiana

Don't use xls to html. Instead bring your csv file into Expression Web then
with the csv content highlighted use Table Convert to Table then from the
resulting dialog box select "comma" as the format to convert from. Gives you
a very nice clean table instead of the junk that can be put in using the
Excel output html.

--

Cheryl D Wise
MS MVP Expression
http://by-expression.com
Registration now open for August 30, 2008 session at: http://starttoweb.com
Beginner tutorial: Creating a basic website video tutorial -
http://by-expression.com/media/p/1300.aspx



"almost hopeless" <almost wrote in
message ...
saving excel 2007 file as a CSV file, resetting the columns, then saving
as
htm file worked well. The htm file uploaded without changing the data to
website file manager and published without the error message " webpage not
found" after renaming the extension to .html. thanks for the idea.

"New Orleans Novice" wrote:

Save Excel file to HTML.

Which way would you save an Excel file to HTML ? Office 2007, Web
Expressions and FrontPage.

I first Saved.AS to CSV then to Html.

I also tried from XLS to HTM.

Then the file will be opened with Web Expressions and/or Front Page for
more
configuration.

Thanks for your help and tips ; Novice @ New Orleans Louisiana