com_dotnet 擴充 (PHP 7.4+ 需在 php.ini 啟用 extension=com_dotnet)。COM、VARIANT、DOTNET<?php
// 建立 COM 物件
$word = new COM('Word.Application') or die('無法啟動 Word');
$excel = new COM('Excel.Application');
$ado = new COM('ADODB.Connection');
// 設定屬性
$word->Visible = false; // 背景執行
$word->DisplayAlerts = false; // 關閉彈窗
// 呼叫方法
$doc = $word->Documents->Add();
$word->Selection->TypeText("Hello from PHP!");
// 儲存並關閉
$doc->SaveAs('C:\temp\php_word.docx');
$doc->Close();
$word->Quit();
// 釋放資源 (關鍵!)
$doc = null;
$word = null;
// 強制 GC (PHP 非即時回收 COM 參考)
gc_collect_cycles();
?>
<?php
$conn = new COM('ADODB.Connection');
$conn->Open("Provider=SQLOLEDB;Server=localhost;Database=testdb;Uid=sa;Pwd=pass;");
$rs = $conn->Execute("SELECT TOP 10 id, name FROM users");
while (!$rs->EOF) {
echo $rs->Fields('id')->Value . " : " . $rs->Fields('name')->Value . "
";
$rs->MoveNext();
}
$rs->Close();
$conn->Close();
$rs = $conn = null;
gc_collect_cycles();
?>
<?php
$excel = new COM('Excel.Application');
$excel->Visible = false;
$excel->DisplayAlerts = false;
$wb = $excel->Workbooks->Open('C:\data\report.xlsx');
$ws = $wb->Worksheets(1); // 1-based
// 讀取儲存格
$val = $ws->Cells(1, 1)->Value; // A1
// 寫入
$ws->Cells(2, 1)->Value = 'PHP 寫入';
$ws->Cells(2, 2)->Value = date('Y-m-d H:i:s');
$wb->Save();
$wb->Close(false);
$excel->Quit();
$wb = $ws = $excel = null;
gc_collect_cycles();
?>
| 需求 | 推薦庫 | 特點 |
|---|---|---|
| 讀寫 Excel (.xlsx/.xls/.csv) | PhpSpreadsheet (PhpOffice) | 純 PHP、功能完整、記憶體優化 (Cell Caching)、Composer 安裝 |
| 大量資料匯出 (百萬行) | Box/Spout 或 PhpSpreadsheet 串流寫入 | 低記憶體、高速串流 |
| Word (.docx) 讀寫/轉 PDF | PhpWord (PhpOffice) / LibreOffice Headless | PhpWord 功能有限;LibreOffice 轉換最完美 |
| PDF 生成 | Dompdf, Snappy (wkhtmltopdf), TCPDF | HTML 轉 PDF 主流選擇 |
| 資料庫存取 | PDO / Doctrine DBAL / Eloquent | 原生/抽象層/ORM,跨平台 |
<?php
// composer require phpoffice/phpspreadsheet
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
$sheet->setCellValue('A1', 'Hello');
$sheet->setCellValue('B1', 'World');
$sheet->setCellValue('A2', '中文測試');
$sheet->setCellValue('B2', 123.45);
$writer = new Xlsx($spreadsheet);
$writer->save('hello.xlsx');
// 讀取
$spreadsheet = \PhpOffice\PhpSpreadsheet\IOFactory::load('hello.xlsx');
$value = $spreadsheet->getActiveSheet()->getCell('A1')->getValue();
?>
PHP COM 橋接是 Windows 平台特有的強大能力,但**僅適合 CLI 管理腳本、離線批次處理、桌面自動化**。Web 應用中**嚴禁直接實例化 Office COM 物件**,會導致 Worker 進程卡死、記憶體洩漏、權限衝突。請全面遷移至純 PHP 庫 (PhpSpreadsheet, PhpWord) 或無頭服務 (LibreOffice, Headless Chrome, Pandoc) 架構,構建穩定、可擴展、跨平台的文件處理服務。