$workbook = "D:\\AppServ\\www\\asd.xls";
$sheet = "Sheet1";
$ex = new COM("excel.sheet") or Die ("连不上!!!");
$book = $ex->application->Workbooks->Open($workbook) or Die ("打不开!!!");
$sheets = $book->Worksheets($sheet);
$sheets->activate;
$cell = $sheets->Cells(5,5);
$cell->activate;
$cell->value = 999;
$ex->Application->ActiveWorkbook->SaveAs("newtest.xls");
$ex->Application->ActiveWorkbook->Close("False");
unset ($ex);
------------------------------------------------------------------------
像上面这段代码,是调用com来操作excel,但是像application,Workbooks,Open,Worksheets这些方法和对象他们是怎么知道的???我该到哪儿去查有哪些方法和对象?
$sheet = "Sheet1";
$ex = new COM("excel.sheet") or Die ("连不上!!!");
$book = $ex->application->Workbooks->Open($workbook) or Die ("打不开!!!");
$sheets = $book->Worksheets($sheet);
$sheets->activate;
$cell = $sheets->Cells(5,5);
$cell->activate;
$cell->value = 999;
$ex->Application->ActiveWorkbook->SaveAs("newtest.xls");
$ex->Application->ActiveWorkbook->Close("False");
unset ($ex);
------------------------------------------------------------------------
像上面这段代码,是调用com来操作excel,但是像application,Workbooks,Open,Worksheets这些方法和对象他们是怎么知道的???我该到哪儿去查有哪些方法和对象?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货