php导出mysql到excel

<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database_name";

// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);

// 检查连接
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}
echo "连接成功";
?>

<?php
require 'vendor/autoload.php';

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

// 创建一个新的Spreadsheet对象
$spreadsheet = new Spreadsheet();

// 获取当前活动的工作表
$sheet = $spreadsheet->getActiveSheet();

// 从数据库中读取数据
$conn = new mysqli("localhost", "username", "password", "database_name");
$sql = "SELECT * FROM table_name";
$result = $conn->query($sql);

// 将数据写入工作表
if ($result->num_rows > 0) {
    $row = 1;
    while($row_data = $result->fetch_assoc()) {
        $col = 'A';
        foreach ($row_data as $cell_data) {
            $sheet->setCellValue($col . $row, $cell_data);
            $col++;
        }
        $row++;
    }
}

// 导出到Excel文件
$writer = new Xlsx($spreadsheet);
$writer->save('exported_data.xlsx');

echo "数据已成功导出到Excel文件";
?>