如何将本表数据从php导出到Excel文件

require_once 'PHPExcel/Classes/PHPExcel/Autoloader.php';

$objPHPExcel = new PHPExcel();
$objPHPExcel->getProperties()->setCreator("Your Name")
                             ->setLastModifiedBy("Your Name")
                             ->setTitle("Data Export")
                             ->setSubject("Data Export")
                             ->setDescription("Data exported from database")
                             ->setKeywords("data export")
                             ->setCategory("Export");

$row = 1; // 行号
while ($data = $result->fetch_assoc()) {
    $col = 0; // 列号
    foreach ($data as $value) {
        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, $value);
        $col++;
    }
    $row++;
}

$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setAutoSize(true);

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