«

Hi

Know any good utilities to help me strip out the tags that
Microsoft Excel 2002 leaved behind when you try
and export an HTML format file?

This is driving me NUTS.
And really makes me hate microsoft with a passion.

I literally just want "compact HTML" - ie just the data,
plus the minimal table structure
and *NO FORMATTING CODES* of any sort!!

I did have a utility but it was on my previous PC
and I cant remember what it was called.

I would be prepared to pay no more than say GBP 10.00
for such a utility (which I only need every couple of months...)


Ship
Shiperton Henethe

p.s. I do have Dreamweaver 4, but it crashes every time it tries
to open the (2500 line) document exported from Microsoft Excel 2002!

Please avoid excessive cross-posting. This post did not belong in
html.critique (removed). I also removed the microsoft group, since
the solution is not MS. Followups set (you should have set them in
the first place) to alt.html.

Shiperton Henethe wrote:
>
> Know any good utilities to help me strip out the tags that
> Microsoft Excel 2002 leaved behind when you try
> and export an HTML format file?

HTML Tidy
< http://tidy.sourceforge.net/ >

--
Brian
follow the directions in my address to email me

Shiperton Henethe wrote:
> Know any good utilities to help me strip out the tags that
> Microsoft Excel 2002 leaved behind when you try
> and export an HTML format file?
>

have you considered exporting to csv?

--
William Tasso - http://WilliamTasso.com

"Shiperton Henethe" <> wrote in news:3f65d1e2$0$24105
$:

> Hi
>
> Know any good utilities to help me strip out the tags that
> Microsoft Excel 2002 leaved behind when you try
> and export an HTML format file?
>
> This is driving me NUTS.
> And really makes me hate microsoft with a passion.
>
> I literally just want "compact HTML" - ie just the data,
> plus the minimal table structure
> and *NO FORMATTING CODES* of any sort!!
>
> I did have a utility but it was on my previous PC
> and I cant remember what it was called.
>
> I would be prepared to pay no more than say GBP 10.00
> for such a utility (which I only need every couple of months...)
>
>
> Ship
> Shiperton Henethe
>
> p.s. I do have Dreamweaver 4, but it crashes every time it tries
> to open the (2500 line) document exported from Microsoft Excel 2002!
>
>

Easiest way to do this is with a text editor that has search-with-
replace, such as UltraEdit.

Here's what ya do:

Save the Excel file as a character delimited file. Lessay you use the
pipe as the separator: |

So file.xls becomes file.txt

Open file.txt in your text editor and do the following:
(In Ultra Edit,^p is a NEWLINE, ^t is a TAB)

Search for: |
Replace with: </TD><TD>

Next,

Search for: ^p
Replace with: </TD></TR>^p<TR><TD>

Then put a <TABLE> at the top of the file and a </TABLE> at the bottom of
the file.

Voila: A compact, HTML-ized excel table

--
Marc Bissonnette
/ Perl / CGI / Database / Dynamic Web Content Control /
http://www.internalysis.com
Looking for a new ISP? http://www.canadianisp.com

I also removed the microsoft group, since
> the solution is not MS.
No but the *problem* is MS.
And MS community of users may have found a solution.

> Followups set (you should have set them in
> the first place) to alt.html.
I have no idea what you mean.

>
> Shiperton Henethe wrote:
> >
> > Know any good utilities to help me strip out the tags that
> > Microsoft Excel 2002 leaved behind when you try
> > and export an HTML format file?
>
> HTML Tidy
> < http://tidy.sourceforge.net/ >

Thank you

