problem with excel_reader2.php

[GoogleCodeExporter]

after several months without problems

an error appears on the function: OLERead ()

"Deprecated: Assigning The return value of new by reference is deprecated in / 
home/ach/public_html/01_www/googlemaps/admin/lib/Excel/reader.php on line 916
The filename .. / .. / gmaps / gmaps.xls is Not readable "

Line 916: $ this-> _ole OLERead = & new ();

No longer works on php 5.2.11 (production server) and 5.3.2-2 (test server) on 
two different servers

same error with the example for download with the error:

"Deprecated: Assigning The return value of new by reference is deprecated in / 
home/ach/public_html/01_www/php-excel-reader-2.21/excel_reader2.php on line 916

Deprecated: Function Split () is deprecated in / 
home/ach/public_html/01_www/php-excel-reader-2.21/excel_reader2.php on line 844

Deprecated: Function Split () is deprecated in / 
home/ach/public_html/01_www/php-excel-reader-2.21/excel_reader2.php on line 844

... "

Original issue reported on code.google.com by ache...@gmail.com on 6 Oct 2010 at 5:20

Attachments:

• reader.php

[GoogleCodeExporter]

Hi!
I have the same error. 
Do you know the reason and how to fix it?

Regards,
Miguel.

Original comment by paniagua...@gmail.com on 3 Nov 2010 at 8:36

[GoogleCodeExporter]

Again here.

My problem was that the FULL path to the file was too long.
In my case, files are always in the same folder [xls/].
I take the FULL path Explode it and take the last token.

$file="/home/user/main/xls/file.xls"; 
$tokens=explode('/',$file);
$the_file=array_pop($tokens);
echo $the_file;

It'd give us
file.xls

Original comment by paniagua...@gmail.com on 3 Nov 2010 at 12:05

[GoogleCodeExporter]

correct the line 916 : $this-> _ole OLERead = & new ();
 by                  : $this->_ole = new OLERead();

Original comment by ache...@gmail.com on 3 Nov 2010 at 1:21

[GoogleCodeExporter]

to solve line 916: $this->_ole =& new OLERead();  (it's Deprecated "=&" , put 
only "=") 
          $this->_ole = new OLERead();

to solve line 844 (and other with split like):   $parts = split(";",$format); 
Split it's been Deprecated use instead "explode":$parts = explode(";",$format); 

Original comment by emiliano...@gmail.com on 5 Nov 2010 at 5:38

[GoogleCodeExporter]

brilliant.. the replacement worked like a charm... 
thanks emiliano

Original comment by v.athani...@gmail.com on 23 May 2011 at 2:23

[GoogleCodeExporter]

To replace this line

$this->_ole = new OLERead();

Original comment by sahulham...@gmail.com on 29 Mar 2012 at 7:06

[GoogleCodeExporter]

help me please!!!!!and sorry for may bad English
I fix all the you recomend, 
I use this class for my file, look my out:
Notice: Uninitialized string offset: 151052498 in 
D:\work\project.md\public\intro\excel-reader-2\excel_reader2.php on line 917
I't understend fix it! 
I attach my problems excel

Original comment by moldoven...@gmail.com on 6 Jun 2012 at 3:15

Attachments:

• о-final.xls

[GoogleCodeExporter]

Hi there..

I have tried the above mentioned fixes.

However it is not working... below are the errors are that i get.

Assigning the return value of new by reference is deprecated

.phpLine Number: 917

Hoping for a solution please help!!!

Original comment by hasansal...@gmail.com on 15 Jul 2012 at 6:15

[GoogleCodeExporter]

Thaaaaanks :)

Original comment by Rtri...@gmail.com on 8 Oct 2012 at 9:27

[GoogleCodeExporter]

To replace this line

$this->_ole = new OLERead();

i can import ...thanks 

Original comment by ngras...@gmail.com on 7 Dec 2012 at 8:21

[GoogleCodeExporter]

thanks, now it's working for me.......

Original comment by muhammad...@gmail.com on 3 May 2013 at 7:10

[GoogleCodeExporter]

when i use the code $this->_ole = new OLERead(); 
the code still error : The filename C:\Users\ACER\xampp\tmp\php4DE0.tmp is not 
readable

anyone please help me.thanks

Original comment by pensilh...@gmail.com on 6 Jul 2013 at 7:42

[GoogleCodeExporter]

i had the same problem (is not readable), just try to change to a relative path 
instead of absolute.

Original comment by rosendo....@gmail.com on 20 Sep 2013 at 8:28

[GoogleCodeExporter]

I have the same problem, file is not readable. I checked the line 916 and it's 
already $this->_ole = new OLERead(); so I don't think the problem is there... 
Any suggestions?

Original comment by glaucima...@gmail.com on 21 May 2014 at 7:13

[GoogleCodeExporter]

#14
specify the absolute path to the file and check the permissions for files

Original comment by my.site....@gmail.com on 27 May 2014 at 2:48

[GoogleCodeExporter]

Please replace "split" with "explode"
http://php.net/explode

Original comment by anggola....@gmail.com on 20 Jan 2015 at 12:20

Attachments:

• excel_reader2.php