Failed to open stream

Hi,

I really hope someone can help me. I'm new to writing PHP scripts. I've been trying to use this class for the last 4 hours but couldn't get it to work. I've downloaded the excel.php, download & export examples into one folder. I've also created a file example.xls in the same folder as well as in another folder called tmp. By the way, I'm using Maguma Studio 1.3.3 and xampp.

I tried running both the download & export examples but got the following errors:

PHP Warning: readfile(xlsfile://tmp/example.xls): failed to open stream: "xlsstream::stream_open" call failed in C:\Documents and Settings\-\My Documents\readexcel2\~scp.php on line 18

Cannot open xlsfile://tmp/example.xlsPHP Warning: fopen(xlsfile://tmp/example.xls): failed to open stream: "xlsstream::stream_open" call failed in C:\Documents and Settings\-\My Documents\readexcel2\~scp.php on line 11

Really hope someone can help me...thanks

The reason is... You're trying to write/read a unix compliant directory, not win32.

xlsfile://tmp/example.xls "/tmp/example.xls" isn't a valid windows path, You need to use, for example... C:/example.xls

My post "is not" for solving your problem!

But if you want to create a complicated excel file see
“Alternative MS-Excel Classes
If you're looking for an Excel class to do more...”
thread in this forum.

I’m using the PEAR package and I’m very happy because handling information is much easier. The installation of PEAR and package is simple too!

This is probably 7 months too late, but for anyone else who is experiencing this problem (as I just was), the problem is in the stream_open() function. The first thing it does is parse $path as a url then it does this:
$this->xlsfilename = '/' . $url['host'] . $url['path'];
presuming that the specified file path is an absolute path, hence the prepending of the root ('/') to the filename. Simply remove the "'/' ." so the line is:
$this->xlsfilename = $url['host'] . $url['path'];
And this will allow users to open files as relative or absolute paths. E.g.,
readfile('xlsfile://./example.xls');
or
readfile('xlsfile://c:/foo/bar.xls');

Obviously, this is all only for Windows systems.

the class doesn't recognize "./". If you give the path as "xlsfile://./file.xls", it creates a file at the root path(for ex. "c:\file.xls").

Thanks. My problem is solved using ur technique.

Can u send me ur code as sample

Yep, removing '/' worked here too :D thanks!

Try removing the @ in the following code in the function stream_open.
$this->fp = @fopen($this->xlsfilename, $this->mode);

This will give more exact error code.

If you code like below in window 2003 server,

$fp = fopen('xlsfile://./temp/bar.xls',"wb");

it will open the file bar.xls in C:\temp directory.

After 2 days of going over this excel.php file I finally found out what is causing this problem. It has to do with the way the php fucntion PARSE_URL works.

For a better understanding of how this function works, refer to the following URL:
us3.php.net/parse_url

$url = 'http://username:password@hostname/path?arg=value#anchor';
$myParsedArray = parse_url($url);

In short, that will return this array:
Array
(
[scheme] => http
[host] => hostname
[user] => username
[pass] => password
[path] => /path
[query] => arg=value
[fragment] => anchor
)

So in excel.php in the stream_open function, at line 74:
$this->xlsfilename = $url['host'] . $url['path'];
If for instance you passed it:
"xlsfile://C:/example.xls"

xlsfilename = C/example.xls

Notice the missing : after C

To fix this problem, change line 74 to:
$this->xlsfilename = $url['host'] . ":" . $url['path'];