0

Possible Duplicate:
Export from PHP to Excel

I need to export data retrieved from mysql database to excel. I need to do some changes to my data before exporting to excel. I really can't understand how I should begin.

Should i go for PEAR? or any other class library? or any simple way to do this?

Community
  • 1
  • 1
  • possible duplicate of [Export from PHP to Excel](http://stackoverflow.com/questions/4005814/export-from-php-to-excel) … and many other questions here on SO; see also: http://stackoverflow.com/questions/3930975/alternative-for-php-excel/ – feeela Aug 21 '12 at 16:53

2 Answers2

0

You can use phpexcel library. It allow you to write to and read from different spreadsheet file formats.

Community
  • 1
  • 1
Vinay
  • 2,564
  • 4
  • 26
  • 35
  • 1
    To enhance the answer please refer to this post, http://stackoverflow.com/questions/4005814/export-from-php-to-excel – Conrad Lotz Aug 21 '12 at 16:50
0

You may go through How to Generate a Complete Excel Spreadsheet From MySQL and Read and write Excel data with PHP.

Hope this helps.

Alfred
  • 21,058
  • 61
  • 167
  • 249