如何使用PHP格式化Excel工作表单元格

Please help me about my doubts 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