in reply to Re: how to Install module Spreadsheet::Read?
in thread how to Install module Spreadsheet::Read?

I tried that , it showed me cannot install Spreadsheet::Read , don't know what it is

  • Comment on Re^2: how to Install module Spreadsheet::Read?

Replies are listed 'Best First'.
Re^3: how to Install module Spreadsheet::Read?
by Corion (Patriarch) on Oct 04, 2016 at 08:50 UTC

    This most likely means that cpanm cannot contact its CPAN database, and that cpan also cannot contact its CPAN mirror to update its listing.

    Consult with your network administrator to find out which proxy address you need to use to make HTTP requests to the outside world.

      ok bit of a problem there. I am working under a proxy and my system administrator told that he can't help me on this. what can I do? PS: I need to read excel files and convert their contents into a hash table. can I use some other module which have less dependencies (as I can install the module by that way : installing all the dependencies in the loop required)

        On my strawberry perl portable under windows with compulsory company proxy it suffices to specify a HTTP_PROXY variable.
        CMD Example: Install Data::Dumper::Concise through proxy
        rem set HTTP_PROXY=http://IP_OF_YOUR_PROXY:PORT_OF_YOUR_PROXY rem e.g.: set HTTP_PROXY=http://192.168.10.20:3128 cpanm Data::Dumper::Concise
        In my case the proxy does not require autentication. If your proxy requires authentication, then it will probably be something like
        set HTTP_PROXY=http://USER:PASSWORD@IP_OF_YOUR_PROXY:PORT_OF_YOUR_PROX +Y

        As Spreadsheet::Read is just a wrapper over *optional* parsers, you can now selectively choose the parser you need. If you want to read recentish Excel (with the .xlsx extension), you's want to install Spreadsheet::ParseXLSX. For older Excel, you'd want Spreadsheet::ParseExcel. You can follow the same steps you took for Spreadsheet::Read and recursively "fix" all dependencies.


        Enjoy, Have FUN! H.Merijn

        Where I work, there is a "transparent proxy". Basically that means that the router between the internal network and the Internet has a rule that diverts outgoing connection attempts to an authorization server. When a site is visited with a web browser, the browser can authenticate to the authorization server, which then sends a new rule to the router, allowing the associated internal IP address to make outbound connections.

        Once that is done, other programs on that PC can make connections until the rule expires.

        If your company's proxy works the same way, then visiting www.cpan.org should make it possible for the cpan command to install a few modules. When it fails, use the browser, again, then retry the cpan command.

Re^3: how to Install module Spreadsheet::Read?
by marto (Cardinal) on Oct 04, 2016 at 08:44 UTC

    "don't know what it is"

    Both cpan and cpanm tell you why installations have failed. cpan directly on screen, cpanm tells you the log file to look at. Please take the time to check these things before posting things like this.

      do you want me to write the whole error window? ok

      could not fetch modules/03modlist.data.gz going to write C:\perl\cpan\metadata warning : cannot install Spreadsheet::Read, don't know what it is try the command i/Spreadsheet::Read/ to find objects with matching quantifiers

      I also tried I/Spreadsheet::Read/ but it showed 'i' is not recognized as an internal or external command operable program or batch file

        "do you want me to write the whole error window? ok"

        Ideally we want you to only post relevant information: How do I post a question effectively?.

        could not fetch modules/03modlist.data.gz

        If you can't access cpan.org (or a mirror) you won't be able to download and install modules. If you don't have internet access you are going to have do create a local cpan mirror using a system which does have internet access and a tool like minicpan. If you do have internet access but need to configure your network access properly see the documentation for each tool which has instructions for doing so. If you don't know what any of this means it's perhaps best to speak to your systems administrator.

        Update:

        "I also tried I/Spreadsheet::Read/ but it showed 'i' is not recognized as an internal or external command operable program or batch file"

        You're supposed to try this within the cpan shell:

        cpan[6]> i /ACME::POE/ Module < Acme::POE::Acronym::Generator (BINGOS/Acme-POE-Acronym-Gener +ator-1.20.tar.gz) Module < Acme::POE::Knee (BINGOS/Acme-POE-Knee-1.12.tar.gz) Module < Acme::POE::Tree (RCAPUTO/Acme-POE-Tree-1.022.tar.gz) 3 items found cpan[7]>
        could not fetch modules/03modlist.data.gz

        Again, you have a network problem, and the interesting part for the diagnosis are above the quoted line. Consult with your network administrator on how you need to configure your machine and the CPAN tool for outside HTTP access.