How to paste a table and not have FP F*** with the styles and crap

[Mr B]

I jsut want to take an excel table and paste it into FP. Every time I do
that FP adds in craploads of tags and junk that I don't want. There's
doesn't seem to be an easy way to remove all the extra crap that I can find
and there doesn't seem to be a way to paste in the table and just have it
make a plain table with just the text.

One box that just has an "h" in it ends up like:
<td style="color: #000000; font-size: 10.0pt; font-weight: 400; font-style:
normal; font-family: Arial; text-align: general; vertical-align: bottom;
white-space: nowrap; border: medium none; padding-left: 1px; padding-right:
1px; padding-top: 1px">
<font size="3">h</font></td>

All I want is:
<td>h</td>

Can anyone tell me a way to do this? This is the biggest PITA with FP I've
ever come across.

Thanks.

 

[Tina Clarke]

I jsut want to take an excel table and paste it into FP. Every time I do
that FP adds in craploads of tags and junk that I don't want. There's
doesn't seem to be an easy way to remove all the extra crap that I can find
and there doesn't seem to be a way to paste in the table and just have it
make a plain table with just the text.

One box that just has an "h" in it ends up like:
<td style="color: #000000; font-size: 10.0pt; font-weight: 400; font-style:
normal; font-family: Arial; text-align: general; vertical-align: bottom;
white-space: nowrap; border: medium none; padding-left: 1px; padding-right:
1px; padding-top: 1px">
<font size="3">h</font></td>

All I want is:
<td>h</td>

Can anyone tell me a way to do this? This is the biggest PITA with FP I've
ever come across.

Thanks.

Have you considered where you pasting from? Your pasting from one program to
another, so naturally your taking the formatting from one program to another
program... even if you pasted to dreamweaver you would get the same
coding...why assume it's a problem that FrontPage is making? FrontPage will
only add formatting if you tell it to or paste in code that contains it
already.

Excel uses inline and embeded css to format the the tables it makes, I was
asked how to get rid of this formatting elsewhere ( a list) ... but other
than a few bits of removal using remove formatting .. the styles by their
very nature of course stayed.... normally one uses notepad when pasting from
say word if it's just text.. but with a table you can't do that. Not being
someone that uses excel (but I do have it) the only solution I could tink of
was to use find replace to remove the inline styles .. .anyone got a quicker
solution? I did experiment with table - table to text, the PE Addin and
various other things...

Tina


--
http://accessfp.net/ - FrontPage Tutorials
http://anyfrontpage.com/ - http://frontpage-ebooks.com/
http://addonfp.com/ - FrontPage Addons
http://frontpage-tips.com/ - Weekly FrontPage Tips
http://msmvps.com/blogs/frontpage/ - FrontPage News Blog
http://frontpage-blog.com/ - FrontPage Blog
http://clarke-abstract-art.com/ - Original Abstract Pen and Ink Drawings

 

[Rob Giordano \(Crash\)]

welp,, if I were pasting a table with just an H in it...why not just create
the table in FP?


|
| | > I jsut want to take an excel table and paste it into FP. Every time I
do
| > that FP adds in craploads of tags and junk that I don't want. There's
| > doesn't seem to be an easy way to remove all the extra crap that I can
| find
| > and there doesn't seem to be a way to paste in the table and just have
it
| > make a plain table with just the text.
| >
| > One box that just has an "h" in it ends up like:
| > <td style="color: #000000; font-size: 10.0pt; font-weight: 400;
| font-style:
| > normal; font-family: Arial; text-align: general; vertical-align: bottom;
| > white-space: nowrap; border: medium none; padding-left: 1px;
| padding-right:
| > 1px; padding-top: 1px">
| > <font size="3">h</font></td>
| >
| > All I want is:
| > <td>h</td>
| >
| > Can anyone tell me a way to do this? This is the biggest PITA with FP
| I've
| > ever come across.
| >
| > Thanks.
|
| Have you considered where you pasting from? Your pasting from one program
to
| another, so naturally your taking the formatting from one program to
another
| program... even if you pasted to dreamweaver you would get the same
| coding...why assume it's a problem that FrontPage is making? FrontPage
will
| only add formatting if you tell it to or paste in code that contains it
| already.
|
| Excel uses inline and embeded css to format the the tables it makes, I was
| asked how to get rid of this formatting elsewhere ( a list) ... but other
| than a few bits of removal using remove formatting .. the styles by their
| very nature of course stayed.... normally one uses notepad when pasting
from
| say word if it's just text.. but with a table you can't do that. Not being
| someone that uses excel (but I do have it) the only solution I could tink
of
| was to use find replace to remove the inline styles .. .anyone got a
quicker
| solution? I did experiment with table - table to text, the PE Addin and
| various other things...
|
| Tina
|
|
| --
| http://accessfp.net/ - FrontPage Tutorials
| http://anyfrontpage.com/ - http://frontpage-ebooks.com/
| http://addonfp.com/ - FrontPage Addons
| http://frontpage-tips.com/ - Weekly FrontPage Tips
| http://msmvps.com/blogs/frontpage/ - FrontPage News Blog
| http://frontpage-blog.com/ - FrontPage Blog
| http://clarke-abstract-art.com/ - Original Abstract Pen and Ink Drawings
|
|
|
|
|

 

