Thanks Pritish/jing! From: Pritish Pattanaik [mailto:[email protected]] Sent: Monday, July 15, 2013 4:47 PM To: Tom, Jentil Kuriakose; [email protected] Subject: Re: Excel Sheet Gen Code gives error
Hello Jentil, Have you installed SpreadSheet::WriteExcel module ? , if no => then install it from cpan shell or you can download it from (http://search.cpan.org/CPAN/authors/id/J/JM/JMCNAMARA/Spreadsheet-WriteExcel-2.39.tar.gz link) follow the instruction: wget link tar -xzvf file.gz cd newlycreateddir perl Makefile.PL PREFIX="/path/to/your/testing/area" make make test if yes => then search WriteExcel.pm file from your machine find / -name "WriteExcel.pm" /find/path/WriteExcel.pm add this line in your main code use lib "/find/path/" [https://mail.google.com/mail/u/0/images/cleardot.gif] On Mon, Jul 15, 2013 at 4:44 PM, Pritish Pattanaik <[email protected]<mailto:[email protected]>> wrote: Hello Jentil, Have you installed SpreadSheet::WriteExcel module ? , if no => then install it from cpan shell or you can download it from (http://search.cpan.org/CPAN/authors/id/J/JM/JMCNAMARA/Spreadsheet-WriteExcel-2.39.tar.gz link) follow the instruction: wget link tar -xzvf file.gz perl ./DIR/Makefile.PL prefix="/path/to/your/testing/area" make make test if yes => then search WriteExcel.pm file from your machine find / -name "WriteExcel.pm" /find/path/WriteExcel.pm add this line in your main code use lib "/find/path/" On Mon, Jul 15, 2013 at 4:31 PM, Tom, Jentil Kuriakose <[email protected]<mailto:[email protected]>> wrote: Hi, I have written simple EXCEL sheet gen PEARL code: #!/usr/bin/perl use strict; use Spreadsheet::WriteExcel; my $workbook = Spreadsheet::WriteExcel->new("simple.xls"); my $SUMMARY = $workbook->add_worksheet("SUMMARY"); $SUMMARY->write(0, 0, "START"); $SUMMARY->write(0, 2, "A"); But it gives following error when I execute through: >perl excel_sheet.pl<http://excel_sheet.pl> Can't locate Spreadsheet/WriteExcel.pm in @INC (@INC contains: /usr/perl5/5.8.4/lib/sun4-solaris-64int /usr/perl5/5.8.4/lib /usr/perl5/site_perl/5.8.4/sun4-solaris-64int /usr/perl5/site_perl/5.8.4 /usr/perl5/site_perl /usr/perl5/vendor_perl/5.8.4/sun4-solaris-64int /usr/perl5/vendor_perl/5.8.4 /usr/perl5/vendor_perl .) at excel_sheet.pl<http://excel_sheet.pl> line 4. BEGIN failed--compilation aborted at excel_sheet.pl<http://excel_sheet.pl> line 4. Kindly help. Thanks, Jentil. -- To unsubscribe, e-mail: [email protected]<mailto:[email protected]> For additional commands, e-mail: [email protected]<mailto:[email protected]> http://learn.perl.org/
