Re: Perl and Microsoft Excel?

2001-12-01 Thread J. Zobel
On Thu, 2001-11-29 at 23:37, Tom Servo wrote: There's probably a far better answer to this than I can give, but if not, an interim solution might be having whoever maintains these Excel files save them as .csv files. Excel can do that, and while you lose all the fancy formatting, it just

Re: Perl and Microsoft Excel?

2001-11-30 Thread Hans Poo
El Jue 29 Nov 2001 19:31, Ian escribió: Mensaje firmado por ID de clave desconocido 962F87CA In the wide and wonderful world of Microsoft and Linux, I'm in the need of an interesting soloution. I'm presenting this to the list because I've ran out of good ideas. I recommend making a mod_perl

Perl and Microsoft Excel?

2001-11-29 Thread Ian
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 In the wide and wonderful world of Microsoft and Linux, I'm in the need of an interesting soloution. I'm presenting this to the list because I've ran out of good ideas. The campus phone system has a 911 database that is in Microsoft Excel format,

Re: Perl and Microsoft Excel?

2001-11-29 Thread Tom Servo
There's probably a far better answer to this than I can give, but if not, an interim solution might be having whoever maintains these Excel files save them as .csv files. Excel can do that, and while you lose all the fancy formatting, it just dumps them in a comma seperated list, then you can

Re: [OT] Perl and Microsoft Excel?

2001-11-29 Thread Ken Y. Clark
On Thu, 29 Nov 2001, Tom Servo wrote: Date: Thu, 29 Nov 2001 14:37:34 -0800 (PST) From: Tom Servo [EMAIL PROTECTED] To: Ian [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Perl and Microsoft Excel? There's probably a far better answer to this than I can give, but if not, an interim

Re: Perl and Microsoft Excel?

2001-11-29 Thread John Whitnack
Ian, I have never used it, but I have heard that Spreadsheet::ParseExcel is good at getting Excel file into a Perl script. If you every need to go the other way (Perl-Excel) i have used (and highly recommend) Spreadsheet::WriteExcel. Both of these can be found on CPAN. Ian wrote: The campus

Re: Perl and Microsoft Excel?

2001-11-29 Thread Mark Fowler
On Thu, 29 Nov 2001, Tom Servo wrote: Hopefully someone else knows of a CPAN module to work with Excel files, though... Spreadsheet::ParseExcel and Spreadsheet::WriteExcel? Both have ::Simple versions too. I've used them in the past and it's Worked For Me (tm) Later. Mark. -- s'' Mark

RE: Perl and Microsoft Excel?

2001-11-29 Thread Charles Day
every (schedule). Then you can query your db any way you like from your website, and they can have their nice little xls file too:) Charles -Original Message- From: Ian [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 5:31 PM To: [EMAIL PROTECTED] Subject: Perl and Microsoft

OT: Re: Perl and Microsoft Excel?

2001-11-29 Thread ___cliff rayman___
fyi - this is off topic since it does not have anything to do with mod_perl in particular. you should really ask on: news://comp.lang.perl.modules or one of the other newsgroups: news://comp.lang.perl.moderated news://comp.lang.perl.misc or on this helpful website: http://www.perlmonks.org/

Re: Perl and Microsoft Excel?

2001-11-29 Thread David Kaufman
Tom Servo [EMAIL PROTECTED] wrote: On Thu, 29 Nov 2001, Ian wrote: The campus phone system has a 911 database that is in Microsoft Excel format, and they want to be able to take that information, and show it on a webpage, either via a search form, or in one big table. The problem is,

Re: Perl and Microsoft Excel?

2001-11-29 Thread Robin Berjon
On Thursday 29 November 2001 23:31, Ian wrote: In the wide and wonderful world of Microsoft and Linux, I'm in the need of an interesting soloution. The campus phone system has a 911 database that is in Microsoft Excel format, and they want to be able to take that information, and show it on

Re: Perl and Microsoft Excel?

2001-11-29 Thread Medi Montaseri
Two suggestions: One: drop the excel idea right now or you'll find out its not the right solution at a later time. Use LDAP instead. Then right a CGI (as you really don't need Mod-Perl) for all kinds of queries and an admin view for a maintainer to maintain it. Two: ask your spreadsheet