Export data from php[mysql db] to Excel in particular cell.

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
thenndral
Forum Newbie
Posts: 20
Joined: Wed Sep 29, 2010 8:36 pm

Export data from php[mysql db] to Excel in particular cell.

Post by thenndral »

Hello,

I want to export data from php-mysql to excel in a particular cell.

1. Get the data from php-Mysql and export data to excel sheet. I already create a template excel sheet format.I want to export data from mysql to a particular cell. Sorry I can't able to attach my template excel sheet.
2. Is it possible to export image?


Thanks in advance,
thenndral
User avatar
Jade
Forum Regular
Posts: 908
Joined: Sun Dec 29, 2002 5:40 pm
Location: VA

Re: Export data from php[mysql db] to Excel in particular ce

Post by Jade »

Are you using a code library like Pear's Excel Writer (http://pear.php.net/package/Spreadsheet_Excel_Writer)?
thenndral
Forum Newbie
Posts: 20
Joined: Wed Sep 29, 2010 8:36 pm

Re: Export data from php[mysql db] to Excel in particular ce

Post by thenndral »

Hi Jade,

I'm not aware of pear.php.
when I google, got some link about PHPExcel..
link : http://phpexcel.codeplex.com/

but, It's not useful for me...highly complicated for me as a newbie.
Is there any other way, please let me know about it. or give me some code help.
It's very useful to startup.

Thanks in advance,
thenndral.
thenndral
Forum Newbie
Posts: 20
Joined: Wed Sep 29, 2010 8:36 pm

Re: Export data from php[mysql db] to Excel in particular ce

Post by thenndral »

Hi...

It's an urgent task...
please guide me...how to export data to excel in particular cell.

thanks in advance,
thenndral
Post Reply