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. Link to comment https://forums.phpfreaks.com/topic/50676-solved-php-apis-to-read-microsoft-excel-rowscolumns/ 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. Link to comment https://forums.phpfreaks.com/topic/50676-solved-php-apis-to-read-microsoft-excel-rowscolumns/#findComment-249099 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 Link to comment https://forums.phpfreaks.com/topic/50676-solved-php-apis-to-read-microsoft-excel-rowscolumns/#findComment-249121 Share on other sites More sharing options...
arianhojat Posted May 9, 2007 Author Share Posted May 9, 2007 cool, thanx to both of you Link to comment https://forums.phpfreaks.com/topic/50676-solved-php-apis-to-read-microsoft-excel-rowscolumns/#findComment-249181 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.