Thanks to the examples in Win32::OLE and the other OLE modules, I have made
some progress on working with Excel from Perl. So far only really simple
things. However, I have a fairly aggressive project I've been tasked to do.
In particular, discovering the actual (usable) interface with only a huge
IDL file to go by is very frustrating. Some things work. Some things
don't. Some things don't work like I'd think.
As a case in point, this little code snippet out of OLE.pm came as a surprised:
# print "XyzzyPerl"
$array = $sheet->Range("A8:C9")->{Value};
for (@$array) {
for (@$_) {
print defined($_) ? "$_|" : "<undef>|";
}
print "\n";
}
So the routine doesn't return an array . . . NnnnnOOOOO . . . it returns a
REFERENCE to an array.
Is there anyone who has done a reasonably large/aggressive interface to
Excel? I mean finding and changing Ranges, Sheets, Cells and the like.
I'm at a lost as to how to turn a huge IDL file into a working Perl
program. At this point, the search and discovery process is just VERY VERY
VERY painful.
I've searched my MSDN . . . but nothing really defines these routines and
how they relate in any meaningful way.
Any ideas how to proceed?
Does anyone know of a VB book that discusses this interface in detail, such
that I could jump to Perl without so much pain?
Frank
---
You are currently subscribed to perl-win32-users as: [archive@jab.org]
To unsubscribe, forward this message to
[EMAIL PROTECTED]
For non-automated Mailing List support, send email to
[EMAIL PROTECTED]
