PHPExcel 庫提供直觀的 Reader/Writer 模式,幾行代碼即可完成格式轉換:
<?php
require_once 'PHPExcel/IOFactory.php';
$filename = 'myexcel.xlsx';
// 建立對應版本的 Reader
$objReader = PHPExcel_IOFactory::createReader('Excel2007'); // xlsx 用 Excel2007,xls 用 Excel5
$objPHPExcel = $objReader->load($filename);
// 建立 CSV Writer
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'CSV');
$objWriter->save(str_replace('.xlsx', '.csv', $filename));
echo "轉換完成:{$filename} → " . str_replace('.xlsx', '.csv', $filename);
Excel5 對應 .xls (BIFF)、Excel2007 對應 .xlsx (OOXML)iconv 轉碼PHPExcel_CachedObjectStorageFactory 快取模式減少記憶體佔用setLoadSheetsOnly() 指定或迴圈處理所有工作表<?php
$dir = 'data/';
$files = glob($dir . '*.{xls,xlsx}', GLOB_BRACE);
foreach ($files as $file) {
$ext = pathinfo($file, PATHINFO_EXTENSION);
$readerType = ($ext === 'xlsx') ? 'Excel2007' : 'Excel5';
$objReader = PHPExcel_IOFactory::createReader($readerType);
$objPHPExcel = $objReader->load($file);
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'CSV');
$csvFile = $dir . basename($file, ".$ext") . '.csv';
$objWriter->save($csvFile);
echo "已轉換:$file → $csvFile\n";
}
memory_limit)足夠處理大檔案