Spreadsheet::ParseExcel on Windows with out Win32::OLE

[Pam]

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
Spreadsheet: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 Spreadsheet::WriteExcel,
OLE dosen't seem to work with existing code because one writes to a
sheet 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 spreadsheet with

$oBook = Spreadsheet:arseExcel::Workbook->Parse($original_file)

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


Pam

 

[Pam]

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

Hi

Do you know if Spreadsheet:arseExcel can work on Windows without
using
Win32::OLE?


Pam

 

[Matt Garrish]

Do you know if Spreadsheet:arseExcel can work on Windows without
using
Win32::OLE?

Could you please point out the exact passage in the ParseExcel
documentation where it says that Win32::OLE is required? I'm having
trouble finding it.

Matt

 

[Matt Garrish]

Do you know if Spreadsheet:arseExcel can work on Windows without
using
Win32::OLE?

Could you please point out the exact passage in the ParseExcel
documentation where it says that Win32::OLE is required? I'm having
trouble finding it.

Matt

 

[Pam]

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

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

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 SpreadSheet:arseExcel 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 Spreadsheet:arseExcel 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 Spreadsheet::WriteExcel to put that data into
a sheet and also to do other formating to that spreadsheet. So now I
want to parse that same spreadsheet to see if a cell is defined or
undef.


I can't get Spreadsheet:arseExcel to work in my Windows enviroment.
Can someone/anyone point me to some sample code that uses
Spreadsheetarse excel in Windows enviroment.



Thank You All,
Pamela

 

[Matt Garrish]

It sounds like your main problem is lack of access to the documentation
for Spreadsheet:arseExcel:

http://search.cpan.org/~kwitknr/Spreadsheet-ParseExcel-0.2603/ParseExcel.pm

No, I think her real problem is she doesn't know Perl and she's trying
to hack things together from examples on the web in the hopes something
miraculous will come of it (probably examples that pre-date the
ParseExcel module, from the sound of it). She should take a couple of
steps back and learn some basic Perl (like how to determine if a
variable is defined).

Matt