By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,825 Members | 967 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,825 IT Pros & Developers. It's quick & easy.

Any utilities to remove the ALL the Microsoft formatting tags?

P: n/a
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!
Jul 20 '05 #1
Share this Question
Share on Google+
163 Replies


P: n/a
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

Jul 20 '05 #2

P: n/a
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
Jul 20 '05 #3

P: n/a
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!


Jul 20 '05 #4

P: n/a

"William Tasso" <ng*@tbdata.com> wrote in message
news:bk************@ID-139074.news.uni-berlin.de...
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
Jul 20 '05 #5

P: n/a
"Shiperton Henethe" <sh*****@yahoo.com> wrote in news:3f65d1e2$0$24105
$a*******@news.easynet.co.uk:
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
Jul 20 '05 #6

P: n/a
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
Jul 20 '05 #7

P: n/a
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!

Jul 20 '05 #8

P: n/a
On Mon, 15 Sep 2003 16:29:15 +0100, Shiperton Henethe wrote:

"William Tasso" <ng*@tbdata.com> wrote in message
news:bk************@ID-139074.news.uni-berlin.de...
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
Jul 20 '05 #9

P: n/a
On Mon, 15 Sep 2003 16:38:31 +0100, Shiperton Henethe <sh*****@yahoo.com>
wrote:
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...


Whatever you do, never, EVER run Linux. You will blow up. Probably
literally.

Grey

--
The technical axiom that nothing is impossible sinisterly implies the
pitfall corollory that nothing is ridiculous.
- http://www.greywyvern.com - Orca RingMaker: PHP web ring creation and
management
Jul 20 '05 #10

P: n/a
"Shiperton Henethe" <sh*****@yahoo.com> wrote in message
news:3f***********************@news.easynet.co.uk. ..
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?


http://www.microsoft.com/downloads/d...displaylang=EN

--
McWebber
No email replies read
If someone tells you to forward an email to all your friends
please forget that I'm your friend.
Jul 20 '05 #11

P: n/a
Shiperton Henethe schrieb:

"William Tasso" <ng*@tbdata.com> wrote in message
news:bk************@ID-139074.news.uni-berlin.de...
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?


But do on then, how does one create a compact
HTML table from CVS? Can you import it into
Dreamweaver (v4)?


Yes, you can import csv into DW4.
And don't mix up CVS (Concurrent Versions System) with CSV (Comma
Separated Value file format).

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


You could try the Microsoft Office2000 HTML filter
<http://office.microsoft.com/Assistance/2000/htmlfilter.aspx>: It allows
you to "export to compact HTML", and after that you can run a
customizable filter over your file to remove even more fluff.

But 2500 rows of data in one HTML file seems a bit excessive. Can't you
put that in a database and then only show e.g. 10, 20, 50, or 100 sets
at a time?
Matthias
Jul 20 '05 #12

P: n/a
GreyWyvern wrote:
On Mon, 15 Sep 2003 16:38:31 +0100, Shiperton Henethe
<sh*****@yahoo.com> wrote:
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...


Whatever you do, never, EVER run Linux. You will blow up. Probably
literally.


hoot ;o)

--
William Tasso - http://WilliamTasso.com
Jul 20 '05 #13

P: n/a
GreyWyvern wrote:
On Mon, 15 Sep 2003 16:38:31 +0100, Shiperton Henethe <sh*****@yahoo.com>
wrote:
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...


Whatever you do, never, EVER run Linux. You will blow up. Probably
literally.


Have you used any recent desktop distribution? They are about as simple to
use as anything else.

Anyway, if you don't want to use a command prompt, try this:

<URL:http://users.rcn.com/creitzel/tidy.html#tidyui>

You see, tidy is a program without a GUI; a lot of Unix software is like
that for various reasons. End-users usually want a GUI, so people create
wrappers around the base application, Tidy UI is a wrapper for the tidy.exe
program.
--
Jim Dabell

Jul 20 '05 #14

P: n/a
Shiperton Henethe wrote:
"William Tasso" <ng*@tbdata.com> wrote in message
news:bk************@ID-139074.news.uni-berlin.de...
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)?


