Cara Ekspor Data MySQL ke Excel Menggunakan PHP

CREATE TABLE `tbl_info` (
  `id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `description` varchar(50) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `tbl_info`
--

INSERT INTO `tbl_info` (`id`, `name`, `description`, `date`) VALUES
(1, 'Wina Faujiah', 'Mahasiswi Kedokteran', '2019-07-03 13:05:47'),
(2, 'Sena Duta', 'Mahasiswa Hukum', '2019-07-03 13:05:47'),
(3, 'Ridwan Utara', 'Mahasiswa Pertanian', '2019-07-03 13:05:47'),
(4, 'Dini Andini', 'Mahasiswi Sastra Bahasa', '2019-07-03 13:05:47'),
(5, 'Kania', 'Mahisiswi Teknik Sipil', '2019-07-03 13:05:47');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `tbl_info`
--
ALTER TABLE `tbl_info`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `tbl_info`
--
ALTER TABLE `tbl_info`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

<?php
//definisikan koneksi database
 $koneksi=mysqli_connect("localhost","root","","test_import");
 //arahkan ke plugins php excel
 include('phpexcel/Classes/PHPExcel.php');
 //jalankan query, query bisa saja kompleks dengan parameter where atau ada iner join didalammnya tergantung kebutuhan
 $sql = "SELECT id, name, description  FROM tbl_info ";
 $perintah=mysqli_query($koneksi, $sql);
$objPHPExcel = new PHPExcel();
$objPHPExcel->getProperties()->setCreator("ROOT93")
                                          ->setLastModifiedBy("PPDB")
                                          ->setTitle("DATA JUDUL")
                                          ->setSubject("SUBJEK")
                                          ->setDescription("DESKRIPSI")
                                          ->setKeywords("PHPExcel php")
                                          ->setCategory("General");
// mulai dari baris ke 2
$row = 2;
 
// Mendefinisikan Judul Kolom
$objPHPExcel->setActiveSheetIndex(0)
            ->setCellValue('A'.$row, 'ID')
            ->setCellValue('B'.$row, 'NAME')
            ->setCellValue('C'.$row, 'DESCRIPTION');
   ;
            
          


$row++; // Selanjautnya set nilainya masing - masing
while( $data = mysqli_fetch_array($perintah)){
      $objPHPExcel->setActiveSheetIndex(0)
            ->setCellValue('A'.$row, $data['id'])
            ->setCellValue('B'.$row, $data['name'])
            ->setCellValue('C'.$row, $data['description']); 
            
            
     $row++; // pindah ke row bawahnya ($row + 1)
      
}

$objPHPExcel->getActiveSheet()->setTitle('BACKUP DATA SISWA PPDB');
$objPHPExcel->setActiveSheetIndex(0);
 
 
// Download (Excel2007)
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="JUDUL FILE.xlsx"');
header('Cache-Control: max-age=0');
// If you're serving to IE 9, then the following may be needed
header('Cache-Control: max-age=1');
// If you're serving to IE over SSL, then the following may be needed
header ('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); // Date in the past
header ('Last-Modified: '.gmdate('D, d M Y H:i:s').' GMT'); // always modified
header ('Cache-Control: cache, must-revalidate'); // HTTP/1.1
header ('Pragma: public'); // HTTP/1.0
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); 
ob_end_clean(); 
$objWriter->save('php://output');
exit;
 
?>