使用php基礎方式實現word中表單處理

<?php/*** zipFile 類用于處理 .docx 文件的解壓、修改和重新打包*/
class zipFile
{/** @var ZipArchive ZIP 文件對象 */private $zipFile;/** @var string 臨時目錄路徑 */private $tempDir;/** @var string 嵌入的 Excel 文件臨時目錄路徑 */private $excelTempDir;/** @var string 原始 .docx 文件路徑 */private $docxPath;/*** 構造函數* * @param string $docxPath .docx 文件路徑* @throws Exception 如果無法打開 .docx 文件*/public function __construct($docxPath){$this->docxPath = $docxPath;$this->zipFile = new ZipArchive();if ($this->zipFile->open($docxPath) !== TRUE) {throw new Exception("無法打開 .docx 文件: $docxPath");}$this->tempDir = sys_get_temp_dir() . '/docx_' . uniqid();mkdir($this->tempDir, 0777, true);// ? 正確命名：用于存放解壓的 Excel 內容$this->excelTempDir = $this->tempDir . '/embedded_excel';}/*** 解壓整個 .docx 到臨時目錄* 并自動解壓其中的 Workbook1.xlsx（如果存在）*/public function extract(){// 1. 解壓 .docx 主文件$this->zipFile->extractTo($this->tempDir);$this->zipFile->close();// echo "? .docx 已解壓到: {$this->tempDir}\n";// 2. 查找并解壓嵌入的 Excel 文件$embeddedXlsxPath = $this->tempDir . '/word/embeddings/Workbook1.xlsx';if (!file_exists($embeddedXlsxPath)) {echo "?? 未找到嵌入的 Workbook1.xlsx\n";return;}$excelZip = new ZipArchive();if ($excelZip->open($embeddedXlsxPath) !== TRUE) {throw new Exception("無法打開嵌入的 Workbook1.xlsx");}// 創建目錄并解壓 Excel 內容mkdir($this->excelTempDir, 0777, true);$excelZip->extractTo($this->excelTempDir);$excelZip->close();echo "? Workbook1.xlsx 已解壓到: {$this->excelTempDir}\n";}/*** 獲取解壓后的 sheet1.xml 路徑* * @return string*/public function getSheet1Path(){$path = $this->excelTempDir . '/xl/worksheets/sheet1.xml';if (!file_exists($path)) {throw new Exception("未找到 sheet1.xml: $path");}return $path;}/*** 獲取 sharedStrings.xml 路徑（用于字符串修改）* * @return string*/public function getSharedStringsPath(){$path = $this->excelTempDir . '/xl/sharedStrings.xml';if (!file_exists($path)) {throw new Exception("未找到 sharedStrings.xml");}return $path;}/*** 獲取文件內容（.docx 內任意文件）* * @param string $path 文件路徑（相對于解壓目錄）* @return string|null*/public function getFileContent($path){$fullPath = $this->tempDir . '/' . ltrim($path, '/');return file_exists($fullPath) ? file_get_contents($fullPath) : null;}/*** 寫入修改后的文件* * @param string $path 文件路徑（相對于解壓目錄）* @param string $content 文件內容*/public function putFileContent($path, $content){$fullPath = $this->tempDir . '/' . ltrim($path, '/');$dir = dirname($fullPath);if (!is_dir($dir)) {mkdir($dir, 0777, true);}file_put_contents($fullPath, $content);}/*** 修改 Excel 單元格值（僅限數字）* * @param string $cell 單元格地址，如 'B2'* @param mixed $newValue 新值*/public function modifyExcelCell($cell, $newValue){// 1. 修改 Excel 數據 (sheet1.xml)$sheetFile = $this->getSheet1Path();// 使用 DOMDocument 替代 simplexml_load_file$dom = new DOMDocument();$dom->load($sheetFile);if (!$dom) {throw new Exception("無法加載 sheet1.xml");}$xpath = new DOMXPath($dom);$xpath->registerNamespace('x', 'http://schemas.openxmlformats.org/spreadsheetml/2006/main');$nodes = $xpath->query("//x:c[@r='$cell']");if ($nodes->length == 0) {throw new Exception("未找到單元格: $cell");}$cNode = $nodes->item(0);$vNodes = $xpath->query(".//x:v", $cNode);if ($vNodes->length == 0) {throw new Exception("單元格 $cell 缺少 <v> 節點");}$vNode = $vNodes->item(0);$oldValue = $vNode->nodeValue;$vNode->nodeValue = $newValue;$dom->save($sheetFile);echo "? 已修改 Excel 單元格 $cell: $oldValue → $newValue\n";// 2. 同步更新圖表緩存$this->updateChartCache($cell, $newValue);}//批量更新public function updateDataAndChart($dataMap){foreach ($dataMap as $cell => $value) {$this->modifyExcelCell($cell, $value);}}/*** 更新 chart1.xml 中的緩存值（用于柱狀圖、折線圖等）* * @param string $cell 單元格地址，如 'B2'* @param mixed  $newValue 新值* @param string $chartXmlPath 圖表文件路徑，默認為 chart1.xml*//*** 根據單元格地址，在 chart1.xml 中找到對應的 <c:f> 并更新其 numCache* * @param string $cell 單元格地址，如 'B2'* @param mixed  $newValue 新值*/private function updateChartCache($cell, $newValue){$chartPath = $this->tempDir . '/word/charts/chart1.xml';if (!file_exists($chartPath)) {echo "?? 未找到 chart1.xml，跳過圖表緩存更新\n";return;}// 使用 DOMDocument 替代 simplexml_load_file$dom = new DOMDocument();$dom->load($chartPath);if (!$dom) {throw new Exception("無法加載 chart1.xml");}// 注冊命名空間$xpath = new DOMXPath($dom);$xpath->registerNamespace('c', 'http://schemas.openxmlformats.org/drawingml/2006/chart');$xpath->registerNamespace('a', 'http://schemas.openxmlformats.org/drawingml/2006/main');// 構造目標引用，如：Sheet1!$B$2$escapedCell = preg_replace('/([A-Z]+)/', '$1$', $cell); // B2 -> B$2$targetRef = "Sheet1!\$$escapedCell"; // 注意：Sheet1!$B$2// 查找 <c:f> 內容為 Sheet1!$B$2 的節點$fNodes = $xpath->query("//c:f[text()='$targetRef']");if ($fNodes->length == 0) {echo "🔍 未在 chart1.xml 中找到引用 $targetRef\n";return;}foreach ($fNodes as $fNode) {// 找到父級 <c:ser> 或 <c:pt> 等結構$parent = $fNode->parentNode;// 查找對應的 <c:numCache>$numCacheNodes = $xpath->query(".//c:numCache", $parent);if ($numCacheNodes->length == 0) {// echo "?? 找到引用 $targetRef，但無 <c:numCache> 緩存\n";continue;}$numCache = $numCacheNodes->item(0);// 查找 <c:pt idx="0"> 下的 <c:v>$ptNodes = $xpath->query(".//c:pt[@idx='0']/c:v", $numCache);if ($ptNodes->length > 0) {$ptNode = $ptNodes->item(0);$oldValue = $ptNode->nodeValue;$ptNode->nodeValue = $newValue;echo "📊 已更新圖表緩存 [$targetRef]: $oldValue → $newValue\n";} else {// 如果沒有 pt，嘗試創建（高級功能，可選）echo "?? 未找到 <c:pt> 節點，無法更新緩存: $targetRef\n";}}// 保存修改$dom->save($chartPath);}/*** 重新打包為 .docx* * @param string $outputPath 輸出文件路徑*/public function pack($outputPath){// 1. 先打包嵌入的 Excel，并自動清理臨時目錄$this->repackEmbeddedWorkbook();// 2. 再打包整個 .docx 文件$newZip = new ZipArchive();if ($newZip->open($outputPath, ZipArchive::CREATE | ZipArchive::OVERWRITE) !== TRUE) {throw new Exception("無法創建輸出文件: $outputPath");}$files = new RecursiveIteratorIterator(new RecursiveDirectoryIterator($this->tempDir, FilesystemIterator::SKIP_DOTS),RecursiveIteratorIterator::LEAVES_ONLY);foreach ($files as $file) {if (!$file->isDir()) {$filePath = $file->getRealPath();$relativePath = substr($filePath, strlen($this->tempDir) + 1);$newZip->addFile($filePath, $relativePath);}}$newZip->close();echo "? 已打包為: $outputPath\n";}/*** 將修改后的 embedded_excel/ 目錄重新打包為 Workbook1.xlsx* 并刪除臨時解壓目錄（確保中間文件不殘留）*/private function repackEmbeddedWorkbook(){$embeddedXlsxPath = $this->tempDir . '/word/embeddings/Workbook1.xlsx';// 如果沒有 embedded_excel 目錄，說明沒有 Excel 或未解壓if (!is_dir($this->excelTempDir)) {echo "?? 無嵌入 Excel 臨時目錄，跳過打包 Workbook1.xlsx\n";return;}// 刪除舊的 Workbook1.xlsx（如果存在）if (file_exists($embeddedXlsxPath)) {unlink($embeddedXlsxPath);}// 創建新的 Zip 存檔$zip = new ZipArchive();if ($zip->open($embeddedXlsxPath, ZipArchive::CREATE | ZipArchive::OVERWRITE) !== TRUE) {throw new Exception("無法創建 Workbook1.xlsx");}$files = new RecursiveIteratorIterator(new RecursiveDirectoryIterator($this->excelTempDir, FilesystemIterator::SKIP_DOTS),RecursiveIteratorIterator::LEAVES_ONLY);foreach ($files as $file) {if (!$file->isDir()) {$filePath = $file->getRealPath();$relativePath = substr($filePath, strlen($this->excelTempDir) + 1);$zip->addFile($filePath, $relativePath);}}$zip->close();echo "? Workbook1.xlsx 已重新打包\n";// 🔥 關鍵修復：立即刪除 embedded_excel 臨時目錄$this->rrmdir($this->excelTempDir);echo "🗑?  已清理 Excel 臨時目錄: {$this->excelTempDir}\n";}/*** 列出解壓目錄中的所有文件* * @return array 文件路徑列表*/public function listFiles(){$files = [];if (!is_dir($this->tempDir)) return $files;$iterator = new RecursiveIteratorIterator(new RecursiveDirectoryIterator($this->tempDir, FilesystemIterator::SKIP_DOTS));foreach ($iterator as $file) {if ($file->isFile()) {$relativePath = substr($file->getPathname(), strlen($this->tempDir) + 1);$files[] = $relativePath;}}return $files;}/*** 清理臨時文件*/public function cleanup(){if (is_dir($this->tempDir)) {$this->rrmdir($this->tempDir);}}/*** 遞歸刪除目錄* * @param string $dir 目錄路徑*/private function rrmdir($dir){$files = new RecursiveIteratorIterator(new RecursiveDirectoryIterator($dir, FilesystemIterator::SKIP_DOTS),RecursiveIteratorIterator::CHILD_FIRST);foreach ($files as $fileinfo) {$todo = ($fileinfo->isDir() ? 'rmdir' : 'unlink');$todo($fileinfo->getRealPath());}rmdir($dir);}
}// ? 使用示例（修復后）
try {$processor = new zipFile('表單.docx');$processor->extract();// ? 方法一：使用封裝好的 modifyExcelCell$processor->modifyExcelCell('B2', 500);$processor->pack('output.docx');$processor->cleanup();
} catch (Exception $e) {echo "? 錯誤: " . $e->getMessage() . "\n";
}