Postingan lainnya
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 :
0
Belum ada Jawaban. Jadi yang pertama Jawaban
Login untuk ikut Jawaban