<?xml version="1.0" encoding="windows-1252"?>
<node id="511489" title="Re: Using Win32::OLE and Excel - Tips and Tricks" created="2005-11-24 12:58:53" updated="2005-11-24 07:58:53">
<type id="11">
note</type>
<author id="511485">
iamaids</author>
<data>
<field name="doctext">
Thanks for the article. The following code doesn't work on my machine:

&lt;code&gt;
     my @edges = qw (xlEdgeBottom xlEdgeLeft xlEdgeRight xlEdgeTop xlI
+nsideHorizontal xlInsideVertical);
     $range = "b1:c56"; 
     foreach my $edge (@edges){
     with (my $Borders = $Sheet-&gt;Range($range)-&gt;Borders(eval($edge)), 
             LineStyle =&gt;xlContinuous,
             Weight =&gt; xlThin ,
             ColorIndex =&gt; 1);
     } 
&lt;/code&gt;

I'm using ActivePerl 5.8.7. No error messages were encountered.

Thanks in advance.</field>
<field name="root_node">
153486</field>
<field name="parent_node">
153486</field>
</data>
</node>
