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

On 09/27/2006 11:56 AM, Pam wrote:

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


It sounds like your main problem is lack of access to the documentation for Spread***::ParseExcel:

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

It should also be on your computer. With Linux, when the module is installed, the documentation is also automatically installed. If you have ActiveState Perl for Windows, this is probably also the case.

Search in the Programs menu under Perl or Active State or Modules or other places. Also, you should be able to use the command line utility "perldoc." Open a command prompt and type "perldoc perl" like so:

C:\> perldoc perl

The command "perldoc Spread***::ParseExcel" should show the module's documentation:

C:\> perldoc Spread***::ParseExcel



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