Request for Question Clarification by
02 Nov 2006 13:29 PST
Excel has a built-in converter which can convert an excel page
to HTML by selecting File -> Save as HTML.
However, many people have found that this conversion is not
satisfactory. One programmer, David McRitchie, has created
a VBS macro code, which can be installed into Excel, which
is an improvement on the built-in conversion:
Instructions for installing the macro script provided on that
page are given on this page:
If that still seems like it might be too difficult, you may
want to explore the highly-rated Click to Convert utility,
which sells for $119:
"Click to Convert masquerades as a printer and utilizes the
standard Windows printing technology to capture data from a
wide variety of programs, including - but by no means limited
to - all of the Microsoft Office apps, Microsoft Works and
You can download and test it for free, here:
Alternately, another Spreadsheet Converter from a Microsoft
Certified Partner can be found on this site:
and there's a Flash video demo that walks you through the
process of using the program here:
Other versions, for conversion to ASP & ASP.net and Java/JSP
are slightly more expensive.
And now for something completely different. Improbulus,
on his blog, has detailed how to email yourself an excel
file to a gmail account (hopefully you have one, or know
someone with a gmail account who can send you an invite).
Once the file arrives, gmail offers you the option of
viewing it or downloading it. If you choose 'view', it
converts the file into HTML for display. You can then
r-click the HTML display and choose 'View source'. If
you then select all of the source code and copy it to
a text file in Notepad, and then remame the file with
an HTML extension, you will have an HTML version of the
excel file to upload to your server. This may be more
work than you'd like, but it's free:
These appear to be the most promising solutions available,
and one of them may work for you.
I am not yet posting this as a formal answer because there
are conditions of your question which have not been satisfied,
and I'm skeptical that they can be, without the assistance of
a programmer to create a personalized code specifically for
this project. I'm reasonably certain that there aren't any
active researchers who have this sort of expertise. You
might consider hiring a coder at a site which specializes
in fulfilling such projects, such as RentACoder:
First, you want the spreadsheet to fit into your website
template, maintaining colors, border, links, etc. No generic
converter will be able to accomplish this, from what I see.
Second, you want individual rows of data to be reformatted as
HTML. I haven't used any of the software above, so I don't
know if any of it allows the possibility of selecting single
rows from an entire spreadsheet and converting only them.
One of them may allow for this, or it may be necessary to
create a new sheet for each row and convert that spreadsheet
to HTML. Alternately, a programmer could conceivably write
this into a program for you.
If you feel that I've earned my 75% of the question fee in
researching this and providing the options I've presented,
let me know, and I'll post a formal answer...
Searches done, via Google:
"excel to html"
"excel to html" web page template