arianhojat Posted May 9, 2007 Share Posted May 9, 2007 I was looking for classes to read and write Excel files in php. Didnt seem to find anything built into php, but found 2 separate projects... For reading an Excel file: www.sourceforge.net/projects/phpexcelreader and for writing an Excel file: www.pizzaseo.com/php-excel-creator-class The writing part works perfectly. However the reader tries to see what excel data format the cell is in, and tries to format it. It goofs alot on dates... For example if a column has data of 9/30/2006 then it gives you a value of 29/09/2006. It would be nice to get the value without formatting, but unfortunately nothing i try works. anyone have any new php API's that read Excel files (easy API's to read rows/columns)? Thanks in advance. Quote Link to comment Share on other sites More sharing options...
cmgmyr Posted May 9, 2007 Share Posted May 9, 2007 Check out what I posted here: http://www.phpfreaks.com/forums/index.php/topic,133807.msg563168.html#msg563168 hope that gets you started. Quote Link to comment Share on other sites More sharing options...
emehrkay Posted May 9, 2007 Share Posted May 9, 2007 $f = fopen($file, 'r'); while ($row = fgetcsv($f)) { } fgetcsv and fputcsv are built into php to handle csv files Quote Link to comment Share on other sites More sharing options...
arianhojat Posted May 9, 2007 Author Share Posted May 9, 2007 cool, thanx to both of you 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.