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.
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: Excel to Perl
by broquaint (Abbot) on Mar 20, 2002 at 18:40 UTC | |
Re: Excel to Perl
by cacharbe (Curate) on Mar 20, 2002 at 19:23 UTC | |
Use the right tool (was Re: Excel to Perl)
by dragonchild (Archbishop) on Mar 20, 2002 at 18:42 UTC | |
by sabersd (Initiate) on Mar 20, 2002 at 19:14 UTC | |
by dragonchild (Archbishop) on Mar 20, 2002 at 19:19 UTC | |
Re: Excel to Perl
by talexb (Chancellor) on Mar 20, 2002 at 19:01 UTC |
Back to
Seekers of Perl Wisdom