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

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.

Replies are listed 'Best First'.
Re^4: how to Install module Spreadsheet::Read?
by ankit.tayal560 (Beadle) on Oct 04, 2016 at 09:29 UTC

    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)

[reply]
[reply]
      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

      [download]
      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

      [download]
[reply]
[d/l]
[select]

      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
[reply]

      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.

[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom