in reply to Perl-Excel Guidelines
Here at perlmonks:
MSDN:
- Excel object model (you may need to poke around for your specific version of excel, but overall it hasn't evolved much that I've seen)
- OLE-Browser - installed with perl, look in the ActiveState menu (if you're running ActiveState perl)
- Open Excel, hit Alt-F11 to open VBA environment, then hit F2 to view the Object Browser
- The Excel VB help file has the object model in detail. This helpfile is not installed by default, so you may need to rerun setup.
VB | Perl | |
Properties: | Selection.Hidden = True | $xls->Selection->{Hidden} = 1; |
Methods: | Worksheets(1).Activate | $xls->Worksheets(1)->Activate; |
A couple of things about Win32::OLE you may find helpful:
- Win32::OLE->Option( Warn => 3 ); # or 2 or 4
- # load all excel constants (I may have the library name wrong) use Win32::OLE::Const 'Microsoft Excel';
- # make it a little easier to iterate over collections use Win32::OLE qw/IN WITH/;
Update: Closed the list tag, added missing tr.
|
---|
In Section
Seekers of Perl Wisdom