如何下载php excel文件_获取php操作excel文件的相关文件方法

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

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

// 创建一个新的 Spreadsheet 对象
$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
$sheet->setCellValue('A1', '姓名');
$sheet->setCellValue('B1', '年龄');
$sheet->setCellValue('A2', '张三');
$sheet->setCellValue('B2', '25');

// 设置下载响应头
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="users.xlsx"');
header('Cache-Control: max-age=0');

// 使用 Xlsx 写入器
$writer = new Xlsx($spreadsheet);
$writer->save('php://output'); // 输出到浏览器，触发下载

<?php
$filePath = 'uploads/template.xlsx'; // 文件路径

if (file_exists($filePath)) {
    header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
    header('Content-Disposition: attachment; filename="' . basename($filePath) . '"');
    header('Cache-Control: max-age=0');
    readfile($filePath);
    exit;
} else {
    echo "文件未找到！";
}

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

use PhpOffice\PhpSpreadsheet\IOFactory;

if ($_FILES['excelFile']['error'] == 0) {
    $inputFileName = $_FILES['excelFile']['tmp_name'];
    
    try {
        $spreadsheet = IOFactory::load($inputFileName);
        $sheetData = $spreadsheet->getActiveSheet()->toArray(null, true, true, true);

        foreach ($sheetData as $row) {
            print_r($row); // 输出每一行数据
        }
    } catch (Exception $e) {
        echo 'Error loading file: ', $e->getMessage();
    }
}

<form method="post" enctype="multipart/form-data">
    <input type="file" name="excelFile" accept=".xlsx,.xls" />
    <button type="submit">上传并读取</button>
</form>