<?xml version="1.0" encoding="windows-1252"?>
<node id="646383" title="Re: What is the best module for parsing Excel documents" created="2007-10-22 04:50:48" updated="2007-10-22 00:50:48">
<type id="11">
note</type>
<author id="123953">
strat</author>
<data>
<field name="doctext">
&lt;p&gt;If you have Win32::OLE installed (I don't know if this is possible under Cygwin), you could have a look at [636590|ExcelPerl], e.g. convert the file to csv with something like:&lt;/p&gt;
&lt;code&gt;
perl excelPerl.pl -begin "use Text::CSV_XS; $csv = Text::CSV_XS-&gt;new( { binary =&gt; 1 } )" -ane "$csv-&gt;combine(@F); print $csv-&gt;string, $/" -f test.xls &gt; outfile.csv
&lt;/code&gt;
&lt;p&gt;Or if you want to keep the formulas:&lt;/p&gt;
&lt;code&gt;
perl excelPerl.pl -begin "use Text::CSV_XS; $csv = Text::CSV_XS-&gt;new( { binary =&gt; 1 } )" -ane "$csv-&gt;combine( map { $_-&gt;{FormulaLocal} } @C); print $csv-&gt;string, $/" -f test.xls &gt; outfile.csv
&lt;/code&gt;




&lt;!-- Node text goes above. Div tags should contain sig only --&gt;
&lt;div class="pmsig"&gt;&lt;div class="pmsig-123953"&gt;
&lt;P&gt;
Best regards,&lt;BR&gt;
perl -e "s&gt;&gt;*F&gt;e=&gt;y)\*martinF)stronat)=&gt;print,print v8.8.8.32.11.32"
&lt;/div&gt;&lt;/div&gt;</field>
<field name="root_node">
646329</field>
<field name="parent_node">
646329</field>
</data>
</node>
