Nobuo Danjou > Net-Google-Spreadsheets-0.1501 > Net::Google::Spreadsheets::Spreadsheet

Download:
Net-Google-Spreadsheets-0.1501.tar.gz

Dependencies

Annotate this POD

CPAN RT

New  1
Open  0
View/Report Bugs
Source  

NAME ^

Net::Google::Spreadsheets::Spreadsheet - Representation of spreadsheet.

SYNOPSIS ^

  use Net::Google::Spreadsheets;

  my $service = Net::Google::Spreadsheets->new(
    username => 'mygoogleaccount@example.com',
    password => 'mypassword'
  );

  my @spreadsheets = $service->spreadsheets();

  # find a spreadsheet by key
  my $spreadsheet = $service->spreadsheet(
    {
        key => 'key_of_a_spreasheet'
    }
  );

  # find a spreadsheet by title
  my $spreadsheet_by_title = $service->spreadsheet(
    {
        title => 'list for new year cards'
    }
  );

  # create a worksheet
  my $worksheet = $spreadsheet->add_worksheet(
    {
        title => 'foobar',
        col_count => 10,
        row_count => 100,
    }
  );

  # list worksheets
  my @ws = $spreadsheet->worksheets;
  # find a worksheet
  my $ws = $spreadsheet->worksheet({title => 'fooba'});

  # create a table
  my $table = $spreadsheet->add_table(
    {
        title => 'sample table',
        worksheet => $worksheet,
        columns => ['id', 'username', 'mail', 'password'],
    }
  );

  # list tables
  my @t = $spreadsheet->tables;
  # find a worksheet
  my $t = $spreadsheet->table({title => 'sample table'});

METHODS ^

worksheets(\%condition)

Returns a list of Net::Google::Spreadsheets::Worksheet objects. Acceptable arguments are:

worksheet(\%condition)

Returns first item of worksheets(\%condition) if available.

add_worksheet(\%attribuets)

Creates new worksheet and returns a Net::Google::Spreadsheets::Worksheet object representing it. Arguments (all optional) are:

tables(\%condition)

Returns a list of Net::Google::Spreadsheets::Table objects. Acceptable arguments are:

table(\%condition)

Returns first item of tables(\%condition) if available.

add_table(\%attribuets)

Creates new table and returns a Net::Google::Spreadsheets::Table object representing it. Arguments are:

DELETING A SPREADSHEET ^

To delete a spreadsheet, use Net::Google::DocumentsList.

  my $docs = Net::Google::DocumentsList->new(
    username => 'mygoogleaccount@example.com',
    password => 'mypassword'
  );
  $docs->item({resource_id => 'spreadsheet:'. $ss->key})->delete;

SEE ALSO ^

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

Net::Google::AuthSub

Net::Google::Spreadsheets

Net::Google::Spreadsheets::Worksheet

Net::Google::Spreadsheets::Table

Net::Google::DocumentsList

AUTHOR ^

Nobuo Danjou <danjou@soffritto.org>

syntax highlighting: