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::Cell - A representation class for Google Spreadsheet cell.

SYNOPSIS

use Net::Google::Spreadsheets;

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>