how to copy excel table into frontpage 2003 without the style markup

[Me]

Hello,
i'm trying to paste data from Excel 2003 into a html document in
Frontpage 2003. This works but Frontpage also takes over all the
styles.

This is how the pasted code looks like in Frontpage 2003:
<table x:str border="0" cellpadding="0" cellspacing="0" width="128"
style="border-collapse:
collapse;width:96pt" id="table1">
<colgroup>
<col width="64" span="2" style="width:48pt">
</colgroup>
<tr height="17" style="height:12.75pt">
<td height="17" align="right" width="64" style="height: 12.75pt;
width: 48pt; color: windowtext; font-size: 10.0pt; font-weight: 400;
font-style: normal; text-decoration: none; font-family: Arial;
text-align: general; vertical-align: bottom; white-space: nowrap;
border: medium none; padding-left: 1px; padding-right: 1px;
padding-top: 1px" x:num>
1</td>

Is there a possibility to paste the excel table without all this style
markup?
I've tried everything, including all the different Paste options but
none seems to do the trick.

As result i would like to obtain only the <table>, <tr> and <td> tags
without the styles.

In office XP and office 2000 there was a workaround for this, but in
Office 2003 this seems not to work anymore: I copied the excel data
into Wordpad. And from Wordpad i copied it into Frontpage XP. That way
Frontpage XP did not put all these annoying styles in my html code

Thanks very much!

 

[Jim Buyens]

-----Original Message-----

Hello,
Howdy.

i'm trying to paste data from Excel 2003 into a html
document in Frontpage 2003. This works but Frontpage
also takes over all the styles.
...
Is there a possibility to paste the excel table without
all this style markup?

This is ugly but it works.
1. Save the table as comma-separated or tab-separated
values.
2. Open the resulting file in Notepad.
3. Press Ctrl+A and Ctrl+C tp copy everything in
Notepad.
4. Paste the clipboard into FrontPage.
5. Select the text you just pasted.
6. Choose Convert from the Table menu, and then
select Text To Table.
7. Select the delimiter you choose in step 1, then
click OK.

For a somewhat more automated solution, browse

http://www.interlacken.com/winnt/dnld/

and under FrontPage Add-Ins, click SuperRemoveFormat.
After registering with the site, you can download a macro
that removes most of the excess formatting baggage that
Excel creates.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

 

[Albanygun]

I highlight the Excel data, save the Excel data as html in a file, then
import the file into the web page.

 

[Me]

Hey Jim!

thanks a lot for the advice.

I've downloaded the macro and it works!

You've just saved me a lot of hassle...