成都精装房新楼盘在哪:php 操作excel的问题!
来源:百度文库 编辑:查人人中国名人网 时间:2024/04/30 09:21:04
代码:
<?php
//定义一个excel文件
$workbook = "C:/My Documents/test.xls";
$sheet = "Sheet1";
//生成一个com对象$ex
$ex = new COM("Excel.sheet") or Die ("连不上!!!");
//打开一个excel文件
$book = $ex->application->Workbooks->Open($workbook) or Die ("打不开!!!");
$sheets = $book->Worksheets($sheet);
$sheets->activate;
//获取一个单元格
$cell = $sheets->Cells(5,5);
$cell->activate;
//给该单元格赋值
$cell->value = 999;
//保存为另一文件newtest.xls
$ex->Application->ActiveWorkbook->SaveAs("newtest.xls");
//关掉excel,如果想看效果,则注释掉下面两行,由用户手动关掉excel
$ex->Application->ActiveWorkbook->Close("False");
unset ($ex);
?>
出现错误!
Uncaught exception 'com_exception' with message 'Error [0x80020003] 。 ' in D:\Apache Group\Apache2\htdocs\excel_test.php:8 Stack trace: #0 D:\Apache Group\Apache2\htdocs\excel_test.php(8): unknown() #1 {main} thrown in D:\Apache Group\Apache2\htdocs\excel_test.php on line 8
希望能有高手比较清楚地告诉一下是什么问题,谢谢了!
<?php
//定义一个excel文件
$workbook = "C:/My Documents/test.xls";
$sheet = "Sheet1";
//生成一个com对象$ex
$ex = new COM("Excel.sheet") or Die ("连不上!!!");
//打开一个excel文件
$book = $ex->application->Workbooks->Open($workbook) or Die ("打不开!!!");
$sheets = $book->Worksheets($sheet);
$sheets->activate;
//获取一个单元格
$cell = $sheets->Cells(5,5);
$cell->activate;
//给该单元格赋值
$cell->value = 999;
//保存为另一文件newtest.xls
$ex->Application->ActiveWorkbook->SaveAs("newtest.xls");
//关掉excel,如果想看效果,则注释掉下面两行,由用户手动关掉excel
$ex->Application->ActiveWorkbook->Close("False");
unset ($ex);
?>
出现错误!
Uncaught exception 'com_exception' with message 'Error [0x80020003] 。 ' in D:\Apache Group\Apache2\htdocs\excel_test.php:8 Stack trace: #0 D:\Apache Group\Apache2\htdocs\excel_test.php(8): unknown() #1 {main} thrown in D:\Apache Group\Apache2\htdocs\excel_test.php on line 8
希望能有高手比较清楚地告诉一下是什么问题,谢谢了!
不会