If you couldn't convince the bosses to db this, you could use .cvs (tab delimited) instead of .xls, ftp it to your webserver every (cron) and have perl parse it out. People love their xls and access files don't they:) How about dumping the data into MS-SQL and have your db write the .xls file 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 Excel? Sensitivity: Private -----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-----
