Solved

Create Excel file on Web Server

Posted on 2011-09-05
4
179 Views
Last Modified: 2012-05-12
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.
0
Comment
Question by:Richard Korts
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 53

Accepted Solution

by:
Scott Fell,  EE MVE earned 500 total points
ID: 36486228
0
 
LVL 36

Expert Comment

by:Loganathan Natarajan
ID: 36486347
Try this "PHP Excel Reader"
 
0
 
LVL 13

Expert Comment

by:dsmile
ID: 36487791
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.
0
 

Author Comment

by:Richard Korts
ID: 37086502
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
0

Featured Post

Webinar: MongoDB® Index Types

Join Percona’s Senior Technical Services Engineer, Adamo Tonete as he presents “MongoDB Index Types, How, When and Where Should They be Used?” on Wednesday, July 12, 2017 at 11:00 am PDT / 2:00 pm EDT (UTC-7).

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question