The London Perl and Raku Workshop takes place on 26th Oct 2024. If your company depends on Perl, please consider sponsoring and/or attending.

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

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

METHODS

param

sets and gets content value.

ATTRIBUTES

content

Rewritable attribute. You can get and set the value.

SEE ALSO

http://code.google.com/intl/en/apis/spreadsheets/docs/2.0/developers_guide_protocol.html

http://code.google.com/intl/en/apis/spreadsheets/docs/2.0/reference.html

Net::Google::AuthSub

Net::Google::Spreadsheets

AUTHOR

Nobuo Danjou <nobuo.danjou@gmail.com>