If you’ve ever had to work with spreadsheets on a linux system, you may have stumbled across the PEAR Excel Spreadsheet Writer. Its a quite useful too, but installing it on your system may be a little misleading. Here’s the quick rundown:


# install php-pear
sudo apt-get install php-pear

# install PEAR OLE
sudo pear install OLE-1.0.0RC2

# install Spreadsheet_Excel_Writer
sudo pear install Spreadsheet_Excel_Writer-0.9.2

Not much to it, but just getting around the prereq of OLE. Now you should be able to create and edit Excel spreadsheets on linux. Of course if you have complete flexibility in requirements for your app, you would generate ODS, but I’ll leave that for a future topic ;) Unfortunately the corporate world is quite attached to .xls and xlsx files. Anyway.. Enjoy!