[ale] Semi OT

[Jim Philips]

If you can connect to the database by ODBC, you could probably get an import 
down to one click. Using macros is nasty. Something inevitably changes and 
people fail to follow up. I would build the spread sheet to just 
automatically reflect what is in the database.

On Monday 15 April 2002 07:08 pm, Robert L. Harris wrote:
> 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.