Forgive me if I misunderstood your plea but, isn't Win32::OLE good enough?
I use _all_the_time_, for tasks such as the one you describe.
The company I work for, receives data in various spreadsheets (Lotus 123, MS
Excel) and, various scripts using this module, extracts the data and posts
them to a SQL server, without a problem.
-----Original Message-----
From: Ted S. [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 23, 2001 10:00 PM
To: [EMAIL PROTECTED]
Subject: Module for getting data from MS spreadsheet
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
_______________________________________________
Perl-Win32-Users mailing list
[EMAIL PROTECTED]
http://listserv.ActiveState.com/mailman/listinfo/perl-win32-users
