How to format Excel worksheet cells using PHP

Question

Please help me about my doubts about excel and php. I need to do the following process to generate an excel report using php

• change cell font styles
• change cell cell color
• change cell width

Answer 1

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

Answer 2

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 background color of the cell
• Format::setFontFamily - Sets the font family.
• Worksheet::setColumn - set the width of a single column or range of columns.

Answer 3

I would also recommend PHPExcel, and it could very well replace SEW in the PEAR repository