Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Can't locate Spreadsheet/ParseExcel

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Can't locate Spreadsheet/ParseExcel
# 1  
Old 08-27-2012
Can't locate Spreadsheet/ParseExcel
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:

Code:
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?
# 2  
Old 08-28-2012
You may try pushing the path that has spreadsheet module into @INC before you use the module.

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

# 3  
Old 08-29-2012
Quote:
Originally Posted by balajesuri
You may try pushing the path that has spreadsheet module into @INC before you use the module.

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


Hi thanks for your response...


What are common paths for the spreadsheet module?

is it
Code:
(@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:

Code:
/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.
Login or Register to Ask a Question

Previous Thread | Next Thread

7 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

data for spreadsheet

I'm pulling down some LUN usage data once per day. I store the data in a file name that matches the name of the LUN. Then I just append new usage amounts to the same file each day. Filename might be serv01_luna, serv01_lunb, serv01_lunc, etc, etc. Inside the file it would like the following... (7 Replies)
Discussion started by: dwcasey
7 Replies

2. Programming

extract the same format from existing excel file using " Spreadsheet::ParseExcel " module

Hi , can any one tell me,"How to extract the same format from existing excel file to new excel file " using Spreadsheet::WriteExcel or Spreadsheet::ParseExcel module ??? Example_pgm: Below program is used to read existing excel file..In this program "my $cell = $_;" line is used to... (0 Replies)
Discussion started by: kavi.mogu
0 Replies

3. Shell Programming and Scripting

Using Spreadsheet on Perl in UNIX

Very new to UNIX, so still getting used to all this. I made a Perl script where I want to create a spreadsheet file when extracting "data" from a text file. Now, this works perfectly fine on my Windows OS since I'm using the Win32 libraries with Microsoft Excel, but when I want to try it out on... (0 Replies)
Discussion started by: kooshi
0 Replies

4. Shell Programming and Scripting

Trying to send an excel spreadsheet.

And I have to modify this part of the script, I'm not sure what to change the content-type to for this to work, or what else I would need to change here: # This script sends Email acoording to command line arguments. # $1 - file to be attached (full path with name) # $2 - file name as it... (1 Reply)
Discussion started by: NycUnxer
1 Replies

5. AIX

Trying to send an excel spreadsheet.

I may have posted in the wrong section, either way I need some help. And I have to modify this part of the script, I'm not sure what to change the content-type to for this to work, or what else I would need to change here: # This script sends Email acoording to command line arguments. #... (1 Reply)
Discussion started by: NycUnxer
1 Replies

6. Shell Programming and Scripting

how to include spreadsheet::ParseExcel in shell script

Please tell me that how can we include Spreadsheet::ParseExcel module in shell script (1 Reply)
Discussion started by: akash
1 Replies

7. Shell Programming and Scripting

help in Spreadsheet::WriteExcelXML

I want to know that will Spreadsheet::WriteExcelXML coding will work in unix with perl and shell scripting. (1 Reply)
Discussion started by: akash
1 Replies
Login or Register to Ask a Question