Export excel --> html - How to clean html?

[BITM@D]

I have an excel worksheet which is a simple table with 4 columns and about 1700 rows. I want to export it as a web page but the page ends up being massive (over 1.3mb). I see lots of excel specific code in there and was wondering if there was a way to clean the html that excel (2002) puts in there.

[VHockey86]

thats really damn big for an html file, you're better off just exporting it as a .txt file and then linking to that (txt files will load in the browser)

I tried making a sample page of 2000 rows and 4 columns and tried to import the excel file into dreamweaver and it gave me a message that said "file is too big and would take a very long time to import, please try breaking into multiple pages"

Which seemed really dumb.. but who knows.

[Siliconjunkie]

I had a DB query in the mysql client that spit out a 22 meg HTML file, 7 columns and over 100,000 rows. Made IE and Mozillia choke easily.

Text will be much easier on the browser but not as pretty.

[crouse]

Short answer : Yes

Longer answer...... it takes going through the entire file line by line and removing the "extra" garbage that gets stuck in. Doing a search and replace "might" be and option for some things........ Lots of work..... but possible to reduce the file size quite a bit if you have the time and know how.

[BITM@D]

The original xls file is 305kb. The csv file is 174kb. Is there a program that will clean the html code from an excel generated html page like dreamweaver does to word exported html?

[Siliconjunkie]

What about cutting and pasting it into Dreamweaver or similar?

[VHockey86]

I tried pasting into dreamweaver but it just gave an error sayign it would be too large

[jmichna]

You should be able to import the Excel file into html, then strip out anything Excel-specific, leaving only the values and the tags html uses to create the table: <table></table> (table) or <tr></tr> (table row) or <td></td> (table cell).

The structure will look like:

<table>
   <tr>
      <td> your 1st col</td>
      <td> your 2nd col</td>
      <td> your 3rd col</td>
      <td> your 4th col</td>
   </tr>
The above will be repeated 1700 times (once for each of your rows) then the end table tag
</table>

If you have W2K or XP, Notepad can do a Find... Edit... Replace and you can manually strip out all the extra Excel junk.

[BITM@D]

That was the horror alternative I was facing. I was hoping for a better way. There is lot's of code.

[VHockey86]

how badly does it need to be in html? Do you need the "interactive" features?
Even if u were able to cut the code/filesize in half it would still be really big, and a pain for web browsers to handle/load

Just imo, but I think your best bet is txt or rtf