excel sheet -> webpage ? - GoFuckYourself.com

HQ · 03-12-2003, 08:13 AM

Is there any existing software that allows the creation of a website with all of a store's retail products and supplies (with prices, description, etc.) from an excel sheet that anyone can edit and update?

HQ · 03-13-2003, 05:04 AM

No one?

PersianKitty · 03-13-2003, 05:08 AM

There are some excel to html converters around.. not sure how it turns out..

Just a quick google search

http://www.livewebs.com/lwebsprod.htm
http://www.web100.com/sib/excel-to-html.html
http://users.aol.com/ksayward/XTML/

notjoe · 03-13-2003, 05:55 AM

Quote:

Originally posted by HQ
Is there any existing software that allows the creation of a website with all of a store's retail products and supplies (with prices, description, etc.) from an excel sheet that anyone can edit and update?

Just export it to a some kind of delimited text format and instruct the user to open it with xls.

This way they could probably make sense out of it even if they do not have xls installed or have some other program close to it.

The Truth Hurts · 03-13-2003, 06:01 AM

Doesn't your copy of Excel have the "Save as Web Page" option right in the File menu?

Mine does.

HQ · 03-13-2003, 12:13 PM

You're missing the point. The webpage should not look like an excel worksheet, but instead a well formatted website for a retial outlet store.

Somehow someone out there updates an excel worksheet of their inventory and in turn automatically updates their webpage. I'm just wondering what the most common and practical method is.

iroc409 · 03-13-2003, 12:20 PM

i'd probably use mysql, and have a php interface or something that would all be taken care of real-time online.

i think a lot of people do it that way, at least using mysql. never heard of doing it with excel ;)

bawdy · 03-13-2003, 01:46 PM

hmmm shouldnt be too hard under windows/asp as you can create a connection to an xls and access it like any other datasource.

Sleazylee · 03-13-2003, 05:13 PM

If you mean taking an excel database and then being able to search/display the results it in html, it is possible through active server pages. I don't know how to do it directly with straight html but its pretty easy through frontpage (ack i know :P), had to do it for a computer class last year. Search online for it, pretty easy to do.

European Lee · 03-13-2003, 05:39 PM

We can have one of our programmers do you a .php script that can format the text you give it from either excel or tab deliminated be shown on a html page if you are interested drop an email to [email protected]

Regards,

Lee

HQ · 03-14-2003, 07:17 AM

Quote:

Originally posted by bawdy
hmmm shouldnt be too hard under windows/asp as you can create a connection to an xls and access it like any other datasource.

This is probably the best solution... my servers are not Windows so I can't do this.

No big deal.

03-12-2003, 08:13 AM	#1
HQ Confirmed User Join Date: Jan 2001 Posts: 3,539	excel sheet -> webpage ? Is there any existing software that allows the creation of a website with all of a store's retail products and supplies (with prices, description, etc.) from an excel sheet that anyone can edit and update?

03-13-2003, 05:08 AM	#3
PersianKitty Meow Media Inc. Industry Role: Join Date: Jul 2001 Location: In the valley of the sun, cactus, tacos, tequila, and nod Posts: 7,785	There are some excel to html converters around.. not sure how it turns out.. Just a quick google search http://www.livewebs.com/lwebsprod.htm http://www.web100.com/sib/excel-to-html.html http://users.aol.com/ksayward/XTML/ __________________ Wondering what webmaster programs PK uses? Check them out here!

03-13-2003, 12:20 PM	#7
iroc409 Confirmed User Join Date: Jan 2003 Location: midwest side, yo Posts: 4,728	i'd probably use mysql, and have a php interface or something that would all be taken care of real-time online. i think a lot of people do it that way, at least using mysql. never heard of doing it with excel ;) __________________ <a href="http://www.iroc409.com/"><img src="http://www.iroc409.com/adv/120x60.gif" border=0></a> icq: 1 7 6 4 2 0 9 6 0 Gallery templates for ONLY $25! w00t!

03-13-2003, 05:39 PM	#10
European Lee Confirmed User Join Date: Dec 2002 Location: Daytona Beach Posts: 7,133	We can have one of our programmers do you a .php script that can format the text you give it from either excel or tab deliminated be shown on a html page if you are interested drop an email to [email protected] Regards, Lee __________________ YOUR TRAFFIC IS SAFE WITH US - CONDOM CASH PUTTING THE GAY ADULT INDUSTRY ON YOUR PC!! AFFORDABLE 2257 COMPLIANT GAY + BI CONTENT

03-13-2003, 05:04 AM	#2
HQ Confirmed User Join Date: Jan 2001 Posts: 3,539	No one?

03-13-2003, 06:01 AM	#5
The Truth Hurts Zph7YXfjMhg Industry Role: Join Date: Nov 2002 Location: In Your Skull Posts: 15,323	Doesn't your copy of Excel have the "Save as Web Page" option right in the File menu? Mine does.

03-13-2003, 12:13 PM	#6
HQ Confirmed User Join Date: Jan 2001 Posts: 3,539	You're missing the point. The webpage should not look like an excel worksheet, but instead a well formatted website for a retial outlet store. Somehow someone out there updates an excel worksheet of their inventory and in turn automatically updates their webpage. I'm just wondering what the most common and practical method is.

03-13-2003, 01:46 PM	#8
bawdy Confirmed User Join Date: Feb 2002 Posts: 1,424	hmmm shouldnt be too hard under windows/asp as you can create a connection to an xls and access it like any other datasource.

03-13-2003, 05:13 PM	#9
Sleazylee Confirmed User Join Date: Dec 2002 Posts: 208	If you mean taking an excel database and then being able to search/display the results it in html, it is possible through active server pages. I don't know how to do it directly with straight html but its pretty easy through frontpage (ack i know :P), had to do it for a computer class last year. Search online for it, pretty easy to do.