How to formatting Excel Sheet cells using PHP

Please help me about my doub开发者_运维技巧ts on excel and php. I need to do the following process on excel report generation using php

1. to change cell's font styles
2. to change cell's BG color
3. to change cell's width

---

Try PHPExcel. I started using it few days ago and it works very good.

---

With PHPExcel

• http://phpexcel.codeplex.com/wikipage?title=Features
• http://phpexcel.codeplex.com/wikipage?title=Examples

With PEAR Spreadsheet Excel Writer

• Format::setBgColor – Sets the cell's background color
• Format::setFontFamily – Sets the font family.
• Worksheet::setColumn – Set the width of a single column or a range of columns.

---

I'd definitely recommend PHPExcel as well, and it may well supercede the SEW within the PEAR repository