Create excel (.xls) files from PHP data

Friends,

I need your help. I need to create an excel (.xls) file form php page.

Suppose,
I have some string data in a php variable-

$mydata = "My text here 01<br>My text here 02<br>My text here 03";

PHP:

I wanto to create a link or button that prompt me to download that file.

The downloadable file: An excel file just with those three line printed in three rows.

PLEASE HELP ME
Thanks in advance

 

Try using PEAR Package for doing the same. Package SpreadSheet can be used to create excel sheets.

 

This will help you

http://afruj.wordpress.com/2008/05/08/save-report-as-excel-file-from-php/

 

Exactly, PEAR's Spreadsheet_Excel_Writer works great:

http://pear.php.net/package/Spreadsheet_Excel_Writer/