In my cms there is a module and it allows you to export all orders for a particular date to an xls file.
I have it all working, but I am unable to style the columns to dynamic widths or add any colours.
My only reason for using the PEAR one is that the server already had PEAR installed and was using some other PEAR features.
It may be useful to gain some insight from someone who has used the two, or even an article about them, so that we may find out the significant differences between the them.
The documentation says that the Excel 5 (BIFF) file format is just a modification of PEAR’s Spreadsheet_Excel_Writer, so is PHPExcel just a native implementation of PEAR’s one? Enquiring minds want to know.