title: PHPExcel - Get cell value from another sheet
body: <p>I've been debugging for hours, and cannot seem to figure out the problem.</p>
  
  <pre><code>    $objReader = PHPExcel_IOFactory::createReader($inputFileType);
      $objPHPExcelReader = $objReader-&gt;load($inputFileName);
  
      $objPHPExcelReader-&gt;setActiveSheetIndex(1);
  
      $sheetName = $objPHPExcelReader-&gt;getActiveSheet()-&gt;getTitle();
  
      echo "&lt;strong&gt;UPLOAD SUCCESSFUL!&lt;/strong&gt;&lt;br /&gt;&lt;br /&gt;";
      echo "Excel Path: $target_path&lt;br /&gt;&lt;br /&gt;";
      echo "$sheetName &lt;br /&gt;&lt;br /&gt;";
  
      $ytd_actual = $objPHPExcelReader-&gt;getSheet(1)-&gt;getCell('Z11')-&gt;getValue();
      $ytd_budget = $objPHPExcelReader-&gt;getActiveSheet()-&gt;getCell('AX11')-&gt;getValue();
  </code></pre>
  
  <p>Both values come back empty, notice I tried both methods</p>
  
  <p>getSheet(1) -> to set a specific sheet</p>
  
  <p>getActiveSheet() -> to use the active sheet (which I set in the beginning)</p>
  
  <p>The sheetname outputs correctly, so I know the right sheet is selected.</p>
  
  <p>Here is the funny part! If I use just the activesheet, without specifying setActiveSheet it works no problem to pull the data from the 1st sheet. Moment I set it to the 2nd sheet, it gives me issues.</p>
  
  <p>If I even try and change</p>
  
  <pre><code> $ytd_actual = $objPHPExcelReader-&gt;getSheet(1)-&gt;getCell('Z11')-&gt;getValue();
  </code></pre>
  
  <p>to...</p>
  
  <pre><code> $ytd_actual = $objPHPExcelReader-&gt;getSheet(0)-&gt;getCell('Z11')-&gt;getValue();
  </code></pre>
  
  <p>It'll give me the value from the 1st sheet without issue. 2nd sheet, nothing...</p>
  
  <p>What am I doing wrong? (rest assured the cell mapping is correct, there is values)</p>