Hi all,
I'm running Windows2003 server ent. ed., PHP 4.3.10, Apache 2.0.52 and Office 2003 (so Excel v11.5612.5606).
I had the code below working on a PHP 4.1 and Office 2000 versions, but now...with the newer versions and setup listed above, the code doesn't work:
$excel = new COM("Excel.Sheet"); //this works
//Open the workbook that we want to use.
$book = $excel->application->Worksheets->Open("F:\SomePath\ToThe\Spreedsheet\theSpreadshee.xls"); //Fails here
creating the com object seems to work because i can echo some msg right after, with the code following below commented out. if i try to echo out right after trying to open the worksheet....it fails, with no error msgs. No error messages in the php error logs, i can't get anything to stdout (although I know error->stdout works by testing another script), no msgs in the O/S log manager, etc. When run from the cmd line...no errors.
my php ini file has:
display_errors = On
...
log_errors = On
...
error_log = F:\pathto\phperrorlogs\php_errorlog.txt
any ideas on why the opening of the worksheet (which does exists in the path i'm pointing to) would stop working?
thanks.