Reading XLS files

Elliott has asked for the wisdom of the Perl Monks concerning the following question:

Brethren, It's easy enough to parse an Excel spreadsheet if it's been saved as a tab-delimited file - but anyone know of a script (module, maybe) that can read one in XLS format? Or perhaps I am being too soft on users who are too stupid to understand hwo to save a tab-delimited version!!! May the Great Coder watch over you.

Comment on Reading XLS files

Replies are listed 'Best First'.
Re: Reading XLS files by lshatzer (Friar) on Apr 10, 2002 at 23:56 UTC
You will have to either user OLE module, or Spreadsheet::ParseExcel. Update: Also, Using Win32::OLE and Excel - Tips and Tricks in our very own Tutorials section.	[reply]
Re: Reading XLS files by sfink (Deacon) on Apr 10, 2002 at 23:59 UTC
Search on CPAN. You'll find Spreadsheet::ParseExcel. (I've never tried it).	[reply]
Re: Reading XLS files by cacharbe (Curate) on Apr 11, 2002 at 12:37 UTC
If you are on a Win32 System, there is a new, handy-dandy tutorial in the tutorials section on just this subject. Otherwise I recommend taking lshatzer advice above regarding Spreadsheet::ParseExcel. C-. *Update:* Thanks lshatzer, I'm slow on the draw today. Distracted I guess.	[reply]
Re: Reading XLS files by mrbbking (Hermit) on Apr 10, 2002 at 23:52 UTC
You're going to want a module for that. Take a look at search.cpan.org, and look for "Excel" to get started. `______________________________ s!!password!;y?sordid?binger?; y.paw.mrk.;;print chr 0x5b ;;; print;print chr(0x5b+0x2);;;;;` [download]	[reply] [d/l]
Re: Reading XLS files by kappa (Chaplain) on Apr 11, 2002 at 10:30 UTC
You could also find xls2cvs program useful.	[reply]