Google Answers Logo
View Question
 
Q: HTML page generator ( Answered,   0 Comments )
Question  
Subject: HTML page generator
Category: Computers > Internet
Asked by: stenning-ga
List Price: $3.00
Posted: 11 Apr 2003 07:09 PDT
Expires: 11 May 2003 07:09 PDT
Question ID: 189243
Html page generator question

I have a list of phrases in MS Excel and want to automatically create
individual html pages based on each phrase.

The html page should have the title tag, page name and first word as
the corresponding keyword from Excel.

So, the page would look like this:

<html>
<head>
<title>Keyword Phrase</title>
<meta http-equiv="Content-Type" content="text/html;
charset=iso-8859-1">
</head>

<body>
Keyword Phrase 
</body>
</html>

and would be called: keyword_phrase.htm

And I want to automatically do this from the list of phrases in Excel or a txt file.

Clarification of Question by stenning-ga on 11 Apr 2003 07:11 PDT
I have seen numerous websites that offer individual page generator, I
am loooking for a more automated solution or program to create many
pages quickly.
Answer  
Subject: Re: HTML page generator
Answered By: mosquitohawk-ga on 11 Apr 2003 07:58 PDT
 
Hello stenning,

I believe I've found several utilities you will find useful:

Excel-to-HTML converter (macro)
http://www.web100.com/sib/excel-to-html.html

Retains cell formatting from spreadsheet. 
Uses first column and/or row of spreadsheet as table header. 
Reduces font size in table to accomodate large spreadsheets. 
Keeps explicit horizontal alignment from spreadsheet. 
Builds either a complete HTML document or just a table for inclusion.
Records source file name in output file. 
Records date and time of processing in output file. 
Retains column width proportions from spreadsheet. 
Easy-to-use! 

***

Convert Zone
http://www.convertzone.com/xls2htm/help.htm
Batch xls converter, converts multiple xls files all at one time.
($120)

***

For Excel 97
http://www.livewebs.com/lwebsprod.htm
Easily convert your spreadsheets into web pages, and get them up to
your web server.

***

GuyMcArthur.com
http://guymcarthur.com/resources/vbs/excel2html.xml
Scripting Code Export Excel docs to HTML

***

Web Effects Design
http://www.webeffects.ws/v3/ex2html.htm
This company will do it for you if you pay them. 

***

My search strategy was to use the phrase "excel to html" with
google.com. This resulted in the following url -->
://www.google.com/search?hl=en&ie=UTF-8&oe=UTF-8&q="excel+to+html"
with many quality results, a few of which I've posted above.

I hope this helps you in your needs, please don't hesitate to request
clarification if necessary.

Best regards,

mosquitohawk-ga

Request for Answer Clarification by stenning-ga on 11 Apr 2003 10:50 PDT
Hi

This option looks best:

Excel-to-HTML converter (macro) 
http://www.web100.com/sib/excel-to-html.html 

But it asks you to save the file in the macro location, but I dont
know where this is? I am running xp proffesional and Excel 2002.

Thanks

Lee

Clarification of Answer by mosquitohawk-ga on 11 Apr 2003 11:00 PDT
Hello again, glad you found one of my answers helpful.

According to http://www.web100.com/sib/convert.html, the place to put
the unzipped convert.xlm file is in your folder c:\...\excel\library\

Note: Your folder might not necessarily be named 'excel', I am
referring to the folder where you excel program is stored, whatever
it's name may be.

If you follow this link, you will find detailed instructions on how to
install this file and use it:  http://www.web100.com/sib/convert.html

Good luck!
Comments  
There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy