Page 1 of 1

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

Posted: Wed Feb 23, 2011 10:15 pm
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

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

Posted: Thu Feb 24, 2011 2:05 pm
by Jade
Are you using a code library like Pear's Excel Writer (http://pear.php.net/package/Spreadsheet_Excel_Writer)?

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

Posted: Thu Feb 24, 2011 9:26 pm
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.

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

Posted: Sun Feb 27, 2011 7:18 pm
by thenndral
Hi...

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

thanks in advance,
thenndral