GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages


Manual Reference Pages  -  NET::GOOGLE::SPREADSHEETS::ROW (3)

.ds Aq ’

NAME

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

CONTENTS

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

  # its 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);
  # its 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>
Search for    or go to Top of page |  Section 3 |  Main Index


perl v5.20.3 NET::GOOGLE::SPREADSHEETS::ROW (3) 2012-04-30

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with manServer 1.07.