Spreadsheet::ParseExcel

[chrismassey]

Hello,

I am trying to use an Excel Spreadsheet containing data to be analysed and printed. However, it cannot connect to the module Spreadsheet:arseExcel correctly.

Here is a list of the Spreadsheet modules I have available:

Spreadsheet::ParseExcel::Dump 
Spreadsheet::ParseExcel::FmtDefault 
Spreadsheet::ParseExcel::FmtJapan 
Spreadsheet::ParseExcel::FmtJapan2 
Spreadsheet::ParseExcel::FmtUnicode 
Spreadsheet::ParseExcel::SaveParser::Workbook 
Spreadsheet::ParseExcel::Utility 
Spreadsheet::ParseExcel::Workbook 
Spreadsheet::WriteExcel 
Spreadsheet::WriteExcel::BIFFwriter 
Spreadsheet::WriteExcel::Big 
Spreadsheet::WriteExcel::Format 
Spreadsheet::WriteExcel::Formula 
Spreadsheet::WriteExcel::OLEwriter 
Spreadsheet::WriteExcel::Utility 
Spreadsheet::WriteExcel::Workbook 
Spreadsheet::WriteExcel::WorkbookBig 
Spreadsheet::WriteExcel::Worksheet

Now it seems odd because Spreadsheet:arseExcel isn't on the list although Spreadsheet::WriteExcel is. I assume all the other Spreadsheet:arseExcel module extensions require Spreadsheet:arseExcel to work.

Therefore because Spreadsheet:arseExcel isn't available is that most likely why my script isn't working?

I can post my script if you need, though it looks fine to me.

Chris

 

[PaulTEG]

just install the module, using ppm if on windows, or cpan, even if on *doze or *nix

ppm install Spreadsheet-ParseExcel

perl -MCPAN -e shell
[u][i]cpan>[/i][/u] install Spreadsheet::ParseExcel

Paul
------------------------------------
Spend an hour a week on CPAN, helps cure all known programming ailments ;-)

 

[chrismassey]

Hey thanks Paul,

I'm using a 1and1 web server, and have never installed a module.

Do I add that code to a perl script and run it? Is there any website which will help me install a module to a web server (which isn't owned by me (1and1)).

Thanks, Chris

 

[PaulTEG]

the use lib directive can be useful

Paul
------------------------------------
Spend an hour a week on CPAN, helps cure all known programming ailments ;-)

 

[chrismassey]

Thanks again Paul,

I have had a look into lib and it makes a bit more sense now. However I am still unsure how I would create a script which installs a module into the library.

I came up with this based on what cpan and you said...

perl -MCPAN -e shell
cpan> install Spreadsheet::ParseExcel
use lib CPAN;
BEGIN { unshift(@INC, CPAN) }

Although I know this is entirely wrong. Any further suggestions on what I can do?

Chris

 

[chrismassey]

Okay, heres what I have sort of understood...

1) I need to download and unpack a module from CPAN.
2) I create a directory on my webserver i.e. module_library
3) I upload all the module files to the directory
4) I can then use a module like this i.e.
use TK '/module_library';

Chris

 

[travs69]

You really need to get on a better server. The use lib only goes so far to solve your problems. Some modules are going to require other modules and newer versions of perl. Have you requested 1and1 to install that module? I have never had a host not install modules for me unless it was something required a complete recompile of perl. Most of the time hosting companies install EVERY module that is normally used so that they don't have to worry about things like this. I have used olm.net and ixwebhosting.com and both have been very good to me.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Travis - Those who say it cannot be done are usually interrupted by someone else doing it; Give the wrong symptoms, get the wrong solutions;

 

[chrismassey]

Hey cheers tav,

I wrote them an email and haven't recieved a response yet, other services with 1and1 are very good therefore I would like to stay if they look into installing a later Perl version and if there is a system to install new modules. But if not I will look into a new host.

Chris

 

[PaulTEG]

proper order


Paul
------------------------------------
Spend an hour a week on CPAN, helps cure all known programming ailments ;-)