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

P

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::parseExcel::Workbook->Parse($original_file)

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


Pam
 
P

Pam

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


Hi

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


Pam
 
M

Matt Garrish

Do you know if Spreadsheet::parseExcel 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
 
M

Matt Garrish

Do you know if Spreadsheet::parseExcel 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
 
P

Pam

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

Try it for yourself. See if you can write a perl script that uses
Spreadsheet::parseExcel 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::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 Spreadsheet::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 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::parseExcel to work in my Windows enviroment.
Can someone/anyone point me to some sample code that uses
Spreadsheet:parse excel in Windows enviroment.



Thank You All,
Pamela
 
M

Matt Garrish

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,928
Messages
2,570,068
Members
46,513
Latest member
JacklynMcC

Latest Threads

Top