Sponsored Content
Top Forums Shell Programming and Scripting Can't locate Spreadsheet/ParseExcel Post 302693141 by vpundit on Wednesday 29th of August 2012 03:29:19 PM
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.
 

7 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

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. 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

6. 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

7. 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
PMINST(1p)						User Contributed Perl Documentation						PMINST(1p)

NAME
pminst - find modules whose names match this pattern SYNOPSIS
pminst [-s] [-l] [pattern] DESCRIPTION
Without argumnets, show the names of all installed modules. Given a pattern, show all module names that match it. The -l flag will show the full pathname. The -s flag will separate the base directory from @INC from the module portion itself. EXAMPLES
$ pminst (lists all installed modules) $ pminst Carp CGI::Carp Carp $ pminst ^IO:: IO::Socket::INET IO::Socket::UNIX IO::Select IO::Socket IO::Poll IO::Handle IO::Pipe IO::Seekable IO::Dir IO::File $ pminst '(?i)io' IO::Socket::INET IO::Socket::UNIX IO::Select IO::Socket IO::Poll IO::Handle IO::Pipe IO::Seekable IO::Dir IO::File IO Pod::Functions The -s flag provides output with the directory separated by a space: $ pminst -s | sort +1 (lists all modules, sorted by name, but with where they came from) $ oldperl -S pminst -s IO /usr/lib/perl5/i386-linux/5.00404 IO::File /usr/lib/perl5/i386-linux/5.00404 IO::Handle /usr/lib/perl5/i386-linux/5.00404 IO::Pipe /usr/lib/perl5/i386-linux/5.00404 IO::Seekable /usr/lib/perl5/i386-linux/5.00404 IO::Select /usr/lib/perl5/i386-linux/5.00404 IO::Socket /usr/lib/perl5/i386-linux/5.00404 IO /usr/lib/perl5/site_perl LWP::IO /usr/lib/perl5/site_perl LWP::TkIO /usr/lib/perl5/site_perl Tk::HTML::IO /usr/lib/perl5/site_perl Tk::IO /usr/lib/perl5/site_perl IO::Stringy /usr/lib/perl5/site_perl IO::Wrap /usr/lib/perl5/site_perl IO::ScalarArray /usr/lib/perl5/site_perl IO::Scalar /usr/lib/perl5/site_perl IO::Lines /usr/lib/perl5/site_perl IO::WrapTie /usr/lib/perl5/site_perl IO::AtomicFile The -l flag gives full paths: $ filsperl -S pminst -l Thread /usr/local/filsperl/lib/5.00554/i686-linux-thread/Thread/Queue.pm /usr/local/filsperl/lib/5.00554/i686-linux-thread/Thread/Semaphore.pm /usr/local/filsperl/lib/5.00554/i686-linux-thread/Thread/Signal.pm /usr/local/filsperl/lib/5.00554/i686-linux-thread/Thread/Specific.pm /usr/local/filsperl/lib/5.00554/i686-linux-thread/Thread.pm AUTHORS and COPYRIGHTS Copyright (C) 1999 Tom Christiansen. Copyright (C) 2006-2008 Mark Leighton Fisher. This is free software; you can redistribute it and/or modify it under the terms of either: (a) the GNU General Public License as published by the Free Software Foundation; either version 1, or (at your option) any later version, or (b) the Perl "Artistic License". (This is the Perl 5 licensing scheme.) Please note this is a change from the original pmtools-1.00 (still available on CPAN), as pmtools-1.00 were licensed only under the Perl "Artistic License". perl v5.10.1 2010-02-22 PMINST(1p)
All times are GMT -4. The time now is 04:23 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy