title: How to access an .xlsb file by php?
body: <p>I need to access an .xlsb file that does the same function as this code that accesses a .csv file:<br></p>
  
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>&lt;?php
  $file1 = __DIR__ . '/download/Trabalhos.csv';
  $csv1 = file($file1);
  foreach ($csv1 as $row1 =&gt; $line1) {
      $row1++;
      $column1 = str_getcsv($line1, ';');
      if ($row1 == 2) {
          $column1[6]."&lt;br&gt;";
          $valor1 = $column1[6];
      }
  }
  
  $file2 = __DIR__ . '/download/produtividade do trabalho.csv';
  $csv2 = file($file2);
  foreach ($csv2 as $row2 =&gt; $line2) {
      $row2++;
      $column2 = str_getcsv($line2, ';');
      if ($row2 == 3) {
          $column2[9]."&lt;br&gt;";
          $valor2 = $column2[9];
      }
  }
  $file3 = __DIR__ . '/download/inatividade do trabalho.csv';
  $csv3 = file($file3);
  foreach ($csv3 as $row3 =&gt; $line3) {
      $row3++;
      $column3 = str_getcsv($line3, ';');
      if ($row3 == 2) {
          $column3[0]."&lt;br&gt;";
          $valor3 = $column3[0];
      }
  }
  
  $total = $valor1 * $valor2 * $valor3;
  
  ?&gt;</code></pre>
  </div>
  </div>
  </p>
  
  <p>Access the .xlsb file, scroll through the columns and rows, and display the row value on the screen.</p>
  
  <p><strong>Example:</strong> "Line 2, Column G(In this case, G = 6)<br>
  "A = 0<br>
  B = 1<br>
  C = 2)"<br>
  ...<br></p>
  
  <p>I want it to show me the value of row 2 that is in column G(6).</p>
  
  <p>As in the first if ...</p>
  
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>if ($row1 == 2) {
          $column1[6]."&lt;br&gt;";
          $valor1 = $column1[6];
      }</code></pre>
  </div>
  </div>
  </p>