Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- Updating Excel cell...works in debugger only
August 9, 2006, 6:39 pm
rate this thread
I've got an interesting problem. I'm updating and displaying an excel
spreadsheet (using com) from a php file. Works great in the debugger
(PhpEd 4.6), but not otherwise. I assume there must be a difference in
PHP versions in effect here.
Instantiating com, opening workbook, activating sheet, selecting cell,
activating cell all work just fine... but when I try to set the cell
value, I just get "waiting on localhost" and it never returns.
$cell = $sheets->Cells($home_row[$row_num],2) ; //Select the cell
$cell->activate; //Activate the cell
$cell->value = stripslashes($row['player_name']);
The last statement, setting the cell value is where it never returns
from. No error, just "waiting".
As I said... no issues at all in the debugger.
Win2000, Apache 2.0.55, PHP 5.1.4
I'm tempted to drop down to PHP 4 and see if that makes a difference.
Apparently, PHP 5 has had com issues - but I thought they had been
resolved in this release. The prev version, v5.1.2 wouldn't even open
the workbook, this version(5.1.4) does , tho.
Thanks for any help!!