DaniWeb Forum Index > Web Development > PHP

How to php export to excel

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Mar 2008

Posts: 15

Reputation: csshacker is an unknown quantity at this point

Solved Threads: 1

csshacker

Offline

Newbie Poster

How to php export to excel

May 15th, 2008

How to php export to excel

•

Join Date: Dec 2007

Posts: 252

Reputation: ProfessorPC is an unknown quantity at this point

Solved Threads: 27

ProfessorPC ProfessorPC is offline

Offline

Posting Whiz in Training

Re: How to php export to excel

May 15th, 2008

good example here http://www.appservnetwork.com/module...=article&sid=8

•

Join Date: Nov 2007

Posts: 3,761

Reputation: nav33n is a jewel in the rough

Solved Threads: 332

nav33n

Offline

Senior Poster

Re: How to php export to excel

May 15th, 2008

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<?php
$filename ="excelreport.xls";
$contents = "testdata1 \t testdata2 \t testdata3 \t \n";
header('Content-type: application/ms-excel');
header('Content-Disposition: attachment; filename='.$filename);
echo $contents;
 ?>
<?php
$filename ="excelreport.xls";
$contents = "testdata1 \t testdata2 \t testdata3 \t \n";
header('Content-type: application/ms-excel');
header('Content-Disposition: attachment; filename='.$filename);
echo $contents;
 ?>

This is the simplest way to generate an excel report.

Ignorance is definitely not bliss!

*PM asking for help will be ignored*

•

Join Date: Aug 2007

Posts: 4

Reputation: jana36 is an unknown quantity at this point

Solved Threads: 1

jana36

Offline

Newbie Poster

Re: How to php export to excel

May 16th, 2008

hi, i am janardhan..
i want some more coding details about export to excell sheet.. suppose i am retriving data from database and storing the values in a table. i want to export in an excell sheet with proper header ..how can i develop this.?

•

Join Date: Nov 2007

Posts: 3,761

Reputation: nav33n is a jewel in the rough

Solved Threads: 332

nav33n

Offline

Senior Poster

Re: How to php export to excel

May 16th, 2008

Replace testdata in the above example with the database values.

Ignorance is definitely not bliss!

*PM asking for help will be ignored*

•

Join Date: Jul 2009

Posts: 1

Reputation: amakrid is an unknown quantity at this point

Solved Threads: 0

amakrid

Offline

Newbie Poster

Re: How to php export to excel

Jul 1st, 2009

Can I change the color of contents ?
e.g testdata1 ---> blue
testdata2 ---> red
etc ...

Thanks!

•

Join Date: Dec 2009

Posts: 1

Reputation: timmuin is an unknown quantity at this point

Solved Threads: 0

timmuin

Offline

Newbie Poster

need help

19 Days Ago

•

Originally Posted by nav33n

Help with Code Tags

php Syntax (Toggle Plain Text)
<?php
$filename ="excelreport.xls";
$contents = "testdata1 \t testdata2 \t testdata3 \t \n";
header('Content-type: application/ms-excel');
header('Content-Disposition: attachment; filename='.$filename);
echo $contents;
 ?>
<?php $filename ="excelreport.xls"; $contents = "testdata1 \t testdata2 \t testdata3 \t \n"; header('Content-type: application/ms-excel'); header('Content-Disposition: attachment; filename='.$filename); echo $contents; ?>
This is the simplest way to generate an excel report.

Hi,
Let me confess, I am ZERO in php.
I purchased one cd which has php files embedded with html page then scrolling pages in php formate withen windows of html .
Main data in in php file .
How to get this data in office document formate ( either MS Word or MS Excel)? Can some one help me in doing so....I am fed up.