Hi I have good knowledge of HTML and CSS, but not good with databases. I'm trying to set up a product image gallery and there are thousands of products that I need to display and link to actual pages. I want to accomplish this by linking the gallery page to my Excel Sheet so that I can reduce my work load. Is there a way to link the html page to an Excel Sheet? I will update the Image URL, Linking Code and 'one line text to display below each image' in different columns in the Excel Sheet. Can someone provide the coding to display objects in different columns or rows of the Excel Sheet, on my webpage? I really don't think it should be tough. But if someone can give me a small example of displaying text from 1 cell to the webpage, I can design the structure pretty much on my own. I just need a clue of what coding will goto the html page to link it to the Excel Sheet and then what coding is required to display information from my excel sheet to my webpage. Please provide some assistance. Even if you know a way to link txt file or csv file to a webpage, I will understand the coding and then can further research on this. Any help would be appreciated. Regards, Andy.
Just to clarify that an Excel Spreadsheet is not a database. If you can transfer the spreadsheet data into a database (Access, MYSQL etc google is your friend), then what you wan't to achieve would be pretty simple. I am not sure If you would be able to link a spreadsheet to a webpage, it's pretty unlikely though.