wright67uk Posted December 23, 2012 Share Posted December 23, 2012 Does anyone know how, I can interact with an excel database? I would like to pull certain info from an excel sheet and display in a website. The excel sheet is offline and is updated numerous times each day, and I would only want a couple of columns to be displayed online. Am I looking at a VB and php mix? Maybe I could upload everytime the excel sheet is saved? Any advice or suggestions? Apologies for the post being in this Forum IF php doesn't come into it. Link to comment https://forums.phpfreaks.com/topic/272315-excel-and-php/ Share on other sites More sharing options...
Christian F. Posted December 23, 2012 Share Posted December 23, 2012 First off: Excel is a spreadsheet, not a database. Though it may be abused and treated as one, it's far from being an actual database. The best advice would be to replace the spreadsheet with a proper database, if possible. The easiest way to do this, is to export the spreadsheet as a CSV, build the proper database structure, and then import it (via a PHP script, if necessary). That said, a quick search for "php excel" on the 'net gave me lots of options. I highly recommend doing the same. Link to comment https://forums.phpfreaks.com/topic/272315-excel-and-php/#findComment-1401039 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.