Solved

Looking for an ExcelDB -> Webpage generation tool...

Posted on 1998-02-20
14
174 Views
Last Modified: 2013-12-25
I'd like to be able to use an Excel spreadsheet/database to generate generic web pages.  These "skeleton" pages would only contain a few fields of information about local businesses.  If you know of a tool which with which I can set up a template, and then have the application generate pages based on that template and the information contained in the database, please let me know.
0
Comment
Question by:eason
  • 6
  • 5
  • 2
  • +1
14 Comments
 
LVL 3

Expert Comment

by:bigelos
ID: 1857479
Microsoft's Excel Internet Assistant will let you publish Excel files on the web.  The URL is
http://www.microsoft.com/MSOffice/MSExcel/Internet/IA/default.htm

The link is really slow, though.

Note:  I won't be able to check my mail until March 4.
0
 
LVL 3

Expert Comment

by:bigelos
ID: 1857480
Here is another link that should work better (just description):
http://zuni.cnet.com/Resources/Swcentral/Mac/Result/TitleDetail/0,160,0-16654,00.html

Don't use the above link to download, since it links to mickeysoft.

The actual file link is ftp://www.lts.uwstout.edu/software/Internet Assistant/html.xla

Found at
http://144.13.6.10/LTS/html/software.html

SHIFT-CLICK on the words MS EXCEL IA to download properly.
0
 

Author Comment

by:eason
ID: 1857481
The file that you sent me to looks to be some kind of Excel macro....not sure how to use it, and this Internet Assistant isnt documented in any of the places Ive checked.
0
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 
LVL 3

Expert Comment

by:bigelos
ID: 1857482
It is an Excel macro.  It lets you publish HTML documents from Excel.  Documentation can be found at
http://www.microsoft.com/MSOffice/MSExcel/Internet/IA/default.htm 

Also, it is pretty much self explanatory.  Just go to the tools-macro menu and run the macro on the document you want to convert to HTML.
0
 

Author Comment

by:eason
ID: 1857483
Im not looking for a simple Excel -> HTML convertor....I can find those most anywhere.  If you read my initial message, Im looking for an application which will let me pull data (Business names, addresses, etc.) from an excel spreadsheet to create generic pages for each business, based on a pre-set template.
0
 
LVL 3

Expert Comment

by:bigelos
ID: 1857484
That's what this will do, if you use it correctly.  But hey, feel free to keep looking if it is not what you want.  I've used it many times to do exactly what you are doing, but in the end, you get to choose what software you want to use, and you get to decide what is best for you.

Sorry I can't help you more.
0
 

Author Comment

by:eason
ID: 1857485
Perhaps its just my lack of knowledge when it comes to Excel macros.  Perhaps if you can find some documentation for this file (html.xla), we'd be in business. (The documentation that you pointed me to in a previous comment does not exist....if youd be so kind as to check the links before you post them, Id appriciate it.)
0
 
LVL 6

Expert Comment

by:jpk041897
ID: 1857486
If you place your data in an Excell Database, then you might want to look at allaire's Cold Fussion. Their URL is:

http://www.allaire.com

Their product is a template based ODBC web page generator that does, I belive, exactly what you want.

You can dowload a demo version and see if it solves your problem.
0
 
LVL 6

Expert Comment

by:jpk041897
ID: 1857487
Allaire's Cold Fussion uses templates to access ODBC Databases using ODBC to fetch the data. Their URL is:

      http://www.allaire.com 

 You can dowload a demo version and see if it solves your problem.
0
 
LVL 3

Expert Comment

by:bigelos
ID: 1857488
eason,

Sorry it has taken so long to get back to you.  I cannot find any more documentation for the Excel Internet Assistant.

There is another tool that will convert your Excel spreadsheets to web pages.  It can be found at:

http://www.visualcomp.com/products/fo.htm


0
 
LVL 3

Expert Comment

by:bigelos
ID: 1857489
comment to prevent autograding
0
 

Author Comment

by:eason
ID: 1857490
Already found my solution.  Is there any way to kill this thread?
0
 

Accepted Solution

by:
plandy earned 70 total points
ID: 1857491
Try looking at Netobjects Fusion. It allows you to grab Excel worksheets. If you arrange your data in a list. i.e. First row headings and data under that it is easy to genrate a series of stacked pages with navigation buttons. If you link the site project file to your spreadsheet, each time you regenerate your web site files your data will be updated
0
 

Author Comment

by:eason
ID: 1857492
Ah....had been looking into familiarizing myself with Fusion....guess this is a good reason to start now.  Thanks.
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Author Note: Since this E-E article was originally written, years ago, formal testing has come into common use in the world of PHP.  PHPUnit (http://en.wikipedia.org/wiki/PHPUnit) and similar technologies have enjoyed wide adoption, making it possib…
Because your company can’t afford for you to make SEO mistakes, you’ll want to ensure you’re taking the right steps each and every time you post a new piece of content. This list of optimization do’s and don’ts can help you become an SEO wizard.
Viewers will get an overview of the benefits and risks of using Bitcoin to accept payments. What Bitcoin is: Legality: Risks: Benefits: Which businesses are best suited?: Other things you should know: How to get started:
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question