Hi everybody! I'm looking at some point in the not-too-distant future into slightly redoing the way I configure my spreadsheet so that I can use a Perl module for getting the data I want from it. Basically, all I'm looking for at this point is a module where I can set up a foreach loop, have it extract each cell from a given column, set this as a hash key, and then have the value (or the list in an HoL) be the value from another cell (or group of cells). I've got access to both MS-Works (version 4.0) and Microsoft Excel. The one module I came across on CPAN was Spreadsheet::ParseExcel, but the documentation seemed exceedingly skimpy (sadly, most of the documentation I've seen for modules is this way -- I can't figure out how to do anything with CGI.pm, but that's another story). Spreadsheet::ParseExcel mentioned something about using OLE::Storage, but when I looked that up, the documentation was just as much hieroglyphics as for Spreadsheet::ParseExcel. Does anybody have any suggestions as to which module might be best for me and where there's any sort of tutorial (sample scripts and the like) on how to use the modules? Thanks in advance! Ted Schuerzinger Visit my web-site at <http://tedstennis.tripod.com/index.html>! Ted S. [EMAIL PROTECTED] My cat likes to sit on my lap while I'm at the computer. If only I could get her to hack Perl code for me. _______________________________________________ Perl-Win32-Users mailing list [EMAIL PROTECTED] http://listserv.ActiveState.com/mailman/listinfo/perl-win32-users
