Recent changes to bugs

#77 php7 compatibility

2018-09-18T21:33:22.191000Z

Hi. I have a tool using this code and the host updated PHP to version 7.2, from 5.6. The tool is no longer working, of course. I've modified following the comment above but I get an error on Line 31 saying this:

Fatal error: require_once(): Failed opening required 'oleread.inc' (include_path='.:/usr/lib/php7.2') in /homepages/41/d487880956/htdocs/slotcarcorner/php2/reader.php on line 31

I have no experience with code and I no longer have access to the guy who put this together for me. Can someone help me? Thank you.

php7 compatibility

2017-09-29T08:09:28.248000Z

some Minor Update have to be done to get this thing to php7:

reader.php
L31:
old: require_once 'Spreadsheet/Excel/Reader/OLERead.php';
new: require_once 'oleread.inc';

L259:
old: function Spreadsheet_Excel_Reader()
new: function __construct()

L261:
old: $this->_ole =& new OLERead();
new: $this->_ole = new OLERead();

;)

Custom Data Format Problem

2012-05-01T21:06:17Z

Hello,
I'm trying to read a custom date/time format:

01/01/2012 00:15:00

When I read it I get values like:

40909.0104167

It's a date/time value, how can I read it properly?
I even tried to set the setColumnFormat to "%s" in order to get a string instead of a float but I get the same thing.

Thank you.

Infinite while loop

2012-04-02T14:29:32Z

With the current version:

unzip phpExcelReader.zip
vi Excel/reader.php
# change require_once to 'Excel/oleread.inc';

php example.php ----- infinite while loop
php example2.php ---- infinite while loop

it appears to get stuck in __readData's while loop as $block always equals 0.....

numRows displays as zero

2012-03-29T08:46:46Z

When I try to get numrows its giving me zero.actual rows are 50000.
For other excel its working..........just uploaded sample file of 10 rows

numRows displays as zero

2012-03-29T07:44:03Z

When I try to get numrows its giving me zero.actual rows are 50000.
For other excel its working..........just uploaded sample file of 10 rows

blank page

2011-09-02T22:09:12Z

I've a script that work fine, but when i upload files to webhosting, the script go to blank page. the problem? php.ini? i don't know

Problem in date format

2010-11-20T07:10:46Z

Hello there,

I realise while coding that if we have m/d/yyyy (default format) in any date formated cell,
then it will show me wrong date for the date below 12 of any month any year...
i.e. for date 5/9/2010(m/d/yyyy) the script will parse as 10-05-2010(dd-mm-yyyy)...

When i tracking the code i have seen that there is no deafult indexCode for date format m/d/yyyy...
(See : in file reader.php->line no.209->array $dateFormats)

Can i have list of index code for default date format used by Excel???

Or please give me the solution for that....

Wrong text is read from a cell

2010-08-21T16:28:57Z

We have noticed a very strange bug. Our customer sent us an order in Excel form and one of the cells is read incorrectly, more exactly first part of the text is truncated. The correct text is "'P2i1869378=154118693780020003=254=33 Санкт-Петербург=exist.ru" and what reader gets is "3 Санкт-Петербург=exist.ru".

I don't want to upload the order here for public access, but I can send it to you if you contact me via email or somehow else.
My email is register at bazanov dothere net
s-k-y-p-e is megosuyaya

problem with encoding

2010-03-18T12:34:42Z

Hello,
if i've this text
"VERBATIM CD-R 52x Datalife škatlici"
PHP-ExcelReader read only "VERBATIM CD-R 52x Datalife "

There are a problem with š,č, ž