Solved

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

Posted on 1998-02-20
14
179 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

 
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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Get to know the ins and outs of building a web-based ERP system for your enterprise. Development timeline, technology, and costs outlined.
An enjoyable and seamless user experience can go a long way on an eCommerce site. While a cohesive layout and engaging copy play roles in creating a positive user experience, some sites neglect aspects that seem marginal but in actuality prove very …
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
Any person in technology especially those working for big companies should at least know about the basics of web accessibility. Believe it or not there are even laws in place that require businesses to provide such means for the disabled and aging p…

717 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