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

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

by graff (Chancellor)
on Jun 01, 2002 at 04:16 UTC ( #170880=note: print w/replies, xml ) Need Help??


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

I tried installing Spreadsheet::ParseExcel from CPAN on my linux box and it did not install. The place where it failed made me think I should try installing the OLE module from CPAN first, and that failed as well.

I haven't checked the usenet news groups about this yet, and there was nothing in the README file about it, but is it just stupid to attempt this? Is Spreadsheet::ParseExcel inherently non-portable?

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

Replies are listed 'Best First'.
Re: Re: read-excel.pl: a code sample for Spreadsheet::ParseExcel
by da (Friar) on Jun 01, 2002 at 14:49 UTC
    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}
      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...

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (9)
As of 2020-01-20 20:53 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Notices?