如何使用PHP将Excel XLS转换为CSV

composer require phpoffice/phpexcel

<?php

require_once 'vendor/autoload.php';

use PhpOffice\PhpSpreadsheet\IOFactory;

function convertXlsToCsv($inputFileName, $outputFileName)
{
    // 读取Excel文件
    $spreadsheet = IOFactory::load($inputFileName);

    // 获取工作表数量
    $worksheetCount = $spreadsheet->getSheetCount();

    // 遍历工作表并将其保存为CSV文件
    for ($i = 0; $i < $worksheetCount; $i++) {
        $worksheet = $spreadsheet->setActiveSheetIndex($i);
        $csvWriter = IOFactory::createWriter($worksheet, 'Csv');
        $csvWriter->save($outputFileName . '_sheet' . $i . '.csv');
    }
}

// 使用示例
$inputFileName = 'example.xls';
$outputFileName = 'example';
convertXlsToCsv($inputFileName, $outputFileName);

php convert-xls-to-csv.php