N
Nick Kew
one of infinite monkeys said:
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/
Any utilities to remove the ALL the Microsoft formatting tags?
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/
K
Karim
No it doesn't. It doesn't procude any xml. Just pure table, tr and td tags.
Which version did you try?
D
David McRitchie
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..
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..
I
Ian Miller
Shiperton said:
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!
G
GreyWyvern
But double-posting is okay, right? ;P
Grey
I
Ian Miller
Shiperton said:
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!
A
Altamir
Shiperton Henethe said:
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
M
McWebber
I
Ian Miller
Grrr - first one had wrong url. I cancelled it but clearly it hasn'tGreyWyvern said:
propagated properly.
Ian M
S
Shiperton Henethe
Matthias Gutfeldt said:
No that's the whole point. It crashes my DW4!
(Even on small files...)
Is that safe to run in Office 2002?!
Have Micro$oft genuinely neither built it into Office2002
nor created a filter for 2002? Pah! :-[
Nope!
Ship
S
Shiperton Henethe
None.William Tasso said:
Client side only.
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
S
Shiperton Henethe
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
Hmm... Intelligent suggestion... though a bit of a techies one!
Easy to make mistakes... Slow if I have to keep doing it
(which I might). In this day and age I'd rather
do all this on a single click if at all possible!
Ship
W
William Tasso
Shiperton said:
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)
S
Shiperton Henethe
Adrienne said:
Like I say the Excel2002 export invariably seems
to crash DW4. So anything to do with DW4 strikes me
as unlikely to work, no?
Ship
S
Shiperton Henethe
I tried this (twice) but for some reason it didnt change anything
when I saved it. (I am using win2K)
Ship
M
Marc Bissonnette
Actually, It's a lot faster than you might think
I have to do this on an almost daily basis - the nice thing about using a
good text editor with a search-with-replace function is you have much
more control over your options.
For example, if you wanted the first column to be bolded, but the rest
not bolded, you could do this:
Export to CSV format.
Replace ^p with </TD></TR>^p<TR><TD><B>
then
Replace ^t with </TD><TD>
And voila
(Of course, the example above would not have closing boldtags in the first cell, but for quick and dirty, this does the trick,
nicely)
Good Luck!
S
Shiperton Henethe
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
A
Adrienne
Access 2000.
S
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
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
S
Shiperton Henethe
Adrienne said:
So near... yet so far!
Nope, sorry, it's getting the columns all wrong.
Now, how do I *CLEANLY* uninstall everything to do with Asctotab?
Ship