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 08-07-2006, 12:52 PM   #1
dthomsen8
Member
 
dthomsen8's Avatar
 
Join Date: Aug 2005
Location: Philadelphia, PA 19130
Posts: 2,158
Default XLS to HTML

I need to convert an Excel spread sheet, 18 rows and 10 columns, to HTML. The original has a heading and a footer and two blank rows, but those will be easy enough to create by hand.

Searching for Convert XLS HTML, I find a vast variety of tools, ranging from free (with an easy demo) to hundreds of dollars. I only have one spread sheet to do, and hundreds of dollars is silly, I can create the HTML by hand for a lot less than that, having exported the table to comma delimited text.

A free demo/free tool site creates an absolutely huge HTML file, just what I don't want. There is little point in paying very much for a conversion tool, unless the results are going to be reasonable, not huge with many, many font definitions.

Do forum members have a better idea?

Last edited by dthomsen8; 08-07-2006 at 12:53 PM. Reason: fix typo.
dthomsen8 is offline   Reply With Quote
Old 08-07-2006, 01:54 PM   #2
Kelvyn
Staff
 
Kelvyn's Avatar
 
Join Date: Feb 2005
Location: In the Heart of the English Lake District
Posts: 1,381
Default

Just use the mouse highlight the required data & copy this from the Excell display and paste into a blank XHTML page using the design window of DreamWeaver. It converts the data into a simple table structure which you can then style however you wish.

   
__________________
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 08-07-2006, 02:12 PM   #3
Steve Rindsberg
Staff
 
Join Date: Nov 2004
Posts: 6,707
Default

One quick and dirty approach:

Select the content you want to convert in Excel.
Choose File, Save as
Pick Web Page/HTML
Click the "Selected area" radio button (wording may vary but it'll be obvious)
Give it a name and save.

ISTR that you can edit the result, put other content around it but as long as you leave certain comments in place, it'll allow you to republish "into" the same HTML file but leave your added content alone.

Or something like that.

   
__________________
Steve Rindsberg
====================
www.pptfaq.com
www.pptools.com
and stuff
Steve Rindsberg is offline   Reply With Quote
Old 08-07-2006, 03:53 PM   #4
dthomsen8
Member
 
dthomsen8's Avatar
 
Join Date: Aug 2005
Location: Philadelphia, PA 19130
Posts: 2,158
Default Table Created!

Quote:
Originally Posted by Kelvyn
Just use the mouse highlight the required data & copy this from the Excell display and paste into a blank XHTML page using the design window of DreamWeaver. It converts the data into a simple table structure which you can then style however you wish.
Yes, that did exactly what I wanted, and very easily too. It didn't work with Excel 98, but it worked just fine with Excel 2003.
dthomsen8 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
HTML page to JPG? dthomsen8 Web Site Building & Maintenance 11 09-14-2006 06:25 AM
MS Excel--->HTML Linda Baldwin Web Design 12 07-12-2006 12:56 AM
If you like HTML even a little... iamback Web Design 0 06-09-2006 12:15 AM
DW 2004 with .htm or .html dthomsen8 Web Site Building & Maintenance 56 01-31-2006 09:07 PM
Semantic HTML? ktinkel Web Design 7 08-30-2005 11:50 AM


All times are GMT -8. The time now is 10:04 PM.


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