Tag Archives: PHPExcel

PHPExcel reports generation

I worked on an assignment where the desire was to generate excel report of Formidable Pro entries from front end view. After some research, I chose PHPExcel as the library of my choice. The reason for using PHPExcel is a mature library combined with comprehensive documentation. Once you download the library and explode the zip file, all you require is the core, i.e. the *Classes* folder uploaded to your custom project. Include the library in your custom code using the lines below
ini_set('max_execution_time', 0); //this is optional and may be required if the data set is huge. It increases the script execution time
require_once 'path/to/Classes/PHPExcel.php';
//your custom code to generate report

I found PHPExcel to be quite efficient and mature for generating reports for analytics. However, please feel free to share your experience and let me know if there is a better library which can deliver the same results more efficiently.