Re: processing XL using Win32::OLE

2007-06-28 Thread alok nath
Found a good tutorial here : http://www.perlmonks.org/?node=153486 - Original Message From: alok nath <[EMAIL PROTECTED]> To: beginners@perl.org Sent: Friday, June 29, 2007 10:42:56 AM Subject: processing XL using Win32::OLE Hi, Can anybody tell how to open an already existing x

Re: processing XL using Win32::OLE

2007-06-28 Thread Prabu Ayyappan
Hi Alok, Hope the examples in the below links help your needs. For opening and reading an XL(Excel) use strict; use Win32::OLE qw(in with); use Win32::OLE::Const 'Microsoft Excel'; $Win32::OLE::Warn = 3;# die on errors... # get already active Excel

processing XL using Win32::OLE

2007-06-28 Thread alok nath
Hi, Can anybody tell how to open an already existing xL file and then probabaly do some processing using Win32::OLE I found quite a few examples but none of them open an existing excel file. Or is there some better module for XL processing ? Here is my code .. use strict ; use warnings ; us