K-man

Hello,

For my intranet (running mambo 4.5 - 1.0.7) I have some content based on Excel lists. When I save an Excel file as html I get this crazy html. It looks good on Mambo, but when I use the Mambo PDF function I get a messed up PDF: http://www.alders-transport.be/ugly_pdf.jpg

Anyone know a way to clean up the Excel HTML? Or to make a copy of Excel data in good html code? HTML Tidy doesn't do the job, HTMLArea3 Extended neither...

Thanx in advance.
Karel

K-man

bump bump...

pixelsoul

In dreamweaver there is a function clean word html... there will prolly be other proggy's to

__________________
Visit my site for pro mos templates www.pixelsoul.net

stingrey

Hey cool, thanks for the heads-up Pixel

Never knew such a function existed in DW, but then again I probably only know how to use 5% of what DW can offer

__________________
Joomla! Core Team Member
Software Coding & Design - Stability Team Leader
www.joomla.org
Former Mambo Core Team Member

peterfagerberg

If you switch editors to htmlarea3_xtd it also has a function to clean up Word HTML.

gaby

Good luck with htmlarea3_xtd it is rather eratic and doesn't work at all for various reasons.

At present there are no real fixes or positive solutions to many common problems. not sure why

lthouse

You can also try the Microsoft's HTML tool at:

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

I've had some success with the tool but on my Word files it still left too much stuff as did DreamWeaver. I eventually bought a program from Mambosoft called Word Cleaner as I had a several hundred articles I needed to clean up. The program comes with a 15 day trial. It was more money than I wanted to pay, but in the long run it's saved me a lot of time.

Anne

stingrey

Freaky that the program should be gcreated by a company called mambosoft

__________________
Joomla! Core Team Member
Software Coding & Design - Stability Team Leader
www.joomla.org
Former Mambo Core Team Member

liquid

Google HTML Tidy.

I use it for all M$ docs that I convert to HTML. Basically I take my Word or Excel file and save as HTML in either Word or Excel. I then open HTML Tidy, load the config file I created to strip out all the bloat from the M$ HTML docs. Then I load in the M$ HTML file, click the Tidy! button, click the Replace button, look thru the resulting code to verify that all of the bloat is gone and then save it. It strips out everything but the very basic commands like <p>, <b>, <i>, <h1>, <table>, <img>, etc. It's then very easy to then copy the code and paste it into the WYSIWYG editor. I love it.

Shane

gaby

I've discovered Open Office and it doesn't generate the garbage that MS Office products do and XML compliant. MAkes me wonder why I bother with all the MS antics?