连接到Excel工作簿时发生致命错误
问题描述:
运行用于连接工作簿的代码时,出现致命错误。连接到Excel工作簿时发生致命错误
下面的代码:
<?php
$filename = "C:/Users/.../Output.xlsb";
$sheet1 = "DAILY_OUTPUT";
$sheet2 = "DAILY_OUTPUT";
$excel_app = new COM("Excel.application") or Die ("Did not connect");
$Workbook = $excel_app->Workbooks->Open("$filename") or Die("Did not open $filename $Workbook");
$Worksheet = $Workbook->Worksheets($sheet1);
$Worksheet->activate;
$excel_cell = $Worksheet->Range("C4");
$excel_cell->activate;
$excel_result = $excel_cell->value;
print "$excel_result\n";
$Worksheet = $Workbook->Worksheets($sheet2);
$Worksheet->activate;
$excel_cell = $Worksheet->Range("C4");
$excel_cell->activate;
$excel_result = $excel_cell->value;
print "$excel_result\n";
#To close all instances of excel:
$Workbook->Close;
unset($Worksheet);
unset($Workbook);
$excel_app->Workbooks->Close();
$excel_app->Quit();
unset($excel_app);
;当我从PhpStorm运行谷歌浏览器它表明:
Fatal error: in C:\Users\...\excCon.php on line 6
编辑:“......”只是缩短网址这里
答
解决方法是错误的斜杠。 而不是单一/
我把双\
现在正确读取文件的路径。