Home > Archive > PERL Modules > August 2007 > Error in Spreadsheet module
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Error in Spreadsheet module
|
|
| Santana 2007-08-09, 4:00 am |
| Error in Spreadsheet module
Hei friends,
i'am new in newbie in Perl, and i try i convert a excel file in csv
file in Suse 10.0 linux.
I install the Spreadsheet-ParseExcel-0.32.tar.gz module in my linux
but when i try run this script :
use strict;
use Spreadsheet::ParseExcel;
my $excel =3D Spreadsheet::ParseExcel::Workbook->Parse($file);
foreach my $sheet (@{$excel->{Worksheet}}) {
printf("Sheet: %s\n", $sheet->{Name});
$sheet->{MaxRow} ||=3D $sheet->{MinRow};
foreach my $row ($sheet->{MinRow} .. $sheet->{MaxRow}) {
$sheet->{MaxCol} ||=3D $sheet->{MinCol};
foreach my $col ($sheet->{MinCol} .. $sheet->{MaxCol}) {
my $cell =3D $sheet->{Cells}[$row][$col];
if ($cell) {
printf("( %s , %s ) =3D> %s\n", $row, $col, $cell-
>{Val});
}
}
}
}
I have a error something like this :
"Can=B4t locate Spreadsheet.pm in @INC(@INC constains : ............"
There is missing other module ?
Can you help me, please ??
Thanks,
Paulito
| |
| Michael Zedeler 2007-08-09, 6:59 pm |
| Santana wrote:
> Error in Spreadsheet module
>
> i'am new in newbie in Perl, and i try i convert a excel file in csv
> file in Suse 10.0 linux.
>
> I install the Spreadsheet-ParseExcel-0.32.tar.gz module in my linux
> but when i try run this script :
>
> use strict;
> use Spreadsheet::ParseExcel; [snip]>
> I have a error something like this :
>
> "Canīt locate Spreadsheet.pm in @INC(@INC constains : ............"
>
> There is missing other module ?
I've used that module very on a unix machine and didn't experience any
problems. How did you install the module? By using CPAN (perl -MCPAN -e
shell) or manually (download package from CPAN, unpack, compile, test
install)?
Would you mind posting the complete error message as perl reports it?
Regards,
Michael.
|
|
|
|
|