Mysql to excel

Discussion in 'PHP' started by weknowtheworld, Jan 5, 2007.

0
  1. #1
    Hi,

    anyone out there with script to convert mysql data to excel sheet in php?

    Thanks... :)
     
    weknowtheworld, Jan 5, 2007 IP
  2. wmtips

    wmtips Well-Known Member

    Messages:
    601
    Likes Received:
    70
    Best Answers:
    1
    Trophy Points:
    150
    #2
    Excel can read CSV files, so if you need it you can generate them with PHP.

    If you need to send some mysql data to Excel, you can check out the PhpMyAdmin, there is the ability to export database data in the "CSV for MS Excel" format.
     
    wmtips, Jan 5, 2007 IP
  3. TwistMyArm

    TwistMyArm Peon

    Messages:
    931
    Likes Received:
    44
    Best Answers:
    0
    Trophy Points:
    0
    #3
    There are also a number of Excel classes in the PEAR collection... I'm not sure how much work they are, but they're an option.
     
    TwistMyArm, Jan 5, 2007 IP