Page 1 of 1

Write data to Ms-Excel....?????????

Posted: Tue Aug 05, 2008 5:12 am
by panprasath
It is possible to write data to Ms-Excel using php....In my MySql table contain some details..like id,name,dbo,sex etc...From this table i will select required datas are selected and it will display in Ms_excel.....for print....how i do....Please help me.....

Re: Write data to Ms-Excel....?????????

Posted: Tue Aug 05, 2008 5:33 am
by Paul Arnold
Lookup exporting PHP output as a CSV file.

Re: Write data to Ms-Excel....?????????

Posted: Tue Aug 05, 2008 7:05 am
by panprasath
Thank you.....But It is possible to change the output font size..like bold.....

Re: Write data to Ms-Excel....?????????

Posted: Tue Aug 05, 2008 10:25 am
by Paul Arnold
Not in a CSV file no.
A CSV file is essentially just data separated by commas.
There might be a way to export as an XLS file but I haven't come across anything.

Re: Write data to Ms-Excel....?????????

Posted: Wed Aug 06, 2008 3:50 am
by panprasath
Thank you....

Re: Write data to Ms-Excel in native format

Posted: Fri Jan 02, 2009 9:16 am
by itp
...similar question. I use fputcsv() to create csv, but some users are having trouble with field seperators and want true .xls-Excel type files.
All I need is code that reads an array & creates an .xls or reads the csv and creates .xls. No formatting required (for now anyway). Can anyone point me in the right direction.

Re: Write data to Ms-Excel....?????????

Posted: Sun Jan 04, 2009 12:57 pm
by Mark Baker
A simple google search on "PHP" and "Excel" would have identified a number of options, including PHPExcel