Tidy (http://tidy.sourceforge.net/) does a pretty good job on Office
documents. I use TidyUI for my day to day editing, and like it a lot!


Ian M



Shiperton Henethe wrote:
> Hi
>
> Know any good utilities to help me strip out the tags that
> Microsoft Excel 2002 leaved behind when you try
> and export an HTML format file?
>
> This is driving me NUTS.
> And really makes me hate microsoft with a passion.
>
> I literally just want "compact HTML" - ie just the data,
> plus the minimal table structure
> and *NO FORMATTING CODES* of any sort!!
>
> I did have a utility but it was on my previous PC
> and I cant remember what it was called.
>
> I would be prepared to pay no more than say GBP 10.00
> for such a utility (which I only need every couple of months...)
>
>
> Ship
> Shiperton Henethe
>
> p.s. I do have Dreamweaver 4, but it crashes every time it tries
> to open the (2500 line) document exported from Microsoft Excel 2002!
>
>

"William Tasso" <> wrote in message
news:bk4kii$p4tbv$...
> Shiperton Henethe wrote:
> > Know any good utilities to help me strip out the tags that
> > Microsoft Excel 2002 leaved behind when you try
> > and export an HTML format file?
> >
>
> have you considered exporting to csv?

That's an interesting question - I must
confess I dont think I'd considered it...

But do on then, how does one create a compact
HTML table from CVS? Can you import it into
Dreamweaver (v4)? And then cut and paste into
the file where I need it. (There are 2500 rows
of data, mind you, which may be why Dreamweaver
keeps crashing whenever I try read msExcel's
..HTML export)...

Ship
Shiperton Henethe

On Mon, 15 Sep 2003 15:54:05 +0100, Shiperton Henethe wrote:

> Hi
>
> Know any good utilities to help me strip out the tags that
> Microsoft Excel 2002 leaved behind when you try
> and export an HTML format file?
>
> This is driving me NUTS.
> And really makes me hate microsoft with a passion.
>
> I literally just want "compact HTML" - ie just the data,
> plus the minimal table structure
> and *NO FORMATTING CODES* of any sort!!
>
> I did have a utility but it was on my previous PC
> and I cant remember what it was called.
>
> I would be prepared to pay no more than say GBP 10.00
> for such a utility (which I only need every couple of months...)
>
>
> Ship
> Shiperton Henethe
>
> p.s. I do have Dreamweaver 4, but it crashes every time it tries
> to open the (2500 line) document exported from Microsoft Excel 2002!

I tried to use Dreamweaver MX 2004 to clean a html file produced from Excel
and it said "Nothing to clean up!". If there are no redundant or empty
tags, a cleanup utility won't be of much help. Excel produces verbose html
which is still valid.


--
Karim
Recommended host: http://www.cheapesthosting.com - Affordable hosting since
1998

Sounds promising but - Gad streuth!! - I cant understand
what the heck I'm looking at...

I downloaded something called tidy.exe, and when I ran
it all I got was a big black box. With a flashing cursor
in it...

Maybe I'm too stupid to use this thing...
What do I download for msWindows2000 (and WinXP)?!


Ship
Shiperton Henethe


> Tidy (http://tidy.sourceforge.net/) does a pretty good job on Office
> documents. I use TidyUI for my day to day editing, and like it a lot!
>
>
> Ian M
>
>
>
> Shiperton Henethe wrote:
> > Hi
> >
> > Know any good utilities to help me strip out the tags that
> > Microsoft Excel 2002 leaved behind when you try
> > and export an HTML format file?
> >
> > This is driving me NUTS.
> > And really makes me hate microsoft with a passion.
> >
> > I literally just want "compact HTML" - ie just the data,
> > plus the minimal table structure
> > and *NO FORMATTING CODES* of any sort!!
> >
> > I did have a utility but it was on my previous PC
> > and I cant remember what it was called.
> >
> > I would be prepared to pay no more than say GBP 10.00
> > for such a utility (which I only need every couple of months...)
> >
> >
> > Ship
> > Shiperton Henethe
> >
> > p.s. I do have Dreamweaver 4, but it crashes every time it tries
> > to open the (2500 line) document exported from Microsoft Excel 2002!
> >
> >
>

On Mon, 15 Sep 2003 16:29:15 +0100, Shiperton Henethe wrote:

>
> "William Tasso" <> wrote in message
> news:bk4kii$p4tbv$...
>> Shiperton Henethe wrote:
>>> Know any good utilities to help me strip out the tags that
>>> Microsoft Excel 2002 leaved behind when you try
>>> and export an HTML format file?
>>>
>>
>> have you considered exporting to csv?
>
> That's an interesting question - I must
> confess I dont think I'd considered it...
>
> But do on then, how does one create a compact
> HTML table from CVS? Can you import it into
> Dreamweaver (v4)? And then cut and paste into
> the file where I need it. (There are 2500 rows
> of data, mind you, which may be why Dreamweaver
> keeps crashing whenever I try read msExcel's
> .HTML export)...
>
> Ship
> Shiperton Henethe

If you have MS Access, you can read in the xls or csv file and export to
HTML. Access produces clean html.


--
Karim
Recommended host: http://www.cheapesthosting.com - Affordable hosting since
1998