title: PhpOffice\PhpSpreadsheet how to make row visible during generation
body: <p>I create new rows in excel using the insertNewRowBefore method, then I set their size, forbid folding and make them clearly visible through as a result, only the address specified in the line inside the template is displayed at startup, the rest are displayed only when you click on them</p>
  <p>Code:</p>
  <pre><code>    $rowNumber = 18;
      $sheet-&gt;insertNewRowBefore($rowNumber+1, $fp-&gt;count());
      foreach($fp as $index=&gt; $point) {
          $sheet-&gt;mergeCells(&quot;C{$rowNumber}:K{$rowNumber}&quot;)-&gt;getRowDimension($rowNumber)-&gt;setRowHeight(50)-&gt;setCollapsed(false)-&gt;setVisible(true);
          $sheet-&gt;setCellValue(&quot;C{$rowNumber}&quot;, $point-&gt;company . ' ' . $point-&gt;address);
          $rowNumber++;
      }
  </code></pre>