<?xml version="1.0" encoding="windows-1252"?>
<node id="584495" title="Re: Excel Add-In in Perl?" created="2006-11-16 10:54:50" updated="2006-11-16 05:54:50">
<type id="11">
note</type>
<author id="33341">
Albannach</author>
<data>
<field name="doctext">
There is one other option [Corion] didn't cover, one which I tend to use because it is very simple, but then it's also fairly limited.  I monitor the Windows clipboard using [cpan://Win32::Clipboard] and then I select and copy cells in Excel, munge them as needed in Perl, and past them back to the clipboard.  From there I can paste the results in Excel anywhere I like.  I have even used the first cell as a "command" to the perl script.  This works well for data cleaning tasks at least, maybe it will be suitable for your needs.

&lt;!-- Node text goes above. Div tags should contain sig only --&gt;
&lt;div class="pmsig"&gt;&lt;div class="pmsig-33341"&gt;
&lt;p&gt;--&lt;br&gt;
I'd like to be able to assign to an luser
&lt;/div&gt;&lt;/div&gt;</field>
<field name="root_node">
584457</field>
<field name="parent_node">
584457</field>
</data>
</node>