[Mr B]

That was a cell that had the H.. <td>h</td>

The table is a couple hundred rows with 5 or 6 columns.

 

[Rob Giordano \(Crash\)]

I was kiddin'.

Yah, you get a lotta crap when you insert xls file...I've just been messing
with it a bit then ran outta play time.




| That was a cell that had the H.. <td>h</td>
|
| The table is a couple hundred rows with 5 or 6 columns.
|
|
| "Rob Giordano (Crash)" wrote:
|
| > welp,, if I were pasting a table with just an H in it...why not just
create
| > the table in FP?
| >
| >
| > | > |
| > | | > | > I jsut want to take an excel table and paste it into FP. Every time
I
| > do
| > | > that FP adds in craploads of tags and junk that I don't want.
There's
| > | > doesn't seem to be an easy way to remove all the extra crap that I
can
| > | find
| > | > and there doesn't seem to be a way to paste in the table and just
have
| > it
| > | > make a plain table with just the text.
| > | >
| > | > One box that just has an "h" in it ends up like:
| > | > <td style="color: #000000; font-size: 10.0pt; font-weight: 400;
| > | font-style:
| > | > normal; font-family: Arial; text-align: general; vertical-align:
bottom;
| > | > white-space: nowrap; border: medium none; padding-left: 1px;
| > | padding-right:
| > | > 1px; padding-top: 1px">
| > | > <font size="3">h</font></td>
| > | >
| > | > All I want is:
| > | > <td>h</td>
| > | >
| > | > Can anyone tell me a way to do this? This is the biggest PITA with
FP
| > | I've
| > | > ever come across.
| > | >
| > | > Thanks.
| > |
| > | Have you considered where you pasting from? Your pasting from one
program
| > to
| > | another, so naturally your taking the formatting from one program to
| > another
| > | program... even if you pasted to dreamweaver you would get the same
| > | coding...why assume it's a problem that FrontPage is making? FrontPage
| > will
| > | only add formatting if you tell it to or paste in code that contains
it
| > | already.
| > |
| > | Excel uses inline and embeded css to format the the tables it makes, I
was
| > | asked how to get rid of this formatting elsewhere ( a list) ... but
other
| > | than a few bits of removal using remove formatting .. the styles by
their
| > | very nature of course stayed.... normally one uses notepad when
pasting
| > from
| > | say word if it's just text.. but with a table you can't do that. Not
being
| > | someone that uses excel (but I do have it) the only solution I could
tink
| > of
| > | was to use find replace to remove the inline styles .. .anyone got a
| > quicker
| > | solution? I did experiment with table - table to text, the PE Addin
and
| > | various other things...
| > |
| > | Tina
| > |
| > |
| > | --
| > | http://accessfp.net/ - FrontPage Tutorials
| > | http://anyfrontpage.com/ - http://frontpage-ebooks.com/
| > | http://addonfp.com/ - FrontPage Addons
| > | http://frontpage-tips.com/ - Weekly FrontPage Tips
| > | http://msmvps.com/blogs/frontpage/ - FrontPage News Blog
| > | http://frontpage-blog.com/ - FrontPage Blog
| > | http://clarke-abstract-art.com/ - Original Abstract Pen and Ink
Drawings
| > |
| > |
| > |
| > |
| > |
| >
| >
| >

 

[Tina Clarke]

I was kiddin'.

Yah, you get a lotta crap when you insert xls file...I've just been messing
with it a bit then ran outta play time.

Rasberriessssss

Tell us if you solve it

I thought Paul's addin would do it ... though it let me choose xconditional,
once I'd run the CSS check ... it does not seem to work (for that particular
item)... perhaps Jimco might be able to figure that one out.

Tina

Current Tip: (23rd March, 2006)
What are FrontPage Includes good for?
http://frontpage-tips.com/ - FrontPage Tips
Frontpage Tips Ebook, Vol I AND Vol 2. AVAILABLE NOW!
Join http://groups.yahoo.com/group/frontpage-tips/
for F ree weekly FrontPage Tips
MORE EBOOKS COMING SOON.

 

[Rob Giordano \(Crash\)]

