[ale] Semi OT

[Mike Lockhart]

You can always compromise by setting up a small cheapie windows 2k box
running php so you can access COM objects.  It's actually pretty easy to
make an excel sheet via php using COM objects.  Php.net has some good
documentation as does PHPBuilder on this subject.

-- mike lockhart
   [770.366.9194]

P.S: the windows box would be strictly for creating excel sheets, just setup
a secheduled task to run somthing like http://localhost/create_sheet.php
which makes the sheet them emails it to the appropriate parties.







-----Original Message-----
From: Josh Freeman [mailto:josh.freeman at arch.gatech.edu]
To: ale at ale.org
Sent: Tuesday, April 16, 2002 9:46 AM
Cc: Atlanta Linux Enthusiasts
Subject: Re: [ale] Semi OT


On Mon, 2002-04-15 at 19:08, Robert L. Harris wrote:

I've had some success in ColdFusion by redefining the content type of a
page to be type "application/vnd.ms-excel" and having the only output of
a page be the results of a query that will generate the spreadsheet you
want. This may work in PHP, but I do know you can make it work in
ColdFusion, and you can always download a demo of Coldfusion. After it
times out, it becomes a single connection Developer's edition.  Last
time I checked, they also had ColdFusion Express, which was stripped
down, but free. You'd probably want to check the licence to make sure
that this was allowed under the license, but it would work.

Other than that, I'll be happy to bang my head against the wall and come
up with another idea, as I have got to deal with this more and more, and
I am desperate to keep Windows out of my datacenter.


Josh

>
>
> I'm starting to work with on a project with a co-worker.  He's building
> a very nice system database in postgress with an php front end.  One
> problem just came up.  There are execs who've found out about it and
> want to be able to read the data in excel.  He knows how to extract the
> information from the database with PHP but needs to convert it to an
> excel spread sheet.
>
> Anyone know a php module or even a perl module that'll convert CSV or
> php data to an excel spread sheet?  Giving them CSV data and expecting
> them to import it is too much work we've been told.
>
> (It's semi off topic because it's Linix+php+postgress and the only other
> solutions he can find are windows based which we REALY don't want to
> do.)
>
>
> :wq!
> --------------------------------------------------------------------------
-
> Robert L. Harris                |  Micros~1 :
> Senior System Engineer          |    For when quality, reliability
>   at RnD Consulting             |      and security just aren't
>                                 \_       that important!
> DISCLAIMER:
>       These are MY OPINIONS ALONE.  I speak for no-one else.
> FYI:
>  perl -e 'print
$i=pack(c5,(41*2),sqrt(7056),(unpack(c,H)-2),oct(115),10);'
>
>
> ---
> This message has been sent through the ALE general discussion list.
> See http://www.ale.org/mailing-lists.shtml for more info. Problems should
be
> sent to listmaster at ale dot org.
>
>
--
Josh Freeman
Technical Manager
Center for Assistive Technology and Environmental Access


---
This message has been sent through the ALE general discussion list.
See http://www.ale.org/mailing-lists.shtml for more info. Problems should be
sent to listmaster at ale dot org.


---
This message has been sent through the ALE general discussion list.
See http://www.ale.org/mailing-lists.shtml for more info. Problems should be 
sent to listmaster at ale dot org.