<?xml version="1.0" encoding="windows-1252"?>
<node id="664649" title="poolboi" created="2008-01-28 03:34:24" updated="2008-03-10 23:07:13">
<type id="15">
user</type>
<author id="664649">
poolboi</author>
<data>
<field name="doctext">


&lt;code&gt;
use Win32::OLE::Const;
use Win32::OLE::Const 'Microsoft Excel';

my $Excel = Win32::OLE-&gt;new("Excel.Application" , sub { $_[0]-&gt;Quit } 
+) 
    or die Win32::OLE::LastError;
$Excel-&gt;{Visible} = 1;

	

my $Book = $Excel-&gt;Workbooks-&gt;Open("C:\\Documents and Settings\\clong\\Desktop\\Convert to Text file\\Quarantined_IMSIHLR2_20070611_Completed1.xls") 
my $Sheet = $Book-&gt;Worksheets(Quarantined_IMSIHLR2_20070611_Completed1);

$Excel-&gt;{DisplayAlerts} = 0;  # avoid being prompted
$Sheet-&gt;SaveAs( { FileName =&gt; "C:\\Documents and Settings\\clong\\Desktop\\Convert to Text file\\test.txt" , FileFormat =&gt; xlText } 
+) 
    or die Win32::OLE::LastError;
$Book-&gt;Close();
$Excel-&gt;Quit;
  &lt;/code&gt;</field>
<field name="lasttime">
2008-06-06 04:28:44</field>
<field name="experience">
74</field>
<field name="user_scratchpad">
672335</field>
<field name="imgsrc">
</field>
<field name="timeformat">
</field>
<field name="numwriteups">
20</field>
<field name="location">
</field>
<field name="timezone">
</field>
<field name="codewrapoff">
</field>
<field name="codewraplength">
</field>
<field name="codeautowrap">
</field>
<field name="codeprefix">
</field>
<field name="codebig">
</field>
</data>
</node>
