$file = fopen('data.csv', 'r');
while (($row = fgetcsv($file, 1000, ',')) !== false) {
    // 驗(yàn)證行數(shù)據(jù)：列數(shù)匹配、空值處理、類型轉(zhuǎn)換
    if (count($row) !== 5) continue; // 跳過異常行
    $sanitized = array_map('trim', $row);
    // 插入數(shù)據(jù)庫（建議使用預(yù)處理語句防SQL注入）
    $stmt = $pdo->prepare("INSERT INTO table (col1,col2) VALUES (?,?)");
    $stmt->execute([$sanitized[0], $sanitized[1]]);
}
fclose($file);

header('Content-Type: text/csv; charset=utf-8');
header('Content-Disposition: attachment; filename="export.csv"');
$output = fopen('php://output', 'w');
// 寫入BOM頭解決Excel亂碼
fwrite($output, "\xEF\xBB\xBF");
// 標(biāo)題行
fputcsv($output, ['Name', 'Age', 'Email']);
// 數(shù)據(jù)循環(huán)（假設(shè)$data為數(shù)組）
foreach ($data as $row) {
    // 數(shù)值型字段強(qiáng)制轉(zhuǎn)換為字符串防科學(xué)計(jì)數(shù)法
    $row['age'] = (string)$row['age'];
    fputcsv($output, $row);
}
fclose($output);
exit;

composer require phpoffice/phpspreadsheet

use PhpOffice\PhpSpreadsheet\IOFactory;

$spreadsheet = IOFactory::load('data.xlsx');
$sheet = $spreadsheet->getActiveSheet();
// 獲取合并單元格區(qū)域
$mergedCells = $sheet->getMergeCells();
foreach ($mergedCells as $range) {
    // 解析如"A1:C1"為起始結(jié)束坐標(biāo)
    list($start, $end) = explode(':', $range);
    // 自定義合并邏輯（如取左上角值填充）
}
// 遍歷行（跳過標(biāo)題行）
foreach ($sheet->getRowIterator(2) as $row) {
    $rowData = [];
    $cellIterator = $row->getCellIterator();
    $cellIterator->setIterateOnlyExistingCells(false);
    foreach ($cellIterator as $cell) {
        $value = $cell->getValue();
        // 公式計(jì)算結(jié)果獲取
        if ($cell->getDataType() === 'f') {
            $value = $cell->getCalculatedValue();
        }
        // 日期格式轉(zhuǎn)換（Excel存儲(chǔ)為浮點(diǎn)數(shù)）
        if (is_numeric($value) && \PhpOffice\PhpSpreadsheet\Shared\Date::isDateTime($cell)) {
            $value = \PhpOffice\PhpSpreadsheet\Shared\Date::excelToDateTimeObject($value)->format('Y-m-d');
        }
        $rowData[] = $value;
    }
    // 數(shù)據(jù)處理入庫...
}

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

$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
// 設(shè)置標(biāo)題行樣式
$sheet->getStyle('A1:C1')->applyFromArray([
    'font' => ['bold' => true],
    'borders' => ['allBorders' => ['borderStyle' => \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN]]
]);
// 填充數(shù)據(jù)
$data = [
    ['產(chǎn)品', '銷量', '單價(jià)'],
    ['A', 1200, 99.5],
    // ...
];
$sheet->fromArray($data, null, 'A1');
// 自動(dòng)調(diào)整列寬
foreach (range('A', 'C') as $col) {
    $sheet->getColumnDimension($col)->setAutoSize(true);
}
// 大文件處理：分塊寫入
$writer = new Xlsx($spreadsheet);
$writer->setPreCalculateFormulas(false); // 禁用公式計(jì)算提升速度
$writer->save('report.xlsx');