Any utilities to remove the ALL the Microsoft formatting tags?

[Ian Miller]

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/TidyGUI/TidyGUI-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!

 

[GreyWyvern]

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

 

[Ian Miller]

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!

 

[Altamir]

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/downloads/2000/Msohtmf2.aspx

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

altamir

 

[Ian Miller]

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

 

[Shiperton Henethe]

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

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

 

[Shiperton Henethe]

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

 

[William Tasso]

None.
Client side only.
pity

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)

 

[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

 

[Shiperton Henethe]

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

 

[Shiperton Henethe]

http://www.microsoft.com/downloads/...EE-3FBD-482C-83B0-96FB79B74DED&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

 

[Shiperton Henethe]

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.html?help&p=AscToTab

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

Ship
Shiperton Henether

 

[Shiperton Henethe]

"Shiperton Henethe" <[email protected]> wrote in message

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/downloads/2000/Msohtmf2.aspx

Nope. it wont even install with Office 2002!!


Ship
Shiperton Henethe

 

[Shiperton Henethe]

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

 

[Karim]

Nope. it wont even install with Office 2002!!


Ship
Shiperton Henethe

Use Access 2002 ti import, then export.

 

[S.T.]

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.

 

[Nick Kew]

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?

 

[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

 

[Brian]

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]

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.