hyster Posted December 21, 2010 Share Posted December 21, 2010 i have a html page which is derived from an excel spreedsheet. is it possable to use php to search the page and pull a row of data from it and store them as $vars ? sort of treat it as a database. if so can you point me in the right direction. i tryed google with no luck. cheers Quote Link to comment Share on other sites More sharing options...
denno020 Posted December 22, 2010 Share Posted December 22, 2010 You can export your excel spreadsheet as a CSV file, and then use PHP to parse through it, grabbing what it wants, and ignoring what it doesn't. Don't ask me how to do that, I just know that it can be done lol. Other than that, I'm not sure there is much else that can be done. Denno Quote Link to comment Share on other sites More sharing options...
dreamwest Posted December 22, 2010 Share Posted December 22, 2010 load the file into a string then preg_match the search term Quote Link to comment Share on other sites More sharing options...
tibberous Posted December 22, 2010 Share Posted December 22, 2010 Are you able to use something other than an html file? Saving it as a tab delimited file and reading it into a 2 dimensional array is probably your easiest bet - but it really depends on what you are trying to do. Hell, if you have WAMP setup and Navicat, you can just import it into a mysql table and go from there. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.