PhPexcel dari baris mysql

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++;

}

 

Tinggalkan Balasan

Alamat email Anda tidak akan dipublikasikan. Ruas yang wajib ditandai *