<?xml version="1.0" encoding="windows-1252"?>
<node id="153068" title="Excel to Perl" created="2002-03-20 13:36:03" updated="2005-08-05 01:31:07">
<type id="115">
perlquestion</type>
<author id="153029">
sabersd</author>
<data>
<field name="doctext">
I have about 75 excel workbooks and about 5 to 10  more coming in each week.  I need to convert these files to a tab delimited format, so they can be picked up by another perl program that updates or inserts records into a database.  The workbooks all have at least 2 worksheets and up to 5.  The first worksheet is to be ignored.  I have been looking at the Win32::OLE module, but can't really figure it out yet.  I am learning perl on the go.  I would like to be able to point to a directory and run all .xls files found there.  I would also like only one tab delimited file to be written per execusion.  Not sure if this is possible.  Any suggestions would be greatly appreciated.</field>
</data>
</node>
