Are you in fact using the same Perl executable for both command line and CGI? If not, that would explain your problems. The @INC looks like a system Perl, which would not normally look for modules in your personal directory.

If you are using the system Perl, you should use the system's package manager to install modules. Using the cpan client (or its variants) can cause considerable grief, as I have learned from sad experience, and as you may be learning now. If there is no package for this module, you should probably custom-build your own Perl, and that's not a bad idea anyway, as the previous responder pointed out.

If you are using a custom-built Perl, did you install it in a system-wide directory and then take the local::lib installer option when you initialized CPAN? You want the sudo option in this case.

In reply to Re: Apache/CGI fcould not use Spreadsheet::ParseExcel by Anonymous Monk
in thread Apache/CGI fcould not use Spreadsheet::ParseExcel by PhillipHuang

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.