Write data to Ms-Excel....?????????
Moderator: General Moderators
-
panprasath
- Forum Newbie
- Posts: 19
- Joined: Thu Jul 24, 2008 3:35 am
- Location: Chennai,Tamilnadu,India
Write data to Ms-Excel....?????????
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....?????????
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....?????????
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....?????????
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.
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....?????????
Thank you....
Re: Write data to Ms-Excel in native format
...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.
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....?????????
A simple google search on "PHP" and "Excel" would have identified a number of options, including PHPExcel