https://community.hpe.com/t5/operating-system-linux/generate-excel/m-p/3856372#M98190 Hi<BR />I am in basic level of PHP<BR /><BR />I need generate a excel file each time fetching data from database.The excel file should contain 2 worksheets each contains contents of 1 tav\ble from database(mysql).The fields of the table should be the column headings in excel sheet and corresponding data's(records) under it.This file should be downloaded in a path each time the script is executed. Tue, 05 Sep 2006 01:22:56 GMT Sasirekha 2006-09-05T01:22:56Z https://community.hpe.com/t5/operating-system-linux/generate-excel/m-p/3856372#M98190 Hi<BR />I am in basic level of PHP<BR /><BR />I need generate a excel file each time fetching data from database.The excel file should contain 2 worksheets each contains contents of 1 tav\ble from database(mysql).The fields of the table should be the column headings in excel sheet and corresponding data's(records) under it.This file should be downloaded in a path each time the script is executed. Tue, 05 Sep 2006 01:22:56 GMT https://community.hpe.com/t5/operating-system-linux/generate-excel/m-p/3856372#M98190 Sasirekha 2006-09-05T01:22:56Z https://community.hpe.com/t5/operating-system-linux/generate-excel/m-p/3856373#M98191 Hi,<BR />can you please clarify what your output format is to be.<BR /><BR />CSV or MS Excel format ?<BR /><BR />You could source your data from within EXCEL with ODBC select.<BR />Or as a pseudeo code script:<BR />Set up Oracle environment<BR />connect to the DB<BR />run your query, spooling output to file<BR />disconnect from Oracle Tue, 05 Sep 2006 03:47:05 GMT https://community.hpe.com/t5/operating-system-linux/generate-excel/m-p/3856373#M98191 Peter Godron 2006-09-05T03:47:05Z