d/w and pre-procesing editors have been covered elsewhere in this thread.
Which server-side facilities do you have available?

what are you trying to achieve with this? surely not display 2,500 rows on
one page?

--
William Tasso - http://WilliamTasso.com
Jul 20 '05 #15

P: n/a
On Mon, 15 Sep 2003 17:10:08 +0100, Jim Dabell <ji********@jimdabell.com>
wrote:
GreyWyvern wrote:
On Mon, 15 Sep 2003 16:38:31 +0100, Shiperton Henethe
<sh*****@yahoo.com>
wrote:
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...


Whatever you do, never, EVER run Linux. You will blow up. Probably
literally.


Have you used any recent desktop distribution? They are about as simple
to
use as anything else.


Actually, I have. Of course all the *Real LINUX Guru's* use the command
prompt ;)

Grey

--
The technical axiom that nothing is impossible sinisterly implies the
pitfall corollory that nothing is ridiculous.
- http://www.greywyvern.com - Orca RingMaker: PHP web ring creation and
management
Jul 20 '05 #16

P: n/a
Gazing into my crystal ball I observed Karim <karim3411@!!yahoo!!.com>
writing in news:16*****************************@40tude.net:
If you have MS Access, you can read in the xls or csv file and export to
HTML. Access produces clean html.


In what world does Access produce clean code? Access produces the same
bloat that MS Word and Excel produce.

--
Adrienne Boswell
Please respond to the group so others can share
http://www.arbpen.com
Jul 20 '05 #17

P: n/a
Gazing into my crystal ball I observed "Shiperton Henethe"
<sh*****@yahoo.com> writing in news:3f65dc4b$0$10774$afc38c87
@news.easynet.co.uk:
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

IIRC Tidy also works as a plug in for Dreamweaver. Check the Dreamweaver
documenation.
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!
>
>



--
Adrienne Boswell
Please respond to the group so others can share
http://www.arbpen.com
Jul 20 '05 #18

P: n/a
Gazing into my crystal ball I observed "Shiperton Henethe"
<sh*****@yahoo.com> writing in news:3f65d1e2$0$24105$afc38c87
@news.easynet.co.uk:
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!


You can use ASCII to Tab at
http://www.jafsoft.com/asctotab/?home&p=asctotab
to convert delimited (csv, asc, txt) to a clean table.

--
Adrienne Boswell
Please respond to the group so others can share
http://www.arbpen.com
Jul 20 '05 #19

P: n/a
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?


http://www.finertechnologies.com/index-xls2html.html
http://www.jafsoft.com/doco/a2tdoco....elp&p=AscToTab


Jul 20 '05 #20

P: n/a
Shiperton Henethe wrote:
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)?!


The original tidy is a command line program. There is a windows GUI
version downloadable at
http://perso.wanadoo.fr/ablavier/Tid...idyGUI-exe.zip

You should be able to download this, unzip it, and run the program. Then
load your exported HTML, then click 'Tidy!'. It will tell you what it's
done - but not make the changes to your original until you click 'replace'.

Hope that helps,

Ian M

PS - apologies for top-posting earlier - i don't know what came over me!

Jul 20 '05 #21

P: n/a
Hi Shiperton,
Why generate it and strip it out.

If you are into writing your own HTML, I would suggest taking a look
at my webpage on HTML conversion from Excel
http://www.mvps.org/dmcritchie/excel/xl2html.htm

I write my own HTML code and the macro to generate the tables
needed without gray row and column headings XL2HTML
or with the headings from macro XL2HTMLx
based on the current selection.

If you seriously want values without formatting you can use
..value instead of .text but your dates are not going to
look like dates, for instance.

Most of the tables on my pages were generated with earlier versions of
the macro. I broke down and did add color, and alignment justifications,
which is a simple tradeoff compared to 3 to 10 times the amount from
Excel or Front Page.

No trial versions, you have the macro to change for your own use.
The code is at
http://www.mvps.org/dmcritchie/excel/code/xl2htmlx.txt

