How to formatting Excel Sheet cells using PHP

Question

Hi all,

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

Answer 1

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.

Answer 2

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

Answer 3

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