Bug #54353 [Opn->Fbk]: Outputs While trying to call

From: Date: Fri, 07 Feb 2020 08:38:57 +0000
Subject: Bug #54353 [Opn->Fbk]: Outputs While trying to call
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-225419@lists.php.net to get a copy of this message 
Edit report at https://bugs.php.net/bug.php?id=54353&edit=1

 ID:                 54353
 Updated by:         cmb@php.net
 Reported by:        drmorgue at yandex dot ru
 Summary:            Outputs While trying to call
-Status:             Open
+Status:             Feedback
 Type:               Bug
 Package:            COM related
 Operating System:   Windows7/Windows 2008 Server
 PHP Version:        5.5.1
-Assigned To:        
+Assigned To:        cmb
 Block user comment: N
 Private report:     N

 New Comment:

This doesn't look like a PHP issue.  Please try the following
variant:

<?php
$x = new COM("Excel.Application");
$x->Application->Visible = 1;
$wb = $x->Workbooks->Add();
$x->ActiveSheet->StandardWidth = 5;
$r = $x->Range("a:a");
$r->Select();
$rc = $x->Selection();
$rc->ColumnWidth = 50;
$wb->SaveAs("c:/1.xls");
$x->Quit();
$x->Release();
$x = Null;
$r = Null;
?>


Previous Comments:
------------------------------------------------------------------------
[2013-08-01 22:52:51] yohgaki@php.net

Under Windows 7 Ultimate(32bit) & Office 2013's Excel & PHP 5.5.1, I got 
different error. (I changed save path to c:\php, since it raise write error)

C:\php>php t.php
PHP Fatal error:  Uncaught exception 'com_exception' with message 'Error 
[0x80020003] メンバーが見つかりません。
' in C:\php\t.php:12
Stack trace:
#0 C:\php\t.php(12): com->Release()
#1 {main}
  thrown in C:\php\t.php on line 12

Fatal error: Uncaught exception 'com_exception' with message 'Error [0x80020003] 
メンバーが見つかりません。 ("Cannot find
member" in English)
' in C:\php\t.php:12
Stack trace:
#0 C:\php\t.php(12): com->Release()
#1 {main}
  thrown in C:\php\t.php on line 12

------------------------------------------------------------------------
[2011-03-22 18:10:05] drmorgue at yandex dot ru

Description:
------------
On my WinXP computer with Office 2003 all work correctly, php-script (see it in 
section 'test script') generates ms-excel file 1.xls. But on the computer with 
windows2008server this php-script generates an error: 

Fatal error: Uncaught exception 'com_exception' with message
'<b>Source:</b> 
Microsoft Office Excel<br/><b>Description:</b>
Невозможно получить
свойство Save 
класса Workbook' in C:\www\prj\1.php:12 Stack trace: #0 C:\www\prj\1.php(9): 
variant->Save() #1 {main} thrown in C:\www\prj\1.php on line 9

My php installed as an apache handler.

How to solve it?

Test script:
---------------
$x = new COM("Excel.Application");
$x->Application->Visible = 1;
$x->Workbooks->Add();
$x->ActiveSheet->StandardWidth = 5;
$r = $x->Range("a:a");
$r->Select();
$rc = $x->Selection();
$rc->ColumnWidth = 50;
$x->Workbooks[1]->SaveAs("c:/1.xls");
$x->Quit();
$x->Release();
$x = Null;
$r = Null;

Expected result:
----------------
File 1.xls must be generated and saved into C:\

Actual result:
--------------
Fatal error: Uncaught exception 'com_exception' with message
'<b>Source:</b> 
Microsoft Office Excel<br/><b>Description:</b>
Невозможно получить
свойство Save 
класса Workbook' in C:\www\prj\1.php:12 Stack trace: #0 C:\www\prj\1.php(9): 
variant->Save() #1 {main} thrown in C:\www\prj\1.php on line 9


------------------------------------------------------------------------



--
Edit this bug report at https://bugs.php.net/bug.php?id=54353&edit=1

Thread (4 messages)

« previous php.bugs (#225419) next »