Instructions to install macro coding
http://www.mvps.org/dmcritchie/excel/getstarted.htm

The current Microsoft Office solution is to generate all the
horrendous code with all the round-tripping code and then
run the Office 2000 HTML Filter
to remove the round tripping code. But it is still going
to have the junk to make it look just like an Excel page,
overriding formatting that HTML generally does much better
left to it's own devices..
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Shiperton Henethe" <sh*****@yahoo.com> wrote ...
I literally just want "compact HTML" - ie just the data,
plus the minimal table structure
and *NO FORMATTING CODES* of any sort!!

Jul 20 '05 #22

P: n/a
Shiperton Henethe wrote:
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
The original tidy is a command line program. There is a windows GUI
version downloadable at http://users.rcn.com/creitzel/tidy/tidyui.zip

You should be able to download this, unzip it, and run the program. Then
load your exported HTML, then click 'Tidy!'. It will tell you what it's
done - but not make the changes to your original until you click 'replace'.

Hope that helps,

Ian M

PS - apologies for top-posting earlier - i don't know what came over me!



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!



Jul 20 '05 #23

P: n/a
On Mon, 15 Sep 2003 19:55:35 +0100, Ian Miller
<ia*@overmill.freeserve.co.uk> wrote:
Hope that helps,

Ian M

PS - apologies for top-posting earlier - i don't know what came over me!


But double-posting is okay, right? ;P

Grey

--
The technical axiom that nothing is impossible sinisterly implies the
pitfall corollory that nothing is ridiculous.
- http://www.greywyvern.com - Orca RingMaker: PHP web ring creation and
management
Jul 20 '05 #24

P: n/a
"Shiperton Henethe" <sh*****@yahoo.com> wrote in message news:<3f***********************@news.easynet.co.uk >...
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 Office 2000 HTML Filter 2.0.

"The Office HTML Filter is a tool you can use to remove
Office-specific markup tags embedded in Office 2000 documents saved as
HTML."

I don't know how it works.
Made by MS, so don't expect miracles.
http://office.microsoft.com/download.../Msohtmf2.aspx

You can also use HTML Tidy.
http://www.w3.org/People/Raggett/tidy/

altamir
Jul 20 '05 #25

P: n/a
GreyWyvern wrote:
On Mon, 15 Sep 2003 19:55:35 +0100, Ian Miller
<ia*@overmill.freeserve.co.uk> wrote:
Hope that helps,

Ian M

PS - apologies for top-posting earlier - i don't know what came over me!

But double-posting is okay, right? ;P

Grey

Grrr - first one had wrong url. I cancelled it but clearly it hasn't
propagated properly.
Ian M

Jul 20 '05 #26

P: n/a
In article <3f***********************@news.easynet.co.uk>, one of infinite monkeys
at the keyboard of "Shiperton Henethe" <sh*****@yahoo.com> wrote:
Sounds promising but - Gad streuth!! - I cant understand
what the heck I'm looking at...


AccessValet will do it for you. I wouldn't normally recommend it over Tidy
for this particular task, but it does come with a full GUI:-)

http://valet.webthing.com/access/

--
Nick Kew

In urgent need of paying work - see http://www.webthing.com/~nick/cv.html
Jul 20 '05 #27

P: n/a

"Matthias Gutfeldt" <wo***@gmx.at> wrote in message
news:3F***************@gmx.at...
Shiperton Henethe schrieb:

"William Tasso" <ng*@tbdata.com> wrote in message
news:bk************@ID-139074.news.uni-berlin.de...
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?
But do on then, how does one create a compact
HTML table from CVS? Can you import it into
Dreamweaver (v4)?


Yes, you can import csv into DW4.
And don't mix up CVS (Concurrent Versions System) with CSV (Comma
Separated Value file format).


No that's the whole point. It crashes my DW4!
(Even on small files...)
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)...
You could try the Microsoft Office2000 HTML filter
<http://office.microsoft.com/Assistance/2000/htmlfilter.aspx>: It allows
you to "export to compact HTML", and after that you can run a
customizable filter over your file to remove even more fluff.


