This question about Using an extension: Answered

Can't locate Spreadsheet/WriteExcel.pm in @INC

I have installed the ExcelImportExportPlugin and the prerequisite Perl modules Spreadsheet::Read and Spreadsheet::Write, etc, but am still getting this error message (from apache's error log):

[Wed Aug 18 14:30:24 2010] [error] [client 172.16.20.23] Can't locate Spreadsheet/WriteExcel.pm in @INC (@INC contains: /var/www/foswiki/lib . /etc/perl /usr/local/lib/perl/5.10.0 /usr/local/share/perl/5.10.0 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl /var/www/foswiki/lib/CPAN/lib//arch /var/www/foswiki/lib/CPAN/lib//5.10.0/i486-linux-gnu-thread-multi /var/www/foswiki/lib/CPAN/lib//5.10.0 /var/www/foswiki/lib/CPAN/lib/) at /var/www/foswiki/lib/Foswiki/Plugins/ExcelImportExportPlugin/Export.pm line 22., referer: http://wikinw/bin/view/Interactive/ContentAudit

I have verified that Spreadsheet/WriteExcel.pm is in the /usr/local/lib/perl/5.10.0 folder.

Have I missed a some permission or Perl setting along the way here?


Hi Rob,

if this is the only perl module residing in this path and required by Foswiki, it could make sense that a path issue exists. The important thing on the @INC path is that apache can read it. So you should double check if your apache user is allowed to dive (change) into all the directories along the way down to the module.

Also or even first you should double check if this path is correctly listed in the Foswiki @INC configure section. Go to Foswiki configure and open CGI Setup (read only) then look down until the list of @INC library path and make sure the required path is listed there. If not try adding it to LocalLib.cfg residing in ./foswiki/bin. Add the path to @localPerlLibPath.

In case all this doesn't help you may need to provide additional details.

Regards, -- IngoKappler - 02 Sep 2010

QuestionForm edit

Subject Using an extension
Extension ExcelImportExportPlugin
Version Foswiki 1.0.9
Status Answered
Topic revision: r2 - 02 Sep 2010, IngoKappler
The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License    Legal Imprint    Privacy Policy