CODEWITHSUNDEEP
perlstrawberry-perl
Bharanikumar
Bharanikumar

Reputation: 25733

can't locate spreadsheet writeexcel.pm

i am getting Error

can't locate spreadsheet writeexcel.pm in @inc @inc contains

yes i know, it require the excel plugin,

am using straberry perl,

tell me where i find the excel plugin for PERL, and where shoukld paste that excel plugin

Upvotes: 1

Views: 26769

Answers (2)

ellipse
ellipse

Reputation: 1

If you installed it as root, then you need to execute your script as root as well. This solved the problem for me.

Upvotes: 0

eckes
eckes

Reputation: 67047

You can find the module on CPAN. To install it on strawberry perl interactively, do

perl -MCPAN -e shell
install Spreadsheet::WriteExcel

or (non-interactive)

cpan Spreadsheet::WriteExcel

Edit:

If you get any errors about unfulfilled dependencies (missing modules like OLE::Storage_Lite), install these dependencies using cpan <dependency> and then continue installation of your package.

If you don't need to stick on Strawberry Perl, you could switch over to ActiveState Perl which comes with an integrated package manager (PPM) that installs the required modules (including dependencies). ActiveState provides a repository with pre-built modules, so they don't need to be compiled.

Is @INC really empty? If so, you have to set @INC in order to specify the include directories for perl to search for modules.

Furthermore, I'd expect that the error message would read

can't locate Spreadsheet::WriteExcel.pm ...

if you specified the dependency correctly with use Spreadsheet::WriteExcel;.

Upvotes: 10

Related Questions