Is that safe to run in Office 2002?!
Have Micro$oft genuinely neither built it into Office2002
nor created a filter for 2002? Pah! :-[

But 2500 rows of data in one HTML file seems a bit excessive. Can't you
put that in a database and then only show e.g. 10, 20, 50, or 100 sets
at a time?

Nope!
Ship
Jul 20 '05 #28

P: n/a

"William Tasso" <ng*@tbdata.com> wrote in message
news:bk************@ID-139074.news.uni-berlin.de...
Shiperton Henethe wrote:
"William Tasso" <ng*@tbdata.com> wrote in message
news:bk************@ID-139074.news.uni-berlin.de...
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)?


d/w and pre-procesing editors have been covered elsewhere in this thread.
Which server-side facilities do you have available?

None.
Client side only.

what are you trying to achieve with this? surely not display 2,500 rows on one page?

Yes. Why not?!
We are trying to make a point about how many successful bids have
been made on our site. If our customers REALLY want to see them all
then that's fine we let them. The first 100 or so are in their own
table so the appear first...

Ship

Jul 20 '05 #29

P: n/a
Shiperton Henethe wrote:
"William Tasso" <ng*@tbdata.com> wrote in message
news:bk************@ID-139074.news.uni-berlin.de...
...
Which server-side facilities do you have available?

None.
Client side only.


pity
what are you trying to achieve with this? surely not display 2,500
rows on one page?

Yes. Why not?!
We are trying to make a point about how many successful bids have
been made on our site. If our customers REALLY want to see them all
then that's fine we let them. The first 100 or so are in their own
table so the appear first...


it can be good to shine a little light on your successes but 2,500 rows
seems a little OTT - but it's your site ;o)

--
William Tasso - http://WilliamTasso.com
Jul 20 '05 #30

P: n/a

"Jim Dabell" <ji********@jimdabell.com> wrote in message
news:CI********************@giganews.com...
GreyWyvern wrote:
On Mon, 15 Sep 2003 16:38:31 +0100, Shiperton Henethe <sh*****@yahoo.com> wrote:
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...
Whatever you do, never, EVER run Linux. You will blow up. Probably
literally.


Have you used any recent desktop distribution? They are about as simple

to use as anything else.

Anyway, if you don't want to use a command prompt, try this:

<URL:http://users.rcn.com/creitzel/tidy.html#tidyui>

You see, tidy is a program without a GUI; a lot of Unix software is like
that for various reasons. End-users usually want a GUI, so people create
wrappers around the base application, Tidy UI is a wrapper for the tidy.exe program.


Better.
I still think I'm too thick/non-techie for this solution.
I tried opening my file and clicking on the Tidy tab.
After about 20 seconds it appeared to have stripped out everything
except the tabs. I tried saving but all the formatting
(and Microsoft crud) is still there!

Ship




Jul 20 '05 #31

P: n/a
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
The original tidy is a command line program. There is a windows GUI
version downloadable at http://users.rcn.com/creitzel/tidy/tidyui.zip

You should be able to download this, unzip it, and run the program. Then
load your exported HTML, then click 'Tidy!'. It will tell you what it's
done - but not make the changes to your original until you click

'replace'.
Hope that helps,


I tried this (twice) but for some reason it didnt change anything
when I saved it. (I am using win2K)

Ship
Jul 20 '05 #32

P: n/a

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.


