Go Back   Tech Support Forum > Design Forum > Design Discussion & FAQs

User Tag List

[SOLVED] How can I make a site from an excel spreadhseet &amp

This is a discussion on [SOLVED] How can I make a site from an excel spreadhseet &amp within the Design Discussion & FAQs forums, part of the Tech Support Forum category. Ok, I recently received an excel file of items that I wish to display. The spreadsheet of items has 19


Closed Thread
 
Thread Tools Search this Thread
Old 01-19-2007, 10:54 AM   #1
ugsc
Guest
 
Posts: n/a
OS:



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!
 
Sponsored Links
Advertisement
 
Old 01-20-2007, 07:12 AM   #2
Design Team
 
KoosHopeloos's Avatar
 
Join Date: Nov 2004
Posts: 625
OS: Windows XP Pro, Vista Ultimate, 10 Pro and Linux Mint browsing the web with FF, Opera, Safari and IE


@ ugsc: can you give some more information? Are you going to let other people to add stuff to this sheet or are you going to add stuff yourself?

As far as I can tell I think you need to create a database and use a webpage as a interface...
__________________
Regards, KoosHopeloos

Emeritus member Design Team

KoosHopeloos is offline  
Old 01-31-2007, 09:28 AM   #3
ugsc
Guest
 
Posts: n/a
OS:


I am going to be adding stuff myself. I've been told that I need to export the file to a CVS and then import it with something like phpmyadmin.

Well I've tried doing this, but I'm not very well versed in DB management. I guess I should really read up on DB design and management.

Maybe someone here can help me and tell me if this is right:

Tables are selected fields to display information that you want. ex. you could have a table to show customers inventory info that may have the fields:
--PartNum, QuantityInStock, Manufacturer, PriceRetail
Another table for inventory management could be something like this:
--PartNum, QuantityInStock, Manufacturer, PriceRetail, PriceWholesale, Weight, Etc.

Is this correct? Tables are just different "views" of the data in the database?
 
Sponsored Links
Advertisement
 
Old 08-09-2007, 04:18 PM   #4
Guest
 
Join Date: Aug 2007
Posts: 21
OS:



Tables are where all your data is stored.

Datasets are generally where you store your temporary data...
That is, say you have a table with the fields Name, Address, and PhoneNumber. But you only needed the name and phone for a particular display. You would send a query (sql might be something like SELECT Name, PhoneNumber FROM MyTable) that data into the dataset. Then you can easily display that data from there.

So, the data sets would be the 'views', the tables actually contain the data.


Not sure what you're trying to do though...

If you have MS Excel has a Save as web page option (Save as, file type select web page. also has an option to make it interactive).

Re-read your post: the excel option would be so good. :P

You could very easily import your excel data into an Access database though (probably other types as well, depends what you like).
Then programatically pull the data to display on a web page. I like ASP.NET, but that requires you to have an ASP.NET-enabled server, and may be a little much, depending on what you're going for.
taker4mdb is offline  
Old 08-14-2007, 01:07 PM   #5
Registered Member
 
Join Date: Aug 2007
Location: Jamestown, CA
Posts: 896
OS: MacBook Pro / Mac OSX

My System


I'm not 100% clear on what you're wanting to do...but perhaps you could utilize Google Docs

https://docs.google.com/

You can upload, build, and publicize spreadsheets (as web document). It's worth looking into if that's the kinda stuff you're wanting to do.
Redcore is offline  
Old 08-20-2007, 08:23 PM   #6
Folding Along
 
gistek's Avatar
 
Join Date: May 2007
Location: PA, USA
Posts: 2,304
OS: Bobbi=xp, sp3 Muse=Vista Home Premium


Send a message via AIM to gistek Send a message via Skype™ to gistek

Or print to a pdf, upload the pdf and link to it from your index.

When the file changes, re-print to pdf and re-upload the pdf.

I do it all the time.
__________________
I am not a computer professional, My advice comes from personal experience and/or friends who are computer professionals. Interested in Search and Rescue? Check out the Civil Air Patrol. Come Fold with us. TSF [email protected] Team
gistek is offline  
Closed Thread

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is on
Smilies are on
[IMG] code is on
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Post a Question


» Site Navigation
 > FAQ
  > 10.0.0.2
Powered by vBadvanced CMPS v3.2.3


All times are GMT -7. The time now is 03:19 PM.


Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2020, vBulletin Solutions, Inc.
vBulletin Security provided by vBSecurity v2.2.2 (Pro) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.1.0 (Pro) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
Copyright 2001 - 2018, Tech Support Forum

Windows 10 - Windows 7 - Windows XP - Windows Vista - Trojan Removal - Spyware Removal - Virus Removal - Networking - Security - Top Web Hosts