Installing PEAR Spreadsheet_Excel_Writer

Update: Before using this library, see PHP Excel that has support for more recent formats of XLS and Office 2007′s xlsx format.

---

Quick post to consolidate information around the net. Installing this package is not as straight forward as most, as it’s in the beta channel.

Failed to download pear/Spreadsheet_Excel_Writer within preferred state "stable", latest release is version 0.9.1, stability "beta", use "channel://pear.php.net/Spreadsheet_Excel_Writer-0.9.1" to install
Cannot initialize 'channel://pear.php.net/Spreadsheet_Excel_Writer', invalid or missing package file
Package "channel://pear.php.net/Spreadsheet_Excel_Writer" is not valid
install failed

Behold:

pear config-set preferred_state beta
sudo pear install ---onlyreqdeps Spreadsheet_Excel_Writer

Include the onlyreqdeps switch so that the dependency package PEAR OLE is installed.

Tweet
You can skip to the end and leave a response. Pinging is currently not allowed.