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!

>-----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)
|/---------------------------------------------------
*----------------------------------------------------

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

"Me" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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!

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...

"Jim Buyens" <(E-Mail Removed)> wrote in message news:<00c801c3d9ff$15856f20$(E-Mail Removed)>...
> >-----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)
> |/---------------------------------------------------
> *----------------------------------------------------