The e-laboratory

A few weeks ago I worked with Phing to generate the documentation of a PHP project thanks to the excellent library PHPDoc. I currently work at a total redesign of my blog: migrating to Drupal 7, incorporating a custom theme from a template purchased on Theme-forest, publication of some articles started but not completed, ...

I'm currently working on a game project in Flash, and I decided not to work with AMF-PHP ( despite the SilexLab enthusiasm and the version 2 in the pipe) but with ZendAMF.

This is my last snippet about PHPExcel, I promise you (;-). I just finished a big project and I do not want to spend my life generating Excel documents, despite the PHPEcel efficiency.

In the meantime, here are a few lines about the generation of dynamic lists of suggestion. They are very useful to constrain the user to certain values, and allow it to go faster by pre-filling some cell.

header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="training-schedule.xls"');
header('Cache-Control: max-age=0');

At work, chez LesTanukis, I generate Excel files all day thanks to the excellent open source library PHPExcel. I have asked myself how to structure the code, specialy the graphic part. To format a document, the easiest way is probably to call "applyFromArray" on an cell instance. However, to do something pretty, you must often aplly 5 or 6 directives to each cell, often with very different codes (title, banner, single cell, columns names, ...).

I spent several hours today to fix a bug in IE7. We generate on the fly many Excel document, and offer to our users for download. Except that IE7 prompts the user to download a .zip, never a .xlsx. If I download the file, and open-it with Excel, no problem, the file is read and perfect. The problem is the MIME type, IE7 seems to need that Apache sends precisely the right header.

Hello guys, I am opening here a new section, which I intend to regularly publish a small snippet of code that