<?php
//定义一个excel文件
$workbook = "C:/My Documents/test.xls" ;
$sheet = "Sheet1" ;
//生成一个com对象 $ex
$ex = new COM ( "Excel.sheet" ) or Die ( "连不上!!!" );
//打开一个excel文件
$book = & ensp ; $ex -> application -> Workbooks -> Open (& ensp ; $workbook ) or Die ( "打不开!!!" );
$sheets = & ensp ; $book -> Worksheets (& ensp ; $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 );
?>
//定义一个excel文件
$workbook = "C:/My Documents/test.xls" ;
$sheet = "Sheet1" ;
//生成一个com对象 $ex
$ex = new COM ( "Excel.sheet" ) or Die ( "连不上!!!" );
//打开一个excel文件
$book = & ensp ; $ex -> application -> Workbooks -> Open (& ensp ; $workbook ) or Die ( "打不开!!!" );
$sheets = & ensp ; $book -> Worksheets (& ensp ; $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 );
?>