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

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)

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

Replies are listed 'Best First'.
Re^5: how to Install module Spreadsheet::Read?
by marto (Cardinal) on Oct 04, 2016 at 09:34 UTC
Re^5: how to Install module Spreadsheet::Read?
by rminner (Chaplain) on Oct 04, 2016 at 10:55 UTC
    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
Re^5: how to Install module Spreadsheet::Read?
by Tux (Canon) on Oct 05, 2016 at 08:21 UTC

    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
Re^5: how to Install module Spreadsheet::Read?
by RonW (Parson) on Oct 05, 2016 at 00:04 UTC

    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.