<?xml version="1.0" encoding="utf-8"?>
<feed xml:lang="en" xmlns="http://www.w3.org/2005/Atom"><title>Recent changes to support-requests</title><link href="https://sourceforge.net/p/phpexcelreader/support-requests/" rel="alternate"/><link href="https://sourceforge.net/p/phpexcelreader/support-requests/feed.atom" rel="self"/><id>https://sourceforge.net/p/phpexcelreader/support-requests/</id><updated>2015-11-20T17:11:25.404000Z</updated><subtitle>Recent changes to support-requests</subtitle><entry><title>#16  Uninitialized string offset: Excel/oleread.inc on line 27</title><link href="https://sourceforge.net/p/phpexcelreader/support-requests/16/?limit=25#6743" rel="alternate"/><published>2015-11-20T17:11:25.404000Z</published><updated>2015-11-20T17:11:25.404000Z</updated><author><name>bob82604</name><uri>https://sourceforge.net/u/bob82604/</uri></author><id>https://sourceforge.net4622051af0ef2cb1945ac2ed1018146e0f36466e</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;I am also getting a slew of  Undefined index: Excel/oleread.inc on line 138&lt;br/&gt;
$sbdBlock = $this-&amp;gt;bigBlockChain&lt;span&gt;[$sbdBlock]&lt;/span&gt;;&lt;/p&gt;
&lt;p&gt;Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 32 bytes) : Excel/oleread.inc on line 27&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title> Uninitialized string offset: Excel/oleread.inc on line 27</title><link href="https://sourceforge.net/p/phpexcelreader/support-requests/16/" rel="alternate"/><published>2015-11-20T16:52:43.487000Z</published><updated>2015-11-20T16:52:43.487000Z</updated><author><name>bob82604</name><uri>https://sourceforge.net/u/bob82604/</uri></author><id>https://sourceforge.net62344ec0812886dc3fd67525f5fbc5c4a1308860</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;I am receiving the above erron when attempting to run the example.&lt;/p&gt;
&lt;p&gt;code:------------------------------------------------------&lt;/p&gt;
&lt;blockquote&gt;
&lt;blockquote&gt;
&lt;blockquote&gt;
&lt;blockquote&gt;
&lt;blockquote&gt;
&lt;blockquote&gt;
&lt;blockquote&gt;
&lt;p&gt;function GetInt4d($data, $pos) {&lt;br/&gt;
line 27 &amp;gt;&amp;gt;        return ord($data&lt;span&gt;[$pos]&lt;/span&gt;) | (ord($data&lt;span&gt;[$pos+1]&lt;/span&gt;) &amp;lt;&amp;lt; 8) | (ord($data&lt;span&gt;[$pos+2]&lt;/span&gt;) &amp;lt;&amp;lt; 16) |&lt;br/&gt;
(ord($data&lt;span&gt;[$pos+3]&lt;/span&gt;) &amp;lt;&amp;lt; 24); &lt;br/&gt;
??????&amp;gt;&amp;gt;}&lt;br/&gt;
end code:--------------------------------------------------&lt;/p&gt;
&lt;/blockquote&gt;
&lt;/blockquote&gt;
&lt;/blockquote&gt;
&lt;/blockquote&gt;
&lt;/blockquote&gt;
&lt;/blockquote&gt;
&lt;/blockquote&gt;
&lt;p&gt;Is there a setting on my server that I needd to make?&lt;/p&gt;
&lt;p&gt;My server has PHP 5&lt;br/&gt;
Does this work under PHP5?&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>it cant read xlsx file</title><link href="https://sourceforge.net/p/phpexcelreader/support-requests/15/" rel="alternate"/><published>2013-04-12T12:30:20Z</published><updated>2013-04-12T12:30:20Z</updated><author><name>stalin</name><uri>https://sourceforge.net/u/srstalin/</uri></author><id>https://sourceforge.netf93eaf1435a2dbe419d18fee309be9e72e41b2de</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;I am using PHPExcelReader to read uploaded xls file. But I am not able to read xlsx files saved in excel-2007 format. can someone help me on how to read xlsx file in PHP.&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Number as text</title><link href="https://sourceforge.net/p/phpexcelreader/support-requests/14/" rel="alternate"/><published>2011-07-17T20:25:06Z</published><updated>2011-07-17T20:25:06Z</updated><author><name>Tommas</name><uri>https://sourceforge.net/u/temassano/</uri></author><id>https://sourceforge.netb0c7b8f2e86f34d9567b7a6ca659b2445ffe5d66</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;I have an XLS that has a column where the “number is stored as text”.&lt;/p&gt;
&lt;p&gt;PHP reader is clipping off the right two digits. So on the spreadsheet 1234 becomes 12, or 123 becomes 1.&lt;/p&gt;
&lt;p&gt;How to I correct this? This is for an application where no computer literate people will be using it, they would be challenged to convert it to a csv.&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Expontial Format when reading cell value</title><link href="https://sourceforge.net/p/phpexcelreader/support-requests/13/" rel="alternate"/><published>2009-08-04T12:05:18Z</published><updated>2009-08-04T12:05:18Z</updated><author><name>Anonymous</name><uri>https://sourceforge.net/u/userid-None/</uri></author><id>https://sourceforge.net8116485ce030fdf930181f63b71e4d9f2e6d4521</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Hi,&lt;/p&gt;
&lt;p&gt;i realy enjoy the simple usage of the excle reader but i have a problem when my php scripts reads some cell values.&lt;/p&gt;
&lt;p&gt;Some of my Files contain values like 20090609003416 but when i read the cell which contains this value i get somthing like 2.00906090034E+13 is it possible to read the right value or to format the output right?&lt;/p&gt;
&lt;p&gt;Thanks for help.&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Cell color</title><link href="https://sourceforge.net/p/phpexcelreader/support-requests/12/" rel="alternate"/><published>2009-08-03T20:33:59Z</published><updated>2009-08-03T20:33:59Z</updated><author><name>Anonymous</name><uri>https://sourceforge.net/u/userid-None/</uri></author><id>https://sourceforge.net71ac39bb8917e53ffa355f4ae16940b56ac933d7</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Hi!&lt;/p&gt;
&lt;p&gt;How can i get the background color of a cell ? This is possible ? I read more forums and i search this tip in google but anybody can i help me.&lt;/p&gt;
&lt;p&gt;Regards.&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Problem in Reading MM/DD/YYYY Date Format</title><link href="https://sourceforge.net/p/phpexcelreader/support-requests/11/" rel="alternate"/><published>2008-07-18T21:55:37Z</published><updated>2008-07-18T21:55:37Z</updated><author><name>Sakthikumar B</name><uri>https://sourceforge.net/u/sakthibkumar/</uri></author><id>https://sourceforge.net3f792489e9413787bcdfcf1a2b69a0339ba4395b</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;I am trying to read a Excel file with Some Dates in different formats.&lt;/p&gt;
&lt;p&gt;I tried this in different environments with combinations of &lt;br /&gt;
1. Apache/Linux&lt;br /&gt;
2. Apache/Windows&lt;br /&gt;
3. IIS/Windows.&lt;/p&gt;
&lt;p&gt;I got a successive output from first two environments, but fails in IIS/Windows Environment.&lt;/p&gt;
&lt;p&gt;For example, If my Input is 12/1/1972 (MM/DD/YYYY), first two environments returns 01/12/1972 (I need to perform some replace here to get 12/01/1972), but in IIS/Windows environment I got totally different output as 30/11/1972.&lt;/p&gt;
&lt;p&gt;Kindly let me know the way to handle this.&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Problem with Greek Caracters</title><link href="https://sourceforge.net/p/phpexcelreader/support-requests/10/" rel="alternate"/><published>2007-11-09T15:29:47Z</published><updated>2007-11-09T15:29:47Z</updated><author><name>Anonymous</name><uri>https://sourceforge.net/u/userid-None/</uri></author><id>https://sourceforge.net5a0682e68ef9f8e9cf533ac7048608d85bc1ebaa</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Hello,&lt;/p&gt;
&lt;p&gt;Thanks for the app. It's great.&lt;/p&gt;
&lt;p&gt;Except one thing: i can't get it to read and encode greek characters properly.&lt;/p&gt;
&lt;p&gt;Is there any thing special to do to get it to work?&lt;/p&gt;
&lt;p&gt;I tried to use this: $data-&amp;gt;setOutputEncoding('iso-8859-7'); But it didn't work.&lt;/p&gt;
&lt;p&gt;Thanks in advance,&lt;/p&gt;
&lt;p&gt;Yannick&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>error : memorry exhausted</title><link href="https://sourceforge.net/p/phpexcelreader/support-requests/9/" rel="alternate"/><published>2007-08-04T07:51:12Z</published><updated>2007-08-04T07:51:12Z</updated><author><name>Anonymous</name><uri>https://sourceforge.net/u/userid-None/</uri></author><id>https://sourceforge.netd6a9589a83b17465731d5a10952766a5db7c52c0</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Hi,&lt;/p&gt;
&lt;p&gt;I am on an 64bit x86 server with Linux, PHP 4.4 with Zend optimizer. I am using the current file from SVN. Now getting the error.&lt;/p&gt;
&lt;p&gt;Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 512 bytes) in /home/hdjosh/public_html/xls-read/Excel/oleread.inc on line 172.&lt;/p&gt;
&lt;p&gt;Thanks in advance for any solution.&lt;/p&gt;
&lt;p&gt;regards&lt;br /&gt;
Susen&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Conversion error</title><link href="https://sourceforge.net/p/phpexcelreader/support-requests/8/" rel="alternate"/><published>2006-12-13T03:21:58Z</published><updated>2006-12-13T03:21:58Z</updated><author><name>Paul</name><uri>https://sourceforge.net/u/pkoutrakis/</uri></author><id>https://sourceforge.neta3bff70a4f471e89c3b2757c6fbdcb0670d1e940</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Have been using excelreader for a while now with no issues at all (ps .. thank you all for an incredible product!!!)&lt;/p&gt;
&lt;p&gt;Today it started converting cells with zeros (full zero value, not numbers with zeros in them) to 253 .. In other words, any cell with a value of zero became a value of 253.&lt;/p&gt;
&lt;p&gt;The excel file is the same file used all along (it's an inventory file that the distributor sends) and everything looks correct when viewing it in excel.&lt;/p&gt;
&lt;p&gt;Any ideas ?&lt;/p&gt;
&lt;p&gt;Thanks&lt;/p&gt;&lt;/div&gt;</summary></entry></feed>