DTP


 
Lively discussions on the graphic arts and publishing — in print or on the web


Go Back   Desktop Publishing Forum > General Discussions > Web Site Building & Maintenance

Reply
 
Thread Tools Display Modes
Old 10-19-2005, 02:38 PM   #1
Daudio
Member
 
Daudio's Avatar
 
Join Date: Aug 2005
Location: Royal Oak, Detroit suburb
Posts: 174
Default Excel to HTML table methods ?

I have a largish Excel spreadsheet (16 columns, many rows) that I'd like to publish.

I saved it as an .htm file in Excell 2000, but the resultant HTML is massivily bloated. There is too much junk to manually clean, and I want to re-style it.

So any better ideas on how to clean this file, or create a much simpiler one ?
And without buying any new software !

TIA

   
__________________
Dave

DaveAyers.com, Brass Backshop Forum
Daudio is offline   Reply With Quote
Old 10-19-2005, 08:50 PM   #2
Ian Petersen
Staff
 
Join Date: Nov 2004
Posts: 235
Default

You could try putting the html file though HTMLTidy: http://tidy.sourceforge.net/

   
__________________
Ian
Ian Petersen is offline   Reply With Quote
Old 10-19-2005, 08:51 PM   #3
gary
Member
 
Join Date: Dec 2004
Location: In the heart of Lake Minnetonka
Posts: 337
Default

Assuming you are ONLY interested in the data, save it as a CSV. Now that you are down to JUST the data (in a text format) you can start some creative editing. Too bad EX2K doesn't export to XML...

Alternatively you could write (Alt+F11) some VBA to output the sheet as an HTML table...
gary is offline   Reply With Quote
Old 10-20-2005, 12:12 AM   #4
LoisWakeman
Staff
 
LoisWakeman's Avatar
 
Join Date: Jan 2005
Location: Uplyme, Devon, England
Posts: 1,402
Default

Dave - have a look at upCast from http://www.infinity-loop.de/, which is Word to x(ht)ml - you could paste the table into Word first and style it as you want in the finished thing. I have used it to create pages from documents very successfully, and it is quite cheap to buy if you do this regularly.
LoisWakeman is offline   Reply With Quote
Old 10-20-2005, 12:42 AM   #5
Kelvyn
Staff
 
Kelvyn's Avatar
 
Join Date: Feb 2005
Location: In the Heart of the English Lake District
Posts: 1,381
Default

Quote:
Originally Posted by Daudio
So any better ideas on how to clean this file, or create a much simpiler one ?
And without buying any new software !
You may be pleased to know that DreamWeaver 8 is capable of removing all the code bloat from Excell & Word documents, simply by copying and pasting into the design window. For Excell this creates a table structure where the only formatting is table element widths and heights, removed in DW by 2 mouseclicks! Then styles can be applied to format to your own requirement.

I'll be writing some comments here on my testing of DW8 soon.

You don't have to buy it - you can download the trial version and use it for 30 days.

   
__________________
Kelvyn

Web site design, hosting and marketing, Keswick in the UK Lake District

If you are planning a visit to Keswick then try Keswick Tourist Information website

Kelvyn is offline   Reply With Quote
Old 10-20-2005, 04:50 PM   #6
Daudio
Member
 
Daudio's Avatar
 
Join Date: Aug 2005
Location: Royal Oak, Detroit suburb
Posts: 174
Default

I got it solved, Kind of...

I had converted the spreadsheet to an Access database sometime back and had a test .asp access program working. Since I already had that in place, I just removed all the filters and requested all fields. Then ran it in Firefox and copied the source into Wordpad and saved it as a text type .htm !

The file was clean of code crap, but had an unfortunate amount of excess white space and returns amongst the many rows. so it is a bit bloated byte wise, but only data, <tr>'s and <td>'s, so that works for now !

Thanks to all for offering suggestions for my problem !

PS. you can see it here

   
__________________
Dave

