<?xml version="1.0" encoding="windows-1252"?>
<node id="284830" title="Re: Re: Using Win32::OLE and Excel - Tips and Tricks" created="2003-08-19 05:29:36" updated="2005-07-07 15:01:35">
<type id="11">
note</type>
<author id="284828">
EverLast</author>
<data>
<field name="doctext">
Actually, I was faced with the same problem.&lt;p&gt;
After fixing other issues (thank god for PerlMonks!), I found the cure:&lt;p&gt;
&lt;code&gt;
use Win32::OLE qw(CP_UTF8);
...
# Work in unicode!
$Win32::OLE::CP = CP_UTF8;
...
&lt;/code&gt;
You can use Unicode::String to unpack() the string to look at each unicode char (which was what I had to do).
&lt;p&gt;Cheers
&lt;br&gt;

---Lars</field>
<field name="root_node">
153486</field>
<field name="parent_node">
201701</field>
</data>
</node>
