Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

Re: Re: read-excel.pl: a code sample for Spreadsheet::ParseExcel

by da (Friar)
on Jun 01, 2002 at 14:49 UTC ( [id://170915]=note: print w/replies, xml ) Need Help??


in reply to Re: read-excel.pl: a code sample for Spreadsheet::ParseExcel
in thread read-excel.pl: a code sample for Spreadsheet::ParseExcel

Yes- it requires OLE::Storage_Lite, as it says near the top of the README:
REQUIREMENT This module requires these modules: OLE::Storage_Lite Jcode.pm (if you are using FmtJapan, or FmtJapan2) Unicode::Map (if you are using FmtJapan2 or FmtUnicode)
I installed both of these using the CPAN module, which is quite useful if you haven't seen it. The CPAN process automates installation nicely; it asks if you want to fulfill unmet dependencies and install OLE::Storage_Lite. I said yes, it installed OK, and I re-ran 'install Spreadsheet::ParseExcel' with no problems.

There could be further dependencies you'd need to install for OLE::Storage_Lite to work; but it's much easier with the CPAN module.

___ -DA $_='daniel@coder.com 519-575-3733 /Prescient Code Solutions/ coder.c +om ';s/-/ /g;s/([.@])/ $1/g;@y=(42*1476312054+7*3,14120504e4,-42*330261-3 +3, 42*5436+3,42*2886+10,42*434987+5);s/(.)/ord(uc($1))/ge;for(@x=split/32 +/; @y; map{print chr} split /(..)/, shift(@x) + shift(@y)) {perlmonk.da.r +u}

Replies are listed 'Best First'.
Re: Re: Re: read-excel.pl: a code sample for Spreadsheet::ParseExcel
by graff (Chancellor) on Jun 01, 2002 at 22:42 UTC
    Thank you. Yes, I always use CPAN. (Pretty soon I'll never be able to do it any other way!)

    Turns out that OLE::Storage_Lite also required IO::Scalar, which I didn't have yet, but once that was in, everything went smoothly. Reading excel spreadsheets from my linux partition will save me a ton of grief!!

      Actually - IO::Scalar is part of packet "io-stringy", thus you have to do " install io.stringy" in PPM. Then there was also a typo in line 19 of ParseExcel.pl (a + and a linebreak right in {MaxCol}. After while: it works...
        Thanks!!! This is exactly what i was looking for! :-D

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://170915]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others avoiding work at the Monastery: (2)
As of 2024-04-20 04:01 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found