1

I am trying to hide some specific columns on a local Excel Sheet, but it does not hide, the code I am using is:

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\IOFactory;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

$spreadsheet = \PhpOffice\PhpSpreadsheet\IOFactory::load($filePath);
$spreadsheet->getActiveSheet()->getColumnDimension('A')->setVisible(false);
$spreadsheet->getActiveSheet()->getColumnDimension('B')->setVisible(false);
$spreadsheet->getActiveSheet()->getColumnDimension('C')->setVisible(false);

$writer = new Xlsx($spreadsheet);
$writer->save($filePath);

Why it does not hide the columns I selected? And what can I do to solve that?

Hygison Brandao
  • 590
  • 1
  • 4
  • 16

1 Answers1

4

use both in combination to hide for example column 'A'

$spreadsheet->getActiveSheet()->getColumnDimension('A')->setCollapsed(true);
$spreadsheet->getActiveSheet()->getColumnDimension('A')->setVisible(false);
mramsak
  • 176
  • 1
  • 1
  • 7