exporting to an excel file

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ndedhia1
    New Member
    • Jan 2009
    • 112

    #1

    exporting to an excel file

    hello,
    I am creating a comma delimited text file in php and need to export the results to an excel file.
    I am creating the text file thru querying a mySql database.
    Right now, we have the .txt file exporting into a .html file but we would like it to also export to an excel file.
    Can this be done and can someone please help me.

    thank you
  • Atli
    Recognized Expert Expert
    • Nov 2006
    • 5062

    #2
    Hi.

    If your PHP code is being executed on a Windows server, you could use COM to use Excel from within PHP.

    I not, your best bet would probably be to create a CSV file or a XML file.
    Excel can read both formats, and they are infinitely easier to use in PHP than M$s proprietary XSL format.

    Comment

    Working...