Excel to HTML?

Hi,

I have a spread sheet that I would like to create pages from each entry for.

Each column is a different item i'd like integrated into the page.. the spreadsheet is layed out like this:

The columns:
[ministry name] [start date] [nature of ministry] [president] [website] [imagefile]
Each row has the information on one organization

Is there a way to create pages dynamically from each row? To layout something like this:
--------------
[ministry name] started in [starte date] and has become a amazing ministry for building the kingdom of God. [ministry name] specializes in [nature of ministry] and [president] currently serves as the persident of the ministry. To get additional information on [ministry name] visite:
[website]

[imagefile]
---------------

Thanks in advance. I'm open to suggestions... and willing to use any other tools etc..

 

Dynamically? You mean upload the spreadsheet somewhere and then have some program pull the relevant information to create a page so that when the spreadsheet is updated the site gets updated too?

No that I know of. You can sort of create the pages with creative use of the =concatenate() function, but it's not really ideal and won't be dynamic. It'll be much better if you use a database, like MySQL or Access, and a scripting language like PHP or ASP for your project, depending on what you use for hosting.

I know Office includes some extensions that can be integrated with IIS to present tables and other content dynamically using ASP.net, but they have the most stupid license ever created (ie. you can't use it in a website accessible from outside your organization)

 

Thanks for the input! Can you point me in the right direction of how to use mySQL for this?

 

Well, you need to create a database in mySQL, how you do it will depend on what kind of server you're using to host it.
To use the information on the database you'll need to write a script that will call that information and format the output how you want it. Again, how you do that will depend on the server you're using.
Read on how to use PHP and ASP with databases. w3schools .com is an excellent resource to start.

 

Thanks alot.

 

You could export to CVS or possibly even a MS Access database format depending on the contents of your file for easier import/export to any SQL based format.

 

Ok Great!

If i used mySQL and PHP. How would i be able to do this? Or is there someone out there that would be willing to take this on as a job?