good tuturial to work with EXCEL files ?

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
duk
Forum Contributor
Posts: 199
Joined: Wed May 19, 2004 8:45 am
Location: London

good tuturial to work with EXCEL files ?

Post 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...
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post 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?
User avatar
BDKR
DevNet Resident
Posts: 1207
Joined: Sat Jun 08, 2002 1:24 pm
Location: Florida
Contact:

Post 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.
User avatar
raghavan20
DevNet Resident
Posts: 1451
Joined: Sat Jun 11, 2005 6:57 am
Location: London, UK
Contact:

Post 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.
duk
Forum Contributor
Posts: 199
Joined: Wed May 19, 2004 8:45 am
Location: London

Post 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...
User avatar
BDKR
DevNet Resident
Posts: 1207
Joined: Sat Jun 08, 2002 1:24 pm
Location: Florida
Contact:

Post 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
duk
Forum Contributor
Posts: 199
Joined: Wed May 19, 2004 8:45 am
Location: London

Post by duk »

thanks m8 :)
User avatar
wtf
Forum Contributor
Posts: 331
Joined: Thu Nov 03, 2005 5:27 pm

Post by wtf »

Post Reply