Aaaaaaaaaaaaaaaarrrrrrrrrrggggggggghhhhhhhhhhh!! >>>:-[

Is it just me?

This kind of persistent Microsoft-dominate-the-planet
-and-screw-who-is-inconvenienced (by having to
download bloated HTML...)

....makes me so cross I can scarely speak.

Gads!

If they want to take over the planet
all I can say is that they need to
do so a damned site more ethically.

Frankly it's the sort of thing that spawns terrorists.

Ship



Jul 20 '05 #33

P: n/a

"McWebber" <mc******@my-deja.com> wrote in message
news:se********************@comcast.com...
"Shiperton Henethe" <sh*****@yahoo.com> wrote in message
news:3f***********************@news.easynet.co.uk. ..
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?


http://www.microsoft.com/downloads/d...displaylang=EN

Is there a version for Office 2002?

How are we supposed to know if this will work in Office 2002?
*Why* isnt this built into 2002? Pah.

Ship
Jul 20 '05 #34

P: n/a

"Nico Schuyt" <ns*****@hotmail.com> wrote in message
news:3f***********************@news.euronet.nl...
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?
http://www.finertechnologies.com/index-xls2html.html


Absolutely no way!
I am NOT going to spend over 20 dollars let along 100
on this f***ing microsoft-created problem.
http://www.jafsoft.com/doco/a2tdoco....elp&p=AscToTab

No use.
I tried it but it failed to align much of the data
in their correct TDs.

Ship
Shiperton Henether
Jul 20 '05 #35

P: n/a

"Altamir" <al*****@wp.pl> wrote in message
news:65**************************@posting.google.c om...
"Shiperton Henethe" <sh*****@yahoo.com> wrote in message news:<3f***********************@news.easynet.co.uk >...
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 Office 2000 HTML Filter 2.0.

"The Office HTML Filter is a tool you can use to remove
Office-specific markup tags embedded in Office 2000 documents saved as
HTML."

I don't know how it works.
Made by MS, so don't expect miracles.
http://office.microsoft.com/download.../Msohtmf2.aspx


Nope. it wont even install with Office 2002!!
Ship
Shiperton Henethe
Jul 20 '05 #36

P: n/a

"Nick Kew" <ni**@fenris.webthing.com> wrote in message
news:3t***********@jarl.webthing.com...
In article <3f***********************@news.easynet.co.uk>, one of infinite monkeys at the keyboard of "Shiperton Henethe" <sh*****@yahoo.com> wrote:
Sounds promising but - Gad streuth!! - I cant understand
what the heck I'm looking at...
AccessValet will do it for you. I wouldn't normally recommend it over

Tidy for this particular task, but it does come with a full GUI:-)

http://valet.webthing.com/access/


As far as I can tell it cost GBP 40 or 60.

Am I mad or deranged or something?
But I find it somehow sticks in my gullet to
have to lash out hard earnt cash
simply because Microsoft are scr*wing us.

They obviously felt guilty enough to produce
a compact HTML version for Office 2000 but
guess what? No Office 2002 version!

Those b*st*rds!
Ship


Jul 20 '05 #37

P: n/a
Shiperton Henethe wrote:

I still think I'm too thick/non-techie for this solution.
I tried opening my file and clicking on the Tidy tab.
After about 20 seconds it appeared to have stripped out everything
except the tabs. I tried saving but all the formatting
(and Microsoft crud) is still there!


In my experience, I found there are some errors that Tidy can't fix, it
won't generate new source unless they are manually corrected first.
Look at the messages and see if there are any of these errors reported.
If so, fix them in the source then try running Tidy again.

--
To email a reply, remove (dash)ns(dash). Mail sent to the ns
address is automatically deleted and will not be read.

Jul 20 '05 #38

P: n/a
On Mon, 15 Sep 2003 21:20:18 +0100, Shiperton Henethe wrote:

"Altamir" <al*****@wp.pl> wrote in message
news:65**************************@posting.google.c om...
"Shiperton Henethe" <sh*****@yahoo.com> wrote in message

news:<3f***********************@news.easynet.co.uk >...
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 Office 2000 HTML Filter 2.0.

"The Office HTML Filter is a tool you can use to remove
Office-specific markup tags embedded in Office 2000 documents saved as
HTML."

I don't know how it works.
Made by MS, so don't expect miracles.
http://office.microsoft.com/download.../Msohtmf2.aspx


Nope. it wont even install with Office 2002!!
Ship
Shiperton Henethe


Use Access 2002 ti import, then export.
--
Karim
Recommended host: http://www.cheapesthosting.com - Affordable hosting since
1998
Jul 20 '05 #39

