>Sorry if this is a dupe... Had error message on previous attempt..
>
>Good day;
>I am trying to open, read and manipulate Excel data using Perl. I am using
>Perl v5.001.
>
>This is what I've found in various manuals that allows me to open a .xls file:
>-------------------------------------------------------------------------------------------------------------------------------
>
>use Win32;
>use OLE;
>
>$exceldoc = CreateObject OLE 'Excel Application' || die;
>$exceldoc ->{Visible} = 1;
>
>$workbook - $exceldoc->Workbooks->Open ('c:\data\myfile.xls');
>
>-------------------------------------------------------------------------------------------------------------------------------
>The above code opens my spreadsheet!!! (amazing to me!!)
>
>What I'd like to do from here is use Perl to read the column headings and
>the data under those headings so that I can write scripts to use regular
>expressions, etc.- all the great things that Perl can do.
>
>Also, I've tried to use a variable in the "Open" object (myfile.xls) so
>that I can dynamically open each file in the "data" directory. I can't
>seem to get that to work. Is it possible?
>
>I hope I'm not wasting your time with this question, as I can not find any
>other source able to assist. Any help would be greatly appreciated. I hope
>I have given you enough information. If not, please don't hesitate to
>contact me.
>Sincerely,
>Carl