Nuttin' I can figure out. Definitely not an FP issue, does the same in DW -
just the way spreadsheet formatting is I guess.




|
| | > I was kiddin'.
| >
| > Yah, you get a lotta crap when you insert xls file...I've just been
| messing
| > with it a bit then ran outta play time.
|
| Rasberriessssss
|
| Tell us if you solve it
|
| I thought Paul's addin would do it ... though it let me choose
xconditional,
| once I'd run the CSS check ... it does not seem to work (for that
particular
| item)... perhaps Jimco might be able to figure that one out.
|
| Tina
|
| Current Tip: (23rd March, 2006)
| What are FrontPage Includes good for?
| http://frontpage-tips.com/ - FrontPage Tips
| Frontpage Tips Ebook, Vol I AND Vol 2. AVAILABLE NOW!
| Join http://groups.yahoo.com/group/frontpage-tips/
| for F ree weekly FrontPage Tips
| MORE EBOOKS COMING SOON.
|
|

 

[Tina Clarke]

Well the next best thing is to make the table in FP there are fp addons that
help do a few excel type things ... autosum
http://www.microsoft.com/downloads/...ae-53a2-4eba-85ce-34d17aa1b185&displaylang=en
for instance

In doing a quick google for the link I came across this
http://www.spreadsheetconverter.com/archive/exceleverywhere-for-html-v2.htm
... there is a trial so see if it renders proper html without all the inline
junk...

We need an excel expert to tell us if there is a way of doing without the
inline styles and making it an external sheet .... or if there is an excel
addon ...

Have to think of it from the other way around if it can't be done the fp way
round...

Please come back Mr B and let us know if the above helps in anyway.

Tina

http://accessfp.net/ - FrontPage Tutorials
http://anyfrontpage.com/ - http://frontpage-ebooks.com/
http://addonfp.com/ - FrontPage Addons
http://frontpage-tips.com/ - Weekly FrontPage Tips
http://msmvps.com/blogs/frontpage/ - FrontPage News Blog
http://frontpage-blog.com/ - FrontPage Blog
http://clarke-abstract-art.com/ - Original Abstract Pen and Ink Drawings

 

[Tina Clarke]

SpreadsheetConverter to HTML
SpreadsheetConverter to HTML converts an Excel spreadsheet into a HTML-page
with embedded JavaScript. No programming or web design experience is
required in order to use SpreadsheetConverter to HTML. Client-side
calculations (Better than AJAX).

It says the above but it says with embedded javascript which is suspect (but
much easier to delete)

Tina

 

[Tina Clarke]

http://www.spreadsheetconverter.com/websamples.htm#

urghhh ... it's worst than a straight import or paste phewwy...spit spit

ok back to the drawing board.

Tina

 

[Rob Giordano \(Crash\)]

yah.

on one of my experiments, I was prompted to insert the install CD for
Publisher 2000! (I do have it on my machine but was too lazy to find the
CD)...now there would be an adventure.

there was an ms converter (if memory serves) a while back, but for the life
o'me i can't remember if it was for excel within a web or not.

i keep forgetting to take my ginko biloba..damn.



| http://www.spreadsheetconverter.com/websamples.htm#
|
| urghhh ... it's worst than a straight import or paste phewwy...spit spit
|
| ok back to the drawing board.
|
| Tina
|
|

 

[Tina Clarke]

I could not let this problem go by so I emailed the MSO list

http://www.freelists.org/webpage/mso Which is run by Linda Johnson and is
about Microsoft Office programs....

Mike Clare gave me the below information.


"There is a little program called T2T.exe that can convert a csv file to
HTML.

http://home.hccnet.nl/s.j.francke/t2t/text2table.htm

The drill here would be to save your spreadsheet as a text file (csv
format) and then run it through this little program to convert it to HTML.

The program also advertises a 'command line' option so if you are familiar
with the VBA macro language in Excel, you should be able to automate the
creation of CSV file and then shell out and run this program."

At the bottom of the above link it says

"T2T converts delimited files to HTML tables, separators are: ( (,) (TAB)
and (|). It handles CSV files produced by spreadsheet or database, handmade
compliant files may be processed as well.

On the TAB Header / Table Props are options to manipulate fonts and colors;
these are gathered in an embedded style sheet."

Downloads are on the left menu. It says it's cardware ... I'm not sure what
that is, but it looks 'free'.

hth Tina

Any FrontPage Ezine
http://anyfrontpage.com/
Latest Issue : FIND ALT ATTRIBUTES WITH FRONTPAGE QUERIES

 

[Mr B]

Well, I just did it by hand and deleted all the extra junk. I pasted it in
and told it to use Destination Formatting which got rid of some of it. THen
just a ton of find/replaces to replace the crap with nothing and eventually I
got my plain table.

Oh well.