[ale] Semi OT

[Charles Shapiro]

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.