Now N::G::S supports Google Spreadsheets API 3.0. So you can access to table feeds and record feeds with it.
my $service = Net::Google::Spreadsheets->new(
username => 'me@gmail.com',
password => 'foobar',
);
my $s = $service->spreadsheet;
my $w = $s->worksheet;
my $table = $s->add_table(
worksheet => $w,
columns => ['id', 'name', 'password'],
);
my $record = $table->add_record(
{
id => 1,
name => 'jhon lennon',
password => 'i_am_the_walrus',
}
);
or so. It’s easier to create table than to set header row to a worksheet.
CPAN url:
- http://search.cpan.org/~danjou/Net-Google-Spreadsheets-0.06_01/ see also:
- http://code.google.com/apis/spreadsheets/docs/3.0/developers_guide.html