代码
<?PHP
$filename = "E:\phpyunxing\APMServ5.2.0\www\htdocs\aaa.xls";
$sheet1 = 1;
$sheet2 = "sheet2";
$excel_app = new COM("Excel.application") or Die ("Did not connect");
print "Application name: {$excel_app->Application->value}\n" ; 
print "Loaded version: {$excel_app->Application->version}\n";
$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);
?>结果:
Application name: Microsoft Excel Loaded version: 11.0 
Fatal error: Uncaught exception 'com_exception' with message '<b>Source:</b> Microsoft Office Excel<br/><b>Description:</b> 不能取得类 Workbooks 的 Open 属性' in E:\phpyunxing\APMServ5.2.0\www\htdocs\index.php:8 Stack trace: #0 E:\phpyunxing\APMServ5.2.0\www\htdocs\index.php(8): variant->Open('E:\phpyunxing\A...') #1 {main} thrown in E:\phpyunxing\APMServ5.2.0\www\htdocs\index.php on line 8
请求解决方案,我用vista sp1