Help for this page

Select Code to Download


  1. or download this
     my $xl = Win32::OLE::Const->Load("Microsoft Excel");
        printf "Excel type library contains %d constants:\n", scalar keys 
    +%$xl;
    ...
                print "$Key = $xl->{$Key}\n";
            }
        }
    
  2. or download this
    Excel type library contains 2177 constants:
    xlCalculationAutomatic = -4105
    xlCalculationManual = -4135
    
  3. or download this
    use strict;
    use Win32::OLE;
    ...
    my $excel = Win32::OLE->CreateObject('Excel.Application') || die $!;
    $excel->{DisplayAlerts}=0;
    $excel->{Calculation}=-4135;