generating excel files programmatically

I remember dealing with this problem a few years ago. At that time, I didn’t know better so ended up generating tab delimited files. A few years later, I finally gain my dignity back by generating real excel files.

I found many libraries out there, below are a few:

Ruby roo:
Ruby spreadsheet:
Apache POI (Java):
Pear Spreadsheet_Excel_Writer (PHP):
Python Excel:

I believe they will all work just fine as they all look promising.

I played with PHPExcel a little. It’s pretty good in what it does. If you are not going with crazy charts and formulas, PHPExcel should be more than enough for you. It also comes with many sample php files. Recommended!

Leave a Reply

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

You are commenting using your 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 )

Connecting to %s