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



Mumia W. (reading news) wrote:
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


Hello:

My original question stated the I was trying to parse an existing Excel
file and all of the exmples I have seem to specify using on Win32:OLE
for Windows or Spreadsheet_ParseExcel on UNIX/Linux.

I'm not saying that Spread***::ParseExcel has to be used with
Win32::OLE.
I'm saying that when I have looked for sample code it points me to
Win32:OLE for parsing in Windows enviorment.

But I want to use code that will work on Windows or UNIX because the
script will be put on UNIX for the cron job.

I have tried and tried and I can't get the Spread***::ParseExcel to
work in my Windows enviroment. My original script gets its nformation
from a database, that coma seperated data is parsed using Text:CSV I
create a workbook using Spread***::WriteExcel to put that data into
a *** and also to do other formating to that spread***. So now I
want to parse that same spread*** to see if a cell is defined or
undef.


I can't get Spread***::ParseExcel to work in my Windows enviroment.
Can someone/anyone point me to some sample code that uses
Spread***:Parse excel in Windows enviroment.



Thank You All,
Pamela

.