thinkphp 导入导出excel

use think\facade\Db;
use PhpOffice\PhpSpreadsheet\IOFactory;

// 读取 Excel 文件
$inputFileName = './excels/data.xlsx';
$spreadsheet = IOFactory::load($inputFileName);
$worksheet = $spreadsheet->getActiveSheet();

// 获取数据并插入数据库
$data = [];
foreach ($worksheet->getRowIterator() as $row) {
    $cellIterator = $row->getCellIterator();
    $cellIterator->setIterateOnlyExistingCells(false);
    $rowData = [];
    foreach ($cellIterator as $cell) {
        $rowData[] = $cell->getValue();
    }
    $data[] = $rowData;
}

// 插入数据库
Db::name('table_name')->insertAll($data);

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

// 获取数据
$data = Db::name('table_name')->select();

// 创建 Excel 对象
$spreadsheet = new Spreadsheet();
$worksheet = $spreadsheet->getActiveSheet();

// 写入数据
foreach ($data as $rowIndex => $row) {
    foreach ($row as $colIndex => $cellValue) {
        $worksheet->setCellValueByColumnAndRow($colIndex + 1, $rowIndex + 1, $cellValue);
    }
}

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

$spreadsheet = IOFactory::load($inputFileName, 'Xlsx');

$writer = new Xlsx($spreadsheet);
$writer->setSheetIndex(0);
$writer->save('./excels/output.xlsx');