Connecting Tech Pros Worldwide Help | Site Map

Updating Excel cell...works in debugger only

 
LinkBack Thread Tools Search this Thread
  #1  
Old August 9th, 2006, 06:35 PM
JaxDawg
Guest
 
Posts: n/a
Default Updating Excel cell...works in debugger only

Hey folks...
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.

Code snippet:

$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.
My setup:
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!!


  #2  
Old August 10th, 2006, 12:25 AM
Chung Leong
Guest
 
Posts: n/a
Default Re: Updating Excel cell...works in debugger only

JaxDawg wrote:
Quote:
Hey folks...
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.
>
Code snippet:
>
$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.
My setup:
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!!
Does the Apache service have access to the desktop? Otherwise I don't
think Excel will start.

Go to Control Panel, Administrative Tools, Services and check the
properties of Apache.

 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Popular Articles

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 220,989 network members.