<?xml version="1.0" encoding="windows-1252"?>
<node id="1002378" title="Re: Weird excel parsing problem" created="2012-11-05 13:54:04" updated="2012-11-05 13:54:04">
<type id="11">
note</type>
<author id="171588">
BrowserUk</author>
<data>
<field name="doctext">
&lt;blockquote&gt;&lt;i&gt;Any ideas what can cause such a problems ?? &lt;/i&gt;&lt;/blockquote&gt;

&lt;p&gt;You are almost certainly suffering from whitespace differences.

&lt;p&gt;Try printing both values like this:&lt;code&gt;
print "'$ray' '$worksheet-&gt;{Cells}[$row][1]-&gt;{Val}'"; ## Pay special attention to the quotes
&lt;/code&gt;

&lt;p&gt;With this quoting, the issue should become obvious.

&lt;div class="pmsig"&gt;&lt;div class="pmsig-171588"&gt;
&lt;hr /&gt;
&lt;font size=1 &gt;
&lt;div&gt;With the rise and rise of 'Social' network sites: 'Computers are making people easier to use everyday'&lt;/div&gt;
&lt;div&gt;Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.&lt;/div&gt;
&lt;div&gt;"Science is about questioning the status quo. Questioning authority". &lt;/div&gt;
&lt;div&gt;In the absence of evidence, opinion is indistinguishable from prejudice.
&lt;p align=right&gt; [http://thebottomline.cpaaustralia.com.au/|RIP Neil Armstrong]&lt;/p&gt;&lt;/div&gt;
&lt;/font&gt;

&lt;/div&gt;&lt;/div&gt;

</field>
<field name="root_node">
1002373</field>
<field name="parent_node">
1002373</field>
</data>
</node>
