Create Excel file on Web Server

Richard Korts
Richard Korts used Ask the Experts™
on
I have a MySQL database. I need to create a "report" in Excel format using php on the web server so it can be emailed to the customer. I know how to do it in csv but I need to incorporate things like cell font formatting, colors, etc.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Developer & EE Moderator
Fellow 2018
Most Valuable Expert 2013
Commented:

Commented:
Spreadsheet Excel Writer @http://pear.php.net/package/Spreadsheet_Excel_Writer is a good choice for creating excel file with only needs of formatting.

I used it years ago and pretty satisfied.
Richard KortsBusiness Owner / Chief Developer

Author

Commented:
To padas

You might be interested in looking at this:

http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/Q_27432560.html

Thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial