On Tue, 09 May 2000 14:29:33 -0700, Frank Merrow <[EMAIL PROTECTED]>
wrote:
>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.
Are you talking about Excel? I have no idea which large IDL file you are
talking about, but if you want to learn about the Excel object model, why
don't you look into the documentation. It is included in the Office
distribution, just not installed by default.
>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.
At my previous job, I've done *very* large jobs with Perl and Excel. Some
areas take a lot of experimentation (especially charts), but overall its a
very powerful way to output results.
>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.
You are not trying hard enough. There is a ton of information about
Office automation on MSDN. The Excel object model is here:
http://msdn.microsoft.com/library/officedev/off2000/xltocobjectmodelapplication.htm
Click on "show toc" to see where it is in the hierarchy.
-Jan
---
You are currently subscribed to perl-win32-users as: [[email protected]]
To unsubscribe, forward this message to
[EMAIL PROTECTED]
For non-automated Mailing List support, send email to
[EMAIL PROTECTED]
