Page 1 of 1

good tuturial to work with EXCEL files ?

Posted: Fri Jan 13, 2006 12:04 pm
by duk
i need to create dinamic excel files... anyones know of a good tuturial... ?? i had look in google but can't find good stuff...

Posted: Fri Jan 13, 2006 3:42 pm
by feyd
Have you searched the forums? Excel has been talked about a lot.

Must it be Excel? Why not Comma Separated Values, or Tab Delimited?

Posted: Fri Jan 13, 2006 3:48 pm
by BDKR
I normally don't use PEAR, but there is a PEAR class for Excel. I used it to generate Excel documents that were emailed to people that needed to see those reports.

Posted: Fri Jan 13, 2006 4:05 pm
by raghavan20
CSV would be the best solution I think.
For automated reading of CSV files, you can write your own PHP script, should not be so hard.
For non-automated reading, you can use phpmyadmin to upload CSV files.

Posted: Fri Jan 13, 2006 4:17 pm
by duk
i will take a look in this forum...

but what i want to do is creating excel files with data from Mysql... but i need to create a pretty excel file with table and image's etc...

i dont understand why you guys are talking about comma separated values, and CVS...

Posted: Fri Jan 13, 2006 4:30 pm
by BDKR
duk wrote: but what i want to do is creating excel files with data from Mysql... but i need to create a pretty excel file with table and image's etc...

i dont understand why you guys are talking about comma separated values, and CVS...
I wasn't! And here you go....

http://pear.php.net/package/Spreadsheet_Excel_Writer

The thing you are talking about above is exactly thing I did (sans the images) for automated report generation here where I work now.

Cheers

Posted: Fri Jan 13, 2006 5:15 pm
by duk
thanks m8 :)

Posted: Sat Jan 14, 2006 10:22 pm
by wtf