Help for this page

Select Code to Download


  1. or download this
    $oBook = Spreadsheet::ParseExcel::Workbook->Parse("$strExcelPath");
      foreach my $oWkS (@{$oBook->{Worksheet}}) {
    ...
                                defined $oWkS->{MaxCol} && $iC <= $oWkS->{
    +MaxCol} ; $iC++) {
                    $oWkC = $oWkS->{Cells}[$iR][$iC];
                    print "( $iR , $iC ) =>", $oWkC->Value, "\n" if($oWkC)
    +;
    
  2. or download this
    $oFormat = $oWkC->Format;
    
  3. or download this
    $oFill = $oFormat->Fill;