Posted by
reynold
In:
Excel,
PHP
Have you ever faced a situation when you need to manipulate Excel spreadsheets(ex. insert or embed pictures) with PHP on the server that is running Linux (so COM is not an option)? With Open XML and PHPExcel you can do that now. :)!
PHPExcel uses OpenXML which is compatible only in OpenOffice3.0 which would not show any embeded images on your spreadsheet. I don't know if there's a workaround for this but I think if there are plugin for openoffice to work with Office2007 then it should make it work. yah..maybe.
BTW, this library works in windows too...
Download PHPExcel Library here.
Note:
Make sure zend.ze1_compatibility_mode is disabled in your php.ini. This is turned on by default in Linux LAMMP, I almost give up on this class until I found out that sh*t.
1 comments:
Thank you for adding a link to my tutorial :)!
As for PHPExcel it can work with old binary Excel format as well, it uses a PEAR library for this though.
Post a Comment