arindamp2 has asked for the wisdom of the Perl Monks concerning the following question:

Hi, I am new user of PERL, I am using PERL for Selenium RC. My target is to, open google page, if it is successful, i will write "Pass" in an existing excel sheet otherwise write "Fail". The code is as follows:-

use strict;

use warnings;

use Time::HiRes qw(sleep);

use Test::WWW::Selenium;

use Test::More "no_plan";

use Test::Exception;

use Spreadsheet::WriteExcel;

use Spreadsheet::ParseExcel;

use Spreadsheet::ParseExcel::SaveParser;

print "\n\n **Enter You Browser Choice :: ";

my $browser = <STDIN>;

my $row;

my $col;

my $count;

my $sheet;

$row = 0;

$col = 0;

$sheet = 0;

$count = 1;

my $sel = Test::WWW::Selenium->new( host => "localhost", port => 4444, browser => "*$browser", browser_url => "http://www.google.uk/" );

my $parser = new Spreadsheet::ParseExcel;

my $template = $parser->Parse("test_result.xls");

$template->AddCell(0, $row+1, $col, $browser);

if($sel->open_ok("http://www.google.co.uk/")){

$template->AddCell(0, $row+1, $col+1, "Home Page

:http://www.shopzilla.co.uk/"); $template->AddCell(0, $row, $col+2, "Pass");

}

else{

$template->AddCell(0, $row+1, $col+3, "Fail");

} ----- The error I am getting while compilation is as follows:- object method "AddCell" via package "Spreadsheet::ParseExcel::Workbook" I will be really thankful, if anyone could can give me some suggestions to resolve the problem. Regards, Arindam Pattanayak =========
  • Comment on PERL can not open object method "AddCell" via package "Spreadsheet::ParseExcel::Workbook"

Replies are listed 'Best First'.
Re: PERL can not open object method "AddCell" via package "Spreadsheet::ParseExcel::Workbook"
by jmcnamara (Monsignor) on May 30, 2010 at 19:04 UTC

    The AddCell() method is part of Spreadsheet::ParseExcel::SaveParser and not Spreadsheet::ParseExcel.

    So you should really be doing something like the following:

    ... my $parser = Spreadsheet::ParseExcel::SaveParser->new(); my $template = $parser->Parse('test_result.xls'); ...

    See the example at the previous link for more details.

    --
    John.

Re: PERL can not open object method "AddCell" via package "Spreadsheet::ParseExcel::Workbook"
by afoken (Chancellor) on May 30, 2010 at 19:25 UTC

    Welcome to Perlmonks.

    Did you notice that your posting does not look as it should? Don't fiddle with HTML to format your code, put your code in <code> tags. Use <p> tags for the remaining paragraphs. You can re-edit your posting right here, so please make it more readable for people willing to help you.

    Oh, and there is no PERL. There is a language called Perl (no acronym), and an implementation called perl.

    Alexander

    --
    Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)