Uncategorized

PHPExcel – Simply fantastic!!!

Thanks to David Umoh I’m encouraged to write again. Nothing beats others finding your writings useful and that made me really glad, after all that’s the reason I write.

I recently decided to implement an invoice generator (a personal project) and  first thing that came to my mind is PHPExcel and I thought this is an excellent topic to write on.

PHPExcel is an excellent PHP library that can generate Excel 2003, Excel 2007, CSV, PDF, and HTML documents. As its name implies the main purpose is for the generation of Excel documents. PHPExcel not only generates excel documents but it can read excel documents. It is feature-rich, supports cell styling, adding data and formulas, pictures, and much more.

One thing I really love about it is that to switch between formats. For example, I once created a report generator with it and I could easy output PDF, CSV, Html, Excel formats by just changing a few parameters.

Here is an example of a document generated using PHPExcel.

PHP Excel Example from phpexcel.codeplex.com

PHP Excel Example from phpexcel.codeplex.com

 

Standard

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s