GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages
Net::Google::Spreadsheets::Spreadsheet(3) User Contributed Perl Documentation Net::Google::Spreadsheets::Spreadsheet(3)

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

  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'});

Returns a list of Net::Google::Spreadsheets::Worksheet objects. Acceptable arguments are:
  • title
  • title-exact

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

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

Returns a list of Net::Google::Spreadsheets::Table objects. Acceptable arguments are:
  • title
  • title-exact

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

Creates new table and returns a Net::Google::Spreadsheets::Table object representing it. Arguments are:
  • title (optional)
  • summary (optional)
  • worksheet

    Worksheet where the table lives. worksheet instance or the title.

  • header (optional, default = 1)

    Row number of header

  • start_row (optional, default = 2)

    The index of the first row of the data section.

  • num_rows (optional, default = 0)

    Number of rows of the data section initially made.

  • insertion_mode (optional, default = 'overwrite')

    Insertion mode. 'insert' inserts new row into the worksheet when creating record, 'overwrite' tries to use existing rows in the worksheet.

  • columns

    Columns of the table. you can specify them as hashref, arrayref, arrayref of hashref.

      $ss->add_table(
        {
            worksheet => $ws,
            columns => [
                {index => 1, name => 'foo'},
                {index => 2, name => 'bar'},
                {index => 3, name => 'baz'},
            ],
        }
      );
    
      $ss->add_table(
        {
            worksheet => $ws,
            columns => {
                A => 'foo',
                B => 'bar',
                C => 'baz',
            }
        }
      );
    
      $ss->add_table(
        {
            worksheet => $ws,
            columns => ['foo', 'bar', 'baz'],
        }
      );
        

    'index' of the first case and hash key of the second case is column index of the worksheet. In the third case, the columns is automatically placed to the columns of the worksheet from 'A' to 'Z' order.

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;

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

Net::Google::AuthSub

Net::Google::Spreadsheets

Net::Google::Spreadsheets::Worksheet

Net::Google::Spreadsheets::Table

Net::Google::DocumentsList

Nobuo Danjou <danjou@soffritto.org>
2012-04-30 perl v5.32.1

Search for    or go to Top of page |  Section 3 |  Main Index

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with ManDoc.