DaveAyers.com, Brass Backshop Forum
Daudio is offline   Reply With Quote
Old 10-20-2005, 04:59 PM   #7
ktinkel
Founding Sysop
 
ktinkel's Avatar
 
Join Date: Oct 2004
Location: In Connecticut, on the Housatonic River near its mouth at Long Island Sound.
Posts: 11,189
Default

Quote:
Originally Posted by Daudio
PS. you can see it here
Whew — that is some table.

Wonder if you shouldn’t dispense with the outlines and borders. It would be a lot less busy, and perhaps more readable?

   
__________________
[SIZE=2][COLOR=LemonChiffon]::[/COLOR][/SIZE]
[SIGPIC][/SIGPIC]
ktinkel is offline   Reply With Quote
Old 10-20-2005, 07:21 PM   #8
Daudio
Member
 
Daudio's Avatar
 
Join Date: Aug 2005
Location: Royal Oak, Detroit suburb
Posts: 174
Default

Quote:
Originally Posted by ktinkel
Whew — that is some table.

Wonder if you shouldn’t dispense with the outlines and borders. It would be a lot less busy, and perhaps more readable?
Yep !

I kindda like the outlines, to help the eye keep track of what's what. But I agree it surely needs some help.

I wanted to get the data up fast. When I have some more time I will try some styling to try and make it more readable. I have to come up with a 'data table' style at this point anyway.

I have finially finished applying my updated coding and stylesheet to all the pages on the site, and I now hope to be able to do global changes more easily, and play around with styling for all the pages at once !

Thanks for the feedback.

   
__________________
Dave

DaveAyers.com, Brass Backshop Forum
Daudio is offline   Reply With Quote
Old 10-21-2005, 05:21 AM   #9
ktinkel
Founding Sysop
 
ktinkel's Avatar
 
Join Date: Oct 2004
Location: In Connecticut, on the Housatonic River near its mouth at Long Island Sound.
Posts: 11,189
Default

Quote:
Originally Posted by Daudio
I have finially finished applying my updated coding and stylesheet to all the pages on the site, and I now hope to be able to do global changes more easily, and play around with styling for all the pages at once !
Sounds like a big job. Congrats!

   
__________________
[SIZE=2][COLOR=LemonChiffon]::[/COLOR][/SIZE]
[SIGPIC][/SIGPIC]
ktinkel is offline   Reply With Quote
Old 10-21-2005, 06:19 PM   #10
dacoyle
Member
 
dacoyle's Avatar
 
Join Date: Aug 2005
Location: Arlington, VA (across the river from Washington, DC)
Posts: 560
Default

Dave,

I used to use Dreamweaver for this, but recently found a much faster method using HomeSite.

Copy the text in Excel.
Paste into a blank (no code) document in HomeSite
Do two Extended Search and Replace.
First: replace carriage returns with

</td></tr>
<tr><td>

Second: replace tabs with

</td><td>

Then tweak the start and begginning and add the <table></table> tags and you're likely done. For complex tables that need rowspan or colspan, I switch to Dreamweaver and use the Merge Cells function. I just did a fairly large basic table this afternoon (no rowspan or colspan) in less than 5 minutes.

I've done this with small and huge tables with huge success.

Dennis

   
__________________
Dennis
dacoyle is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Candidate site contribution methods dthomsen8 Web Site Building & Maintenance 1 07-12-2006 07:42 AM
MS Excel--->HTML Linda Baldwin Web Design 12 07-12-2006 12:56 AM
pasting a gradient Excel chart into InDesign Jas Mandla Print Design 8 06-25-2006 05:35 PM
importing excel files to indesign dehavenphoto Print Design 2 09-27-2005 06:33 PM
ASAP Utilities for Excel Andrew B. Software 0 04-11-2005 04:23 PM


All times are GMT -8. The time now is 10:19 AM.


Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Contents copyright 2004–2014 Desktop Publishing Forum and its members.