Re: Spread***::ParseExcel on Windows with out Win32::OLE

On 09/26/2006 06:11 PM, Pam wrote:
Mumia W. (reading news) wrote:
On 09/26/2006 04:34 PM, Pam wrote:
Hello:

I was wondering if anyone knew if it was possible to Parse a file in
the Windows
enviroment without using the Win32::OLE? Most of the sample code I see
is either
writen for UNIX/Linux or Win32:OLE. Currently I have a Perl script
running on Unix
on a cron job that works fine and I wrote it in the Windows enviroment
but used the
Spread***:WriteExcel module and other modules which also works in the
UNIX enviroment. Now I am trying to add more code that will parse the
file for a value. But I am having the hardest time I work in the
Windows enviroment and the code is put on UNIX by another group so
right now I don't have access to UNIX so my code must be written in
Windows. Since previous code was writen using Spread***::WriteExcel,
OLE dosen't seem to work with existing code because one writes to a
*** and Win32::OLE uses Workbook at least that is my conclusion from
all of my efforts in trying to get my code working. I am trying to
parse an existing spread*** with

$oBook = Spread***::ParseExcel::Workbook->Parse($original_file)

Am I correct in my conclusions? If anyone can answer this I would
greatly appreciate it.


Pam

You are correct. Win32::OLE most probably won't work with code written
for Spread***::{Parse,Write}Excel.

--
paduille.4058.mumia.w@xxxxxxxxxxxxx


Hi

Do you know if Spread***::ParseExcel can work on Windows without
using Win32::OLE?


Pam


I've had no experience with Spread***::ParseExcel outside of Linux. However, there is a 99% + 1% chance that Spread***::ParseExcel has no dependency upon Win32::OLE since Win32::OLE only works under Windows, and Spread***::ParseExcel doesn't only work under Windows.

Try it for yourself. See if you can write a perl script that uses Spread***::ParseExcel and not Win32::OLE to parse an Excel file.


--
paduille.4058.mumia.w@xxxxxxxxxxxxx
.