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