monkeytooth Posted May 15, 2011 Share Posted May 15, 2011 I need a way of parsing Excel files.. both xls and xlsx in what seems to be various formats.. the concept of the way the expected sheets are to come in is with 2 tabs first tab row one column one will be a single value.. second tab will be any number of values only 2 columns though. I had found one parser class that I could use but it was very limiting and for some reason didn't work when I saved a fresh file... whats the best class, or way of handling an excel file? is there anything out there freely avaliable to work with thats kept upto date? or that works? Quote Link to comment Share on other sites More sharing options...
anupamsaha Posted May 15, 2011 Share Posted May 15, 2011 You can check this out: http://phpexcel.codeplex.com/ Also, search in http://www.phpclasses.org/ for the class that handles excel files. Thanks! Quote Link to comment Share on other sites More sharing options...
requinix Posted May 15, 2011 Share Posted May 15, 2011 If you're running on Windows then you can use ADODB and Microsoft.Jet.OLEDB to read the files as databases. Each tab is a table and you can SELECT from it just like from a normal database. 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.