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
Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.
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++;
}
},
];
}
Please or to participate in this conversation.