P: n/a
"Shiperton Henethe" <sh*****@yahoo.com> wrote in message
news:3f***********************@news.easynet.co.uk. ..
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?


I just add new columns with the HTML codes and save as a tab-separated text
file.

In other words, I add a new column 'A' and each cell in that column is
"<tr><td>". Skip one column, insert another that contains "</td><td>" on
each line and add another at the end... "</td></tr>". Save as a text file
and it's easy to work with.
Jul 20 '05 #40

P: n/a

"Karim" <karim3411@!!yahoo!!.com> wrote in message
news:1v*****************************@40tude.net...
On Mon, 15 Sep 2003 21:20:18 +0100, Shiperton Henethe wrote:

"Altamir" <al*****@wp.pl> wrote in message
news:65**************************@posting.google.c om...
"Shiperton Henethe" <sh*****@yahoo.com> wrote in message

news:<3f***********************@news.easynet.co.uk >...

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 Office 2000 HTML Filter 2.0.

"The Office HTML Filter is a tool you can use to remove
Office-specific markup tags embedded in Office 2000 documents saved as
HTML."

I don't know how it works.
Made by MS, so don't expect miracles.
http://office.microsoft.com/download.../Msohtmf2.aspx


Nope. it wont even install with Office 2002!!
Ship
Shiperton Henethe


Use Access 2002 ti import, then export.


I've not tried it. But rumour has it that it leaves
microsoft crud as well.
Ship
Jul 20 '05 #41

P: n/a
In article <3f***********************@news.easynet.co.uk>, one of infinite monkeys
at the keyboard of "Shiperton Henethe" <sh*****@yahoo.com> wrote:
As far as I can tell it cost GBP 40 or 60.
Indeed, and I said I wouldn't normally recommend it over Tidy for
this particular task - which is the primary function of Tidy but a
secondary function of AccessValet.
But I find it somehow sticks in my gullet to
have to lash out hard earnt cash
simply because Microsoft are scr*wing us.
Huh? So you're happy to fork out large sums to Microsoft for defective
software[1], but not to a third party to fix it? Does that extend to
embracing M$'s viruses and refusing to use any antivirus?
Those b*st*rds!


Can't help that.

[1] unless you're proclaiming yourself a pirate?

--
Nick Kew

In urgent need of paying work - see http://www.webthing.com/~nick/cv.html
Jul 20 '05 #42

P: n/a
Nick Kew wrote:

So you're happy to fork out large sums to Microsoft for defective
software[1], but not to a third party to fix it?


Though I'm loath to come to the defense of MS, I think it fair to
point out that producing html is a secondary feature of Excel. One
might, thus, fork over money for a functioning spreadsheet program,
and be disappointed with its support for html. Note that I do believe
you should be paid for your work. That is not the issue.

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

Jul 20 '05 #43

P: n/a
S.T. wrote:
"Shiperton Henethe" <sh*****@yahoo.com> wrote in message
news:3f***********************@news.easynet.co.uk. ..
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?


I just add new columns with the HTML codes and save as a tab-separated text
file.

In other words, I add a new column 'A' and each cell in that column is
"<tr><td>". Skip one column, insert another that contains "</td><td>" on
each line and add another at the end... "</td></tr>". Save as a text file
and it's easy to work with.


Clever. And since Excel lets you hide columns, it can still be a
functioning worksheet.

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

Jul 20 '05 #44

P: n/a
Shiperton Henethe wrote:
Nico Schuyt wrote
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?
http://www.finertechnologies.com/index-xls2html.html
Absolutely no way!
I am NOT going to spend over 20 dollars let along 100
on this f***ing microsoft-created problem.


LOL. The time you spent so far on this problem costs you a lot more then $20
:-)
But if you want a free solution:
- Create a suitable table in MySQL
- Import the CSV
- Create the HTML table with a PHP script.
Makes it very easy to reload new data.
PHP and MySQL are free.

Regards, Nico


Jul 20 '05 #45

P: n/a
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?

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.

