foreach($data as $f ) { //$worksheet->getStyle('A'.$row1)->getNumberFormat()->setFormatCode($textFormat); $worksheet->setCellValue('A'.$row1, $no.chr(46)); $worksheet->setCellValue('B'.$row1,' '.$f['nama']); $spreadsheet->getActiveSheet()->getStyle('A'.$row1)->getNumberFormat()->setFormatCode(\PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_TEXT); $row1++; $no++; }