Outputing Data to Excel in PHP | First Page | Forum

Gaia Forums » Entertainment » Computers & Technology

Report ad

Majah

(?)Community Member

Blessed Seeker

5,450 Points

Offline

Post: 5136421_1 created on Thu, 23 Dec 2004 10:39:55 +0000
Posted: Thu, 23 Dec 2004 10:39:55 +0000

Hi! I'm new to php and I kinda got stuck with outputing data from a database into an excel file as part of reporting. Anyone care to help?

I can do this in a breeze in ASP....but in php....nothing I do seems to work...

help.

grundal

(?)Community Member

Offline

Report Post
Post: 5136421_2 created on Thu, 23 Dec 2004 10:51:34 +0000
Posted: Thu, 23 Dec 2004 10:51:34 +0000

Majah

easy way to simplifi things ... instead of outputing directly to a excel file ... output to a CSV file ... excel can import it as well as many other programs

Majah

(?)Community Member

Blessed Seeker

5,450 Points

Offline

Report Post
Post: 5136421_3 created on Fri, 24 Dec 2004 06:30:48 +0000
Posted: Fri, 24 Dec 2004 06:30:48 +0000

Quote:

Majah

easy way to simplifi things ... instead of outputing directly to a excel file ... output to a CSV file ... excel can import it as well as many other programs

How do I output it in a CSV file? Care to share code snippets? or point me somewhere which explains how?

I tried outputing in a CSV file...but it goes out in the browser and not in the file.

grundal

(?)Community Member

Offline

Report Post
Post: 5136421_4 created on Fri, 24 Dec 2004 15:12:21 +0000
Posted: Fri, 24 Dec 2004 15:12:21 +0000

Quote:

Majah

easy way to simplifi things ... instead of outputing directly to a excel file ... output to a CSV file ... excel can import it as well as many other programs

How do I output it in a CSV file? Care to share code snippets? or point me somewhere which explains how?

I tried outputing in a CSV file...but it goes out in the browser and not in the file.

put this before an thing is outputed

header("Content-type: application/csv" wink ;

http://filext.com/detaillist.php?extdetail=CSV

you can also change any of thease mimetypes

Majah

(?)Community Member

Blessed Seeker

5,450 Points

Offline

Report Post
Post: 5136421_5 created on Mon, 27 Dec 2004 00:46:44 +0000
Posted: Mon, 27 Dec 2004 00:46:44 +0000

Thanks...I will try this later *kisses u* 4laugh

-----

And oh...If anyone got some more tips...I will be very happy to listen.

grundal

(?)Community Member

Offline

Report Post
Post: 5136421_6 created on Mon, 27 Dec 2004 04:14:00 +0000
Posted: Mon, 27 Dec 2004 04:14:00 +0000

Quote:

Thanks...I will try this later *kisses u* 4laugh

-----

And oh...If anyone got some more tips...I will be very happy to listen.

forgot to mention you might want this also

header('Content-Disposition: attachment; filename="downloaded.cvs"');

SpazLink

(?)Community Member

Offline

Report Post
Post: 5136421_7 created on Mon, 27 Dec 2004 04:15:19 +0000
Posted: Mon, 27 Dec 2004 04:15:19 +0000

I've seen an Excel file reader for PHP, but I can't remember if it also supported making them...

grundal

(?)Community Member

Offline

Report Post
Post: 5136421_8 created on Mon, 27 Dec 2004 04:50:01 +0000
Posted: Mon, 27 Dec 2004 04:50:01 +0000

Quote:

I've seen an Excel file reader for PHP, but I can't remember if it also supported making them...

I know phpmyadmin has one built in and someone could always look through there code ... and I know it's possable and probley easy ... but I sugested the CSV because it would be easyer to transfer to other programs besides excel if such a need should ever arise

always good to program sevral steps ahead

edit http://php.resourceindex.com/detail/02384.html
I think this is the one your talking about which doesn't do output only input

however I did find something in PEAR
http://pear.php.net/package-info.php?pacid=156