PHP+Excel

Anon

Is there any package available to generate excel spread sheets from a PHP program, i,e similar to pdflib wherein you can generate pdf files.

"And my PHP is running on Linux"..

i want generate some reports in excel format ... and send it by mail as an attchement ... or download them to client windows machine ...

Thanks,
Danny ...

Visit: http://www.danz.itgo.com

ame12

Hmmm... I'm doubtful you can do this on anything but a Windows box. Two general ways to do it (both require Win32 platforms). Easiest way is via OLE automation (i.e., COM) on a box that runs Excel. Harder way is to use the Office developer's kit which allows (at least it used to) you to create Excel files from scratch.

The small footprint BadBlue Win32 PHP server supports Excel integration (it allows HTML transcoding and updating of Excel spreadsheets using HTTP requests - which may plug into what you're trying to do). You might use it as a slave box to your main Linux machine accessible via HTTP. Overview here: http://badblue.com/helpxls.htm

Dave

Anon

You may send the data as a flat file separinting the columns by tabs.
Save the file as XLS and, when you open by the first time,choose convert.

It´s not the best way if you are dealing with many people reciving the file, 'cause they have to know they have to follow the convert boxes, but It works fine for me.

hope it helps

spider_man

Dave (the reply) was talking about creating a COM object, wich , yes, it can only be done on a M$ enviroment.
If you just want to generate it on the client or make him download the file, just throw out the headers shown below and output the table row by row separating the fields with tabs and the lines with newlines.

header("Content-type: application/ms-excel; name=file1.csv");
header("Content-Disposition: inline; filename=file1.csv");

echo "a1\tb1\t\na2\tb2\t\n";

dhopp

There is a PERL module "Spreadsheet::WriteExcel" available at CPAN:

http://search.cpan.org/doc/JMCNAMARA/Spreadsheet-WriteExcel-0.32/WriteExcel.pm

Perhaps somebody ported this to PHP or wrote a wrapper?

Daniel

utewes

look at this
http://www.zend.com/codex.php?id=542&single=1

dhopp

look at this
http://www.zend.com/codex.php?id=542&single=1

Nice, but provided functions here do not exceed csv structure.
The CPAN library contains methods for sheets, cell formatting
or even setting paper size.
I badly needed something like that times ago and had to write
a lot of VB @!#$ for some auction platforms..

sincerely,

Anon

Checkout this, you can make it using HTML, just change Mime Type to "application/vnd.ms-excel"
http://www.15seconds.com/Issue/970515.htm