Edit report at https://bugs.php.net/bug.php?id=55715&edit=1
ID: 55715 Comment by: bugzilla33 at gmail dot com Reported by: ystsoi at yahoo dot com dot hk Summary: Iterating Excel worksheet cell values may crash PHP Status: Open Type: Bug Package: COM related Operating System: Windows XP SP3, Windows 7 PHP Version: 5.4.0beta1 Block user comment: N Private report: N New Comment: Expected result: ---------------- PHP 5.3.9RC1 prints: Microsoft Windows Actual result: -------------- PHP 5.4.0RC1 crash <?php $z=50;while($z--){ $o=new COM('WinMgmts:',null,CP_UTF8); foreach($o->ExecQuery('SELECT * FROM Win32_OperatingSystem') as $x){ $s=$x->Caption; } } print($s); ?> Previous Comments: ------------------------------------------------------------------------ [2011-11-11 00:07:39] lunter at interia dot pl Confirmed on PHP 5.4.0 RC1, Apache 2.2.21 VC9 Windows 7 32bit Bug introduced in PHP 5.4 PHP 5.3.8 works fine. ------------------------------------------------------------------------ [2011-09-17 15:20:52] ystsoi at yahoo dot com dot hk Description: ------------ When run the following test script, PHP will crash when it tries to get the value of the second cell. The problem will not occur if Cells() is not used within the for-loop. Test script: --------------- <?php $excel = new COM("Excel.Application"); $excel->Workbooks->Open(realpath('test.xls')); $worksheet = $excel->ActiveSheet; for ($j = 1; $j <= 2; $j++) { echo $worksheet->Cells(1, $j)->Value, "\n"; } $excel->Quit(); ?> Expected result: ---------------- The values of A1 and B1 in test.xls will be echoed. Actual result: -------------- Only the value of A1 in test.xls is echoed, then crash. ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=55715&edit=1