#13599 [Com]: drops characters in variable file name

[ge_nildo at uol dot com dot br]

 ID:               13599
 Comment by:       ge_nildo at uol dot com dot br
 Reported By:      alain at sonic dot net
 Status:           Closed
 Bug Type:         COM related
 Operating System: win98
 PHP Version:      4.0CVS-2001-10-08
 New Comment:

I had the some problem. What can I do to fix this problem?



 Thanks,

     Genildo


Previous Comments:
------------------------------------------------------------------------

[2001-10-17 09:11:22] [EMAIL PROTECTED]

fixed in cvs now

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

[2001-10-11 03:31:08] [EMAIL PROTECTED]

these are the implications of an attempt to make the string functions
binary safe :) will be fixed soon.

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

[2001-10-08 12:04:14] alain at sonic dot net

<?php

        #Instantiate Excel

                 $ex = new COM("Excel.sheet") or Die ("Did not
instantiate Excel");

        $ex->Application->Visible = 1; #Make Excel visible. 

        $workbook="test.xls";

        $pathin="c:/";

        $sheet="sheet1";         

        #Load the workbook

        $filename= $pathin.$workbook;

        print $filename;

                # $file=New Variant($filename,VT_BSTR); #This doesn't
work either (replacing $filename by $file)

                        $wkb = $ex->application->Workbooks->Open($filename) or


                        Die ("Did not open $filename");

        #Activate the sheet

$sheets = $wkb->Worksheets($sheet) or Die ("Unable to activate
$sheet");

                        

 ?>

 Produces error message:

 c:/test.xls

Warning: Invoke() failed: Exception occurred. Source: Microsoft Excel
Description: 'c:/tes.xls' could not be found. Check the spelling of the
file name, and verify that the file location is correct. If you are
trying to open the file from your list of most recently used files on
the File menu, make sure that the file has not been renamed, moved, or
deleted. in c:\geolink\testbad.php on line 12

Did not open c:/test.xls

Note: If $workbook="testxx.xls" it will open test.xls ...

But will produce the error below on the 'activate the sheet' code line,
(related or not to the file name error, maybe a second bug?)

Error in php_OLECHAR_to_char() in c:\geolink\testbad.php on line 15 



Setup: win 98 Apache 1.3x as CGI. CVS source compiled at php4win.com on
10-04-2001



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


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