Tweet
<?php
//Set the workbook
$strWorkbook = "./bla.xls";
//and the sheets for use
$strSheet = "test";
//Instantiate the spreadsheet component.
$objXls = new COM("Excel.sheet")
or die ("can't connect to COM");
//Open the workbook.
$ObjWkb = $objXls->application->Workbooks->Open($strWorkbook)
or die ("can't open $workbook");
//Uncomment to make Excel visible, but not recommended
//$ex->Application->Visible = 1;
//Select the sheet
$objSheets = $ObjWkb->Worksheets($strSheet);
//Activate it
$objSheets->activate;
//Select the cell B23
$objCell = $objSheets->Cells(23,2) ;
//Activate the cell
$objCell->activate;
//Print the old value
echo "Old Value = {$objCell->value} <br />\n";
//Change it to 25
$objCell->value = 25;
//Print the new value
echo "New Value = {$objCell->value} <br />\n";
//Create a copy of the workbook, so the original workbook will be preserved.
$objXls->Application->ActiveWorkbook->SaveAs("mytest");
//Close all workbooks without questioning
$objXls->application->ActiveWorkbook->Close("False");
//Destroy object
unset ($objXls);
?>
Kommentar