Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

vandan's avatar
Level 13

maatwebsite/excel not working on older version of excel sheet

hii i have issue for add comments on excel sheet its working fine in latest version of excel sheet but i try to export older version sheet not working

here is my code of export

public function registerEvents(): array
	{
    	return [
        	AfterSheet::class    => function(AfterSheet $event) {

            	$styleArray = [
                		'borders' => [
                    	'outline' => [
                        'borderStyle' => \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN, //BORDER_THICK,
                        'color' => ['argb' => 'FFFF0000'],
                    ]
                ]
            ];

            $i = 0;
            // $letters = range('A','ZZ');
            $letters = array();
            $letter = 'A';
            while ($letter !== 'AAA') {
                $letters[] = $letter++;
            }

            foreach ($this->row_no as $row) {
                // $event->sheet->getDelegate()->getColumnDimension($letters[$i])->setAutoSize(true);
                $event->sheet->getDelegate()->getStyle($letters[$this->column_no[$i]].$row)->applyFromArray($styleArray);
                $event->sheet->getDelegate()->getComment($letters[$this->column_no[$i]].$row)->getText()->createTextRun('User Id');
                $i++;
            }
        },
    ];
}
0 likes
2 replies
vandan's avatar
Level 13

anyone help how can i solved this i dont know my older version worksheet 97-2003 not woking in getComment how to solved this?

1 like

Please or to participate in this conversation.