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 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 split on commas to get the values out of it. > > Hopefully someone else knows of a CPAN module to work with Excel files, > though... > > ------------ > Brian Nilsen > [EMAIL PROTECTED]
Here's a sampling: http://theoryx5.uwinnipeg.ca/mod_perl/cpan-search?search=excel&new=Search&filetype=+distribution+name+or+description&join=and&arrange=file&download=auto&stem=no&case=clike&site=ftp.funet.fi&age= ky > > On Thu, 29 Nov 2001, Ian wrote: > > > > > -----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, 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, they want to do it dynamically...the web server needs to > > yank it down from a samba share (or ftp), parse it, show it, and > > terminate. > > > > I'm really **really** new at anything perl wise...so I haven't the > > foggiest clue as to where I should start. > > > > I've finally gotten Apache/Mod Perl/Mod SSL installed, and working > > properly. Are there any modules for pulling information from an > > excel sheet? How about modules that keep the overworked admin from > > insanity? > > > > Ian > > > > > > - ---- > > - From RFC 1925: "(3) With sufficient thrust, pigs fly just fine. > > However, this is not necessarily a good idea. It is hard to be sure > > where they are going to land, and it could be dangerous sitting under > > them as they fly overhead." > > > > > > -----BEGIN PGP SIGNATURE----- > > Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com> > > > > iQA/AwUBPAa3NHRiiq+WL4fKEQKsRACgutpROPjPllax3Nvfat2R7YERlSQAn35Q > > 0vwYEFLgdzsz4Dfu98dUJzBy > > =Qs9B > > -----END PGP SIGNATURE----- > > > >
