You are currently viewing the new Anvil Editor Docs.
Switch to the Classic Editor Docs
You are currently viewing the Classic Editor Docs.
Switch to the new Anvil Editor Docs

anvil.google.sheets Module

Classes

Cell


Cell Attributes

col - number

This cell’s column index (starting from 1)

input_value - string

The value that was entered into the cell

row - number

This cell’s row index (starting from 1)

value - string

The value in this cell


Row


Instance Methods

delete()

Delete this row from the worksheet. (This will cause data in subsequent rows to shift up)


Spreadsheet


Instance Methods

list_worksheets() → list(anvil.google.sheets.Worksheet instance)

Get a list of all worksheets in this spreadsheet


Spreadsheet Attributes

id - string

The ID of this spreadsheet in Google Drive

title - string

The title of this spreadsheet.

worksheets - list(anvil.google.sheets.Worksheet instance)

The worksheets in this spreadsheet.


Worksheet


Instance Methods

add_row(**fields) → anvil.google.sheets.Row instance

Add a row to the end of the worksheet, specifying values for columns as keywords arguments

    get_cell(row, col) → anvil.google.sheets.Cell instance

    Get a particular cell from the spreadsheet

      list_cells([min_row=], [max_row=], [min_col=], [max_col=]) → list(anvil.google.sheets.Cell instance)

      List cells in the worksheet, optionally specifying a region

        list_rows(**query) → list(anvil.google.sheets.Row instance)

        List rows in this worksheet, optionally restricting to rows with the specified column values specified as keyword arguments


          Worksheet Attributes

          cells - list(anvil.google.sheets.Cell instance)

          A list of all the cells in this worksheet

          column_count - number

          The number of columns in this worksheet

          fields - list

          The fields in this worksheet (ie the column headers, or the values in the first row)

          row_count - number

          The number of rows in this worksheet

          rows - list(anvil.google.sheets.Row instance)

          The rows in this worksheet (excluding the header)

          title - string

          The title of this worksheet



          Do you still have questions?

          Our Community Forum is full of helpful information and Anvil experts.


          anvil.google.sheets