Help for this page

Select Code to Download


  1. or download this
    my $Excel = Win32::OLE->GetActiveObject('Excel.Application') || Win32:
    +:OLE->new('Excel.Application', sub {$_[0]->Quit;});
    
    ...
    $Sheet->Activate();
    
    my $value = $Sheet->Range("SOMECELL")->{Value};
    
  2. or download this
    my $value = $Sheet->Range("SOMECELL")->Text();
    
  3. or download this
    if (ref($value)) {
      print $value->Type();
    }