[ale] Semi OT

[Jeff Hubbs]

Robert said that importing is too much for the PHBs to handle.  Fine.

I think you can solve the problem entirely from within Excel.  Can you 
create a macro to perform the import and give them a shortcut to launch 
Excel and auto-exec the macro?

Barring that, is it possible to invoke Kspread, Gnumeric, or StarOffice 
via command line and get it to do the conversion via macro?

- Jeff

Chris Fowler wrote:

> Just dump to comma delmited or tab delimited.  Then import into Excel.
> 
> -----Original Message-----
> From: The Wanderer [mailto:nomad at rdlg.net]On Behalf Of Robert L. Harris
> Sent: Monday, April 15, 2002 7:08 PM
> To: Atlanta Linux Enthusiasts
> Subject: [ale] Semi OT
> 
> 
> 
> 
> 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.
> 
> 
> 
> 
> ---
> 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.