Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
Net::Google::SpreadsheUser:Contributed Perl DNet::Google::Spreadsheets::Row(3)

NAME
       Net::Google::Spreadsheets::Row -	A representation class for Google
       Spreadsheet row.

SYNOPSIS
	 use Net::Google::Spreadsheets;

	 my $service = Net::Google::Spreadsheets->new(
	   username => 'mygoogleaccount@example.com',
	   password => 'mypassword',
	 );

	 # get a row
	 my $row = $service->spreadsheet(
	   {
	       title =>	'list for new year cards',
	   }
	 )->worksheet(
	   {
	       title =>	'Sheet1',
	   }
	 )->row(
	   {
	       sq => 'id = 1000'
	   }
	 );

	 # get the content of a	row
	 my $hashref = $row->content;
	 my $id	= $hashref->{id};
	 my $address = $hashref->{address};

	 # update a row
	 $row->content(
	   {
	       id => 1000,
	       address => 'somewhere',
	       zip => '100-0001',
	       name => 'Nobuo Danjou',
	   }
	 );

	 # get and set values partially

	 my $value = $row->param('name');
	 # returns 'Nobuo Danjou'

	 # it's	same by	getting	via param method without args, or content method:
	 my $value_by_param = $row->param->{name};
	 my $value_by_content =	$row->content->{name};

	 my $newval = $row->param({address => 'elsewhere'});
	 # updates address (and	keeps other fields) and	returns	new row	value (with all	fields)

	 my $hashref2 =	$row->param;
	 # same	as $row->content;

	 # delete the row
	 $row->delete;

METHODS
   param
       sets and	gets content value.

   delete
       deletes the row.

CAVEATS
       Space characters	in hash	key of rows will be removed when you access
       rows. See below.

	 my $ws	= Net::Google::Spreadsheets->new(
	   username => 'me@gmail.com',
	   password => 'foobar'
	 )->spreadsheet({titile	=> 'sample'})->worksheet(1);
	 $ws->batchupdate_cell(
	   {col	=> 1,row => 1, input_value => 'name'},
	   {col	=> 2,row => 1, input_value => 'mail address'},
	 );
	 $ws->add_row(
	   {
	       name => 'my name',
	       mailaddress => 'me@gmail.com',
	 #	above passes, below fails.
	 #	'mail address' => 'me@gmail.com',
	   }
	 );

       Instead,	Net::Google::Spreadsheets::Table and
       Net::Google::Spreadsheets::Record allows	space characters in column
       name.

	 my $s = Net::Google::Spreadsheets->new(
	   username => 'me@gmail.com',
	   password => 'foobar'
	 )->spreadsheet({titile	=> 'sample'});

	 my $t = $s->add_table(
	   {
	       worksheet => $s->worksheet(1),
	       columns => ['name', 'mail address'],
	   }
	 );
	 $t->add_record(
	   {
	       name => 'my name',
	       'mail address' => 'me@gmail.com',
	   }
	 );

ATTRIBUTES
   content
       Rewritable attribute. You can get and set the value.  So	it's the same
       thing to	get the	value with param method	or content attribute.

	 my $value = $row->param('foo');
	 # it's	same
	 my $value2 = $row->content->{'foo'};

SEE ALSO
       <https://developers.google.com/google-apps/spreadsheets/>

       Net::Google::AuthSub

       Net::Google::Spreadsheets

AUTHOR
       Nobuo Danjou <danjou@soffritto.org>

perl v5.32.1			  2012-04-30 Net::Google::Spreadsheets::Row(3)

NAME | SYNOPSIS | METHODS | CAVEATS | ATTRIBUTES | SEE ALSO | AUTHOR

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=Net::Google::Spreadsheets::Row&sektion=3&manpath=FreeBSD+13.0-RELEASE+and+Ports>

home | help