The Perl and Raku Conference 2025: Greenville, South Carolina - June 27-29 Learn more

NAME

Net::Google::Spreadsheets::Cell - A representation class for Google Spreadsheet cell.

SYNOPSIS

my $service = Net::Google::Spreadsheets->new(
username => 'mygoogleaccount@example.com',
password => 'mypassword',
);
# get a cell
my $cell = $service->spreadsheet(
{
title => 'list for new year cards',
}
)->worksheet(
{
title => 'Sheet1',
}
)->cell(
{
col => 1,
row => 1,
}
);
# update a cell
$cell->input_value('new value');
# get the content of a cell
my $value = $cell->content;

ATTRIBUTES

input_value

Rewritable attribute. You can set formula like '=A1+B1' or so.

content

Read only attribute. You can get the result of formula.

SEE ALSO

https://developers.google.com/google-apps/spreadsheets/

Net::Google::AuthSub

Net::Google::Spreadsheets

AUTHOR

Nobuo Danjou <danjou@soffritto.org>