Clean extra excel-export nonsense?

[Mike Jacoubowsky]

When you export from Excel to HTML, you get a ton of extra garbage you don't
need, including cell formatting instructions that mess things up badly
(particularly font formatting). You can manually strip them out, but is
there a way to export just the data and columns without formatting? Or an
easy way to strip out all the stuff afterward?

Thanks-

--Mike Jacoubowsky
Chain Reaction Bicycles
www.ChainReaction.com
Redwood City & Los Altos, CA USA

 

[Kathleen Anderson [MVP - FrontPage]]

Do you have a Gmail account? This:
http://consumingexperience.blogspot.com/2006/03/tip-convert-word-to-html-and-convert.html
works really well. After you paste the HTML into your page in Code view,
switch back to Design View, Select All and Remove Formatting - the end
result 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/

 

[Kathleen Anderson [MVP - FrontPage]]

Here's another way, posted here by Cheryl Wise, that doesn't rely on having
a gmail account; I just tried it and it works:

In Excel save as comma separated file.
Open in notepad, copy
Then paste into FrontPage.
Nest highlight the text in FrontPage and use Tables, Convert Text to Table

http://groups-beta.google.com/group...fa2c89eb?scoring=d&q=excell+spreadsheet&hl=en


--

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

 

[Mike Jacoubowsky]

Here's another way, posted here by Cheryl Wise, that doesn't rely on

having a gmail account; I just tried it and it works:

In Excel save as comma separated file.
Open in notepad, copy
Then paste into FrontPage.
Nest highlight the text in FrontPage and use Tables, Convert Text to Table

Thanks, I'll give that a try!

But sure would be nice if Excel could do it cleanly by itself. I understand
the concept; they're trying to, as faithfully as possible, reproduce
everything they can. But sometimes you're just trying to build a table and
add data in Excel because it's convenient, or because some other application
exports to it, and not directly to a web editor. And when manually cleaning
out the garbage, I'm not good enough with ram HTML code to make sure I'm not
messing something up.

--Mike-- Chain Reaction Bicycles
www.ChainReactionBicycles.com