Hi All,

I am creating a spread sheet containing my product inventory. After I am done creating the spread sheet, I want to use that data inside html pages.

Question:

How can I just add the field names to the html template to display the contents where I want it? The end result would be to create an html page for each item number.

Just looking for the quickest way to accomplish this task. Preferrably using html. Not looking to do this via server side programming unless it's possible to accomplish it using server side programming AND THEN when it's done 'templating' it doesn't require php. The final result will be used on a computer with no-server side capabilities.

Any Ideas??

Thank you.
-Brian

I figured out what to use...

Xls2html was the program, and works just fine.

I'm confused ... what exactly are you trying to accomplish - or, I guess, what is it you've figured out how to do? I'm confused about wanting spreadsheets, but normal html with no server side coding?

I'm confused ... what exactly are you trying to accomplish - or, I guess, what is it you've figured out how to do? I'm confused about wanting spreadsheets, but normal html with no server side coding?

Ok,

So far, I've created an xls file (Spreadsheet with my inventory) now what I want to do is make it into a template. Create tables on a webpage and put 'placeholders' from the spreadsheet into the template.

I downloaded Xls2html to do that for me which works great, only 1 problem I'm having and I only have a few days to get this worked out.

Problem:

If you study how this xls2html works then you will note it could be a bit confusing...

Check it out:

I have a field in my xls (spreadsheet) which contains a link to a image. Now I want to use a lightbox to open the image up, but I have a problem with the <a href tag (sounds simple) but here's what the xls2html link looks like:

<a href="<#EXCEL Sheet="1" Cell="A2">">link</a>

Now to make it brief, the above code assumes that in the xls file you have a hyperlink inserted into Sheet 1 and Cell A2. I do...It's an image.

Ok now that you have the 'jist' of what I mean about the href tag, could someone help get the lightbox example below to work with the above <a href tag?

<a href="dog.jpg" rel="lightbox" ><img src="dog_thumb.jpg" /></a>

Thank you

FIGURED IT OUT

Sorry for the caps

<a href="<#EXCEL Sheet="1" Cell="F7">" rel="lightbox"> <img src="Images/Thumbs/thumb.jpg" /></a></font></td>

It was really simple, but I didn't go that route at first...I thought I was going to need more quotes and > when I really didn't...I hate it when that happens, but good to know it was a simple solution.