NAME
Net::Google::Spreadsheets::Table - A representation class for Google Spreadsheet table.
SYNOPSIS
use Net::Google::Spreadsheets;
my $service = Net::Google::Spreadsheets->new(
username => 'mygoogleaccount@example.com',
password => 'mypassword',
);
# get a table
my $table = $service->spreadsheet(
{
title => 'list for new year cards',
}
)->table(
{
title => 'sample table',
}
);
# create a record
my $r = $table->add_record(
{
name => 'Nobuo Danjou',
nick => 'lopnor',
mail => 'nobuo.danjou@gmail.com',
age => '33',
}
);
# get records
my @records = $table->records;
# search records
@records = $table->records({sq => 'age > 20'});
# search a record
my $record = $table->record({sq => 'name = "Nobuo Danjou"'});METHODS
records(\%condition)
Returns a list of Net::Google::Spreadsheets::Record objects. Acceptable arguments are:
- sq
-
Structured query on the full text in the worksheet. see the URL below for detail.
- orderby
-
Set column name to use for ordering.
- reverse
-
Set 'true' or 'false'. The default is 'false'.
See http://code.google.com/intl/en/apis/spreadsheets/docs/3.0/reference.html#RecordParameters for details.
record(\%condition)
Returns first item of records(\%condition) if available.
add_record(\%contents)
Creates new record and returns a Net::Google::Spreadsheets::Record object representing it. Arguments are contents of a row as a hashref.
my $record = $table->add_record(
{
name => 'Nobuo Danjou',
nick => 'lopnor',
mail => 'nobuo.danjou@gmail.com',
age => '33',
}
);SEE ALSO
http://code.google.com/intl/en/apis/spreadsheets/docs/3.0/developers_guide_protocol.html
http://code.google.com/intl/en/apis/spreadsheets/docs/3.0/reference.html
Net::Google::Spreadsheets::Spreadsheet
Net::Google::Spreadsheets::Record
AUTHOR
Nobuo Danjou <nobuo.danjou@gmail.com>