[ale] Semi OT
Charles Shapiro
charles.shapiro at nubridges.com
Tue Apr 16 08:47:37 EDT 2002
Uh gee if it were me I'd check CPAN and use the :Spreadsheet::WriteExcel
module, available at
http://homepage.eircom.net/~jmcnamara/perl/WriteExcel.html
"A cross-platform Perl module that can be used to write numbers and text
in the native Excel binary format . . ."
-- CHS
On Tue, 2002-04-16 at 09:45, Josh Freeman wrote:
> 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.
More information about the Ale
mailing list