Aaaaaaaaaaaaaaaarrrrrrrrrrggggggggghhhhhhhhhhh!! >>>:-[

Is it just me?

This kind of persistent Microsoft-dominate-the-planet
-and-screw-who-is-inconvenienced (by having to
download bloated HTML...)

...makes me so cross I can scarely speak.

Gads!

If they want to take over the planet
all I can say is that they need to
do so a damned site more ethically.

Frankly it's the sort of thing that spawns terrorists.

Ship


It's Karim. He is an expert at dispelling incorrect information.

If he says something, the truth is probably the opposite.

You are right :-)

Jul 20 '05 #46

P: n/a

"Nick Kew" <ni**@fenris.webthing.com> wrote in message
news:qd***********@jarl.webthing.com...
In article <3f***********************@news.easynet.co.uk>, one of infinite monkeys at the keyboard of "Shiperton Henethe" <sh*****@yahoo.com> wrote:
As far as I can tell it cost GBP 40 or 60.


Indeed, and I said I wouldn't normally recommend it over Tidy for
this particular task - which is the primary function of Tidy but a
secondary function of AccessValet.
But I find it somehow sticks in my gullet to
have to lash out hard earnt cash
simply because Microsoft are scr*wing us.


Huh? So you're happy to fork out large sums to Microsoft for defective
software[1], but not to a third party to fix it? Does that extend to
embracing M$'s viruses and refusing to use any antivirus?


Happy?
No, not remotely happy.
But they've got me.
I am a freelance consultant. I am in business.
I live in the real world. I *have* to go with the
defacto standards when sharing files and data.
They own the operating system and the primarly business
applications. (No company should IMHO be allowed to make both)
It's a monopoly.
And realistically I have no choice.

Wrong, I am happy to fork out a few quid for utilities but no more.

If there was a decent fast alternative to MSIE I would use it too.
For a few quid. (Netscape blew that one badly!)

Other thinkgs being equal I would go to long lengths
to avoid Microsoft. But usually they arent equal.
FWIW, I use Norton Anti-virus, which seems okay so far.

The cost of catching a virus far exceeds the 100 quid
a year or so.

Again I have no choice but to USE an anti-virus utility.

Ship
Shiperton Henethe


Jul 20 '05 #47

P: n/a

"Brian" <us*****@mangymutt.com.invalid-remove-this-part> wrote in message
news:vEu9b.464823$YN5.313177@sccrnsc01...
Nick Kew wrote:

So you're happy to fork out large sums to Microsoft for defective
software[1], but not to a third party to fix it?


Though I'm loath to come to the defense of MS, I think it fair to
point out that producing html is a secondary feature of Excel. One
might, thus, fork over money for a functioning spreadsheet program,
and be disappointed with its support for html. Note that I do believe
you should be paid for your work. That is not the issue.


The issue is that Microsoft were bullied into producing
a compact HTML version, for Office 2000 but have deliberately
not produced an Office2002 version. Why not?
Because they want *their* standards to become defacto.

Just like the O/S and browsers have become.

This is the unacceptable face of capitalism.
Ship
Shiperton Henethe
Jul 20 '05 #48

P: n/a
>
If there was a decent fast alternative to MSIE I would use it too.
For a few quid. (Netscape blew that one badly!)

Opera? http://www.opera.com/

Firebird? http://www.mozilla.org/products/firebird/

Doubtless countless others too. You should try some and see.
Ian M

Jul 20 '05 #49

P: n/a

"Ian Miller" <ia*@overmill.freeserve.co.uk> wrote in message
news:7b*****************@news-binary.blueyonder.co.uk...

If there was a decent fast alternative to MSIE I would use it too.
For a few quid. (Netscape blew that one badly!)

Opera? http://www.opera.com/

Firebird? http://www.mozilla.org/products/firebird/

Doubtless countless others too. You should try some and see.


As a professional web developer I'm only really very interested
in things with < 1 or 2% penetration...

I did try opera years ago but found it confusing/irritating.

Might try again sometime I guess
Ship
Jul 20 '05 #50

163 Replies

This discussion thread is closed

Replies have been disabled for this discussion.