Insert Images to Excel Spreadsheets with PHP on Linux

Insert Images to Excel Spreadsheets with PHP on Linux

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.

Simlified tutorial 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.