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

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
panprasath
Forum Newbie
Posts: 19
Joined: Thu Jul 24, 2008 3:35 am
Location: Chennai,Tamilnadu,India

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

Post 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.....
Paul Arnold
Forum Contributor
Posts: 141
Joined: Fri Jun 13, 2008 10:09 am
Location: Newcastle Upon Tyne

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

Post by Paul Arnold »

Lookup exporting PHP output as a CSV file.
panprasath
Forum Newbie
Posts: 19
Joined: Thu Jul 24, 2008 3:35 am
Location: Chennai,Tamilnadu,India

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

Post by panprasath »

Thank you.....But It is possible to change the output font size..like bold.....
Paul Arnold
Forum Contributor
Posts: 141
Joined: Fri Jun 13, 2008 10:09 am
Location: Newcastle Upon Tyne

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

Post 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.
panprasath
Forum Newbie
Posts: 19
Joined: Thu Jul 24, 2008 3:35 am
Location: Chennai,Tamilnadu,India

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

Post by panprasath »

Thank you....
itp
Forum Commoner
Posts: 67
Joined: Fri Jun 15, 2007 6:50 am

Re: Write data to Ms-Excel in native format

Post 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.
Mark Baker
Forum Regular
Posts: 710
Joined: Thu Oct 30, 2008 6:24 pm

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

Post by Mark Baker »

A simple google search on "PHP" and "Excel" would have identified a number of options, including PHPExcel
Post Reply