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 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.
Another option than those that have been presented here would be to use XML::SAXDriver::Excel. It is imho superior to using some of the modules that parse Excel directly because it is SAX based. That means that you have a lot more power in your hands, and that if your data source move to something else (eg CSV, database, etc...) you'll be able to use nearly the same code. Furthermore, SAX is a simple, flexible, well-thought out, and well-documented API. -- _______________________________________________________________________ Robin Berjon <[EMAIL PROTECTED]> -- CTO k n o w s c a p e : // venture knowledge agency www.knowscape.com ----------------------------------------------------------------------- Paranoids are people, too; they have their own problems. It's easy to criticize, but if everybody hated you, you'd be paranoid too.
