Can't locate Spreadsheet/ParseExcel

Shell Programming and Scripting
1

Hi

I can't seem to figure out why i keep getting this error. the Spreadsheet::PhaseExcel is installed on 3 servers and is working on only 2... the last one it is installed exactly the same way but I keep getting this error.

This is whats odd.

If i run this script as a normal user i get this error:

Can't locate Spreadsheet/ParseExcel.pm in @INC (@INC contains: /usr/opt/perl5/lib/5.8.8/aix-thread-multi /usr/opt/perl5/lib/5.8.8 /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi /usr/opt/perl5/lib/site_perl/5.8.8 /usr/opt/perl5/lib/site_perl .) at process_file.pl line 4.

But if i run it as root the script works. not sure whats going on here any advice?

3

You may try push ing the path that has spreadsheet module into @INC before you use the module.

push (@INC, "/path/to/sprdsht_module/");
use Spreadsheet::PhaseExcel;
4

Hi thanks for your response...

What are common paths for the spreadsheet module?

is it

(@INC contains: /usr/opt/perl5/lib/5.8.8/aix-thread-multi /usr/opt/perl5/lib/5.8.8 /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi /usr/opt/perl5/lib/site_perl/5.8.8 /usr/opt/perl5/lib/site_perl

or what would be key names so I'll do a search for it?

---------- Post updated at 06:23 PM ---------- Previous update was at 06:22 PM ----------

I just did a search for "spreadsheet" and came up with this:

/usr/opt/perl5/lib/site_perl/5.8.8/Spreadsheet
/usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/Spreadsheet
/usr/opt/perl5/man/man3/Spreadsheet::ParseExcel.3
/usr/opt/perl5/man/man3/Spreadsheet::ParseExcel::Cell.3
/usr/opt/perl5/man/man3/Spreadsheet::ParseExcel::Dump.3
/usr/opt/perl5/man/man3/Spreadsheet::ParseExcel::FmtDefault.3
/usr/opt/perl5/man/man3/Spreadsheet::ParseExcel::FmtJapan.3
/usr/opt/perl5/man/man3/Spreadsheet::ParseExcel::FmtJapan2.3
/usr/opt/perl5/man/man3/Spreadsheet::ParseExcel::FmtUnicode.3
/usr/opt/perl5/man/man3/Spreadsheet::ParseExcel::Font.3
/usr/opt/perl5/man/man3/Spreadsheet::ParseExcel::Format.3
/usr/opt/perl5/man/man3/Spreadsheet::ParseExcel::SaveParser.3
/usr/opt/perl5/man/man3/Spreadsheet::ParseExcel::SaveParser::Workbook.3
/usr/opt/perl5/man/man3/Spreadsheet::ParseExcel::SaveParser::Worksheet.3
/usr/opt/perl5/man/man3/Spreadsheet::ParseExcel::Utility.3
/usr/opt/perl5/man/man3/Spreadsheet::ParseExcel::Workbook.3
/usr/opt/perl5/man/man3/Spreadsheet::ParseExcel::Worksheet.3

---------- Post updated 08-29-12 at 03:29 PM ---------- Previous update was 08-28-12 at 06:23 PM ----------

I figured it out!

problem is permissions for Spreadsheet/ParseExcel.pm were set to rwx-- modified them to work for what i needed and poof! I had the modify the additional modules needed for this script as well but basically the same thing.