sabersd has asked for the wisdom of the Perl Monks concerning the following question:
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.