Hasil Export data dari Database ke Excel Korup

Permisi agan agan tamvan penghuni sekolahkoding... mau tanya lagi nih, saya abis ngoding script (lebih tepatnya kopas lah ya wkwkwkwk) buat export data dari phpmyadmin pake PHP, tapi kok hasilnya korup ya ? ada yang salah kah dengan kodingan saya ? mohon bantuannya suhuu.. disini ada cendol ngga ? nanti dikasih cendol deh wkwkwkwk...

Spoiler For Database :

Spoiler For Skrip Koding :

 <?php include_once 'core/init.php'; require_once 'PHPExcel/Classes/PHPExcel.php'; ?>

<?php

$mkg = mysqli_query("SELECT * FROM report ORDER BY tanggal DSC");
$objPHPExcel = new PHPExcel();

$objPHPExcel->getProperties()->setCreator("Donny Pratama")
                            ->setLastModifiedBy("Donny Pratama")
                            ->setTitle("Report")
                            ->setSubject("Pelanggaran")
                            ->SetDescription("Data")
                            ->setKeywords("report")
                            ->setCategory("Report");

$row = 2;

$objPHPExcel->setActiveSheetIndex(0)
            ->setCellValue('A'.$row, 'Nomor')
            ->setCellValue('B'.$row, 'Tanggal')
            ->setCellValue('C'.$row, 'Waktu')
            ->setCellValue('D'.$row, 'Outlet')
            ->setCellValue('E'.$row, 'Kesalahan')
            ->setCellValue('F'.$row, 'Nama Pelanggar');

$nomor = 1;
$row++;

while ($data = mysqli_fetch_array($mkg)) {
  $objPHPExcel->setActiveSheetIndex(0)
              ->setCellValue('A'.$row, $data['Nomor'])
              ->setCellValue('B'.$row, $data['Tanggal'])
              ->setCellValue('C'.$row, $data['Waktu'])
              ->setCellValue('D'.$row, $data['Outlet'])
              ->setCellValue('E'.$row, $data['Kesalahan'])
              ->setCellValue('F'.$row, $data['Nama Pelanggar']);
$row++;
$nomor++;

}

$objPHPExcel->getActiveSheet()->setTitle('Report');

$objPHPExcel->setActiveSheetIndex(0);

header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="Report.xlsx"');
header('Cache-Control: max-age=0');

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save('Report.xlsx');
exit;

?>

Spoiler For Error :

avatar DonnyTM
@DonnyTM

4 Kontribusi 0 Poin

Dipost 6 tahun yang lalu

Belum ada Jawaban. Jadi yang pertama Jawaban

Login untuk ikut Jawaban