PDA

View Full Version : How can I make a site from an excel spreadhseet & corresponding jpgs?


caffiendo
January 19th, 2007, 09:03 PM
Ok, I recently received an excel file of items that I wish to display. The spreadsheet of items has 19 fields/columns and a lot of rows or Entires.

The spreadsheet has a primary key (unique identifier) but not labeled as such. The spreadsheet has everything needed, information wise, for a webpage

There are also pictures and thumbnails that correspond to the primary key spreadsheet. The picture is the primary key +.jpg

What is the easiest way to go about setting up a functional webpage? I'm not extremely comfortable with web programming but can feel my way through if pointed in the right direction. If someone can point me to a sample of tell me what type of programming will do what I want that would be great too!

I have been using Macromedia DreamWeaver 8 recently and like this.

I REALLY appreciate anyone here steering me in the right direction. Thanks so much!

Buzz
January 19th, 2007, 10:27 PM
I'm not terribly sure you can take excel to the web effectively.

"Effectively" being the operative word.

You can just use File > Save as Web Page. But that will generally create horrible code for a web page, although it will work.

What I would do is create a web page then, save all the images from the Excel file, then copy > paste data from Excel into the web page that was built from scratch.