Storage

The Social component in app builders typically provides functionalities that allow developers to integrate social media features into their applications, facilitating interaction, sharing, and engagement with social platforms.

About the component


Image Description
  •  Last Update 25 Oct, 2023
  •  Component Version : 2.0.0
  •  API 21, Android 5.0 Lollipop
  •  29 Blocks Available

Spreadsheet

The Spreadsheet component enables interaction with Google Sheets, allowing you to read, write, and manipulate data within a spreadsheet.

Overview

The Spreadsheet component is a non-visible component that allows reading and writing data to Google Sheets.

Events

Image Description
Events

ErrorOccurred

  • Triggered when an error occurs during an operation.

    • # Name Type(s) Default Value
    1 errorMessage String
    Image Description
    Events

    FinishedAddColumn

  • Triggered after a column is added.

    • # Name Type(s) Default Value
    1 columnNumber int
    Image Description
    Events

    FinishedAddRow

  • Triggered after a row is added.

    • # Name Type(s) Default Value
    1 rowNumber int
    Image Description
    Events

    FinishedAddSheet

  • Triggered after a sheet is added.

    • # Name Type(s) Default Value
    1 sheetName String
    Image Description
    Events

    FinishedClearRange

  • Triggered after a range of cells is cleared.

    • Image Description
    Events

    FinishedDeleteSheet

  • Triggered after a sheet is deleted.

    • # Name Type(s) Default Value
    1 sheetName String
    Image Description
    Events

    FinishedRemoveColumn

  • Triggered after a column is removed.

    • Image Description
    Events

    FinishedRemoveRow

  • Triggered after a row is removed.

    • Image Description
    Events

    FinishedWriteCell

  • Triggered after a cell is written.

    • Image Description
    Events

    FinishedWriteColumn

  • Triggered after a column is written.

    • Image Description
    Events

    FinishedWriteRange

  • Triggered after a range of cells is written.

    • Image Description
    Events

    GotCellData

  • Triggered when cell data is retrieved.

    • # Name Type(s) Default Value
    1 cellData String
    Image Description
    Events

    GotColumnData

  • Triggered when column data is retrieved.

    • # Name Type(s) Default Value
    1 columnData List
    Image Description
    Events

    GotFilterResult

  • Triggered when a filter result is retrieved.

    • # Name Type(s) Default Value
    1 returnRows List
    2 returnData List
    Image Description
    Events

    GotRangeData

  • Triggered when a range of data is retrieved.

    • # Name Type(s) Default Value
    1 rangeData List
    Image Description
    Events

    GotRowData

  • Triggered when a row of data is retrieved.

    • # Name Type(s) Default Value
    1 rowDataList List
    Image Description
    Events

    GotSheetData

  • Triggered when data from the entire sheet is retrieved.

    • # Name Type(s) Default Value
    1 sheetData List

    Methods

    Image Description
    Methods

    AddColumn

  • Adds a new column to the specified sheet.

    • # Name Type(s) Default Value
    1 sheetName String
    2 data List
    Image Description
    Methods

    AddRow

  • Adds a new row to the specified sheet.

    • # Name Type(s) Default Value
    1 sheetName String
    2 data List
    Image Description
    Methods

    AddSheet

  • Adds a new sheet to the spreadsheet.

    • # Name Type(s) Default Value
    1 sheetName String
    Image Description
    Methods

    ClearRange

  • Clears the contents of a specified range.

    • # Name Type(s) Default Value
    1 sheetName String
    2 rangeReference String
    Image Description
    Methods

    DeleteSheet

  • Deletes the specified sheet.

    • # Name Type(s) Default Value
    1 sheetName String
    Image Description
    Methods

    GetCellReference

  • Gets the reference for a specific cell.

    • # Name Type(s) Default Value
    1 row int
    2 column int
    Image Description
    Methods

    GetRangeReference

  • Gets the reference for a range of cells.

    • # Name Type(s) Default Value
    1 row1 int
    2 column1 int
    3 row2 int
    4 column2 int
    Image Description
    Methods

    ReadCell

  • Reads the value of a single cell.

    • # Name Type(s) Default Value
    1 sheetName String
    2 cellReference String
    Image Description
    Methods

    ReadColumn

  • Reads the values of an entire column.

    • # Name Type(s) Default Value
    1 sheetName String
    2 column String
    Image Description
    Methods

    ReadRange

  • Reads the values of a range of cells.

    • # Name Type(s) Default Value
    1 sheetName String
    2 rangeReference String
    Image Description
    Methods

    ReadRow

  • Reads the values of an entire row.

    • # Name Type(s) Default Value
    1 sheetName String
    2 rowNumber int
    Image Description
    Methods

    ReadSheet

  • Reads all data from the specified sheet.

    • # Name Type(s) Default Value
    1 sheetName String
    Image Description
    Methods

    ReadWithExactFilter

  • Reads data from the sheet with an exact filter.

    • # Name Type(s) Default Value
    1 sheetName String
    2 colID String
    3 value String
    Image Description
    Methods

    ReadWithPartialFilter

  • Reads data from the sheet with a partial filter.

    • # Name Type(s) Default Value
    1 sheetName String
    2 colID String
    3 value String
    Image Description
    Methods

    RemoveColumn

  • Removes a column from the specified sheet.

    • # Name Type(s) Default Value
    1 sheetName String
    2 column String
    Image Description
    Methods

    RemoveRow

  • Removes a row from the specified sheet.

    • # Name Type(s) Default Value
    1 sheetName String
    2 rowNumber int
    Image Description
    Methods

    WriteCell

  • Writes a value to a specific cell.

    • # Name Type(s) Default Value
    1 sheetName String
    2 cellReference String
    3 data String
    Image Description
    Methods

    WriteColumn

  • Writes data to a specified column.

    • # Name Type(s) Default Value
    1 sheetName String
    2 column String
    3 data List
    Image Description
    Methods

    WriteRange

  • Writes data to a specified range of cells.

    • # Name Type(s) Default Value
    1 sheetName String
    2 rangeReference String
    3 data List
    Image Description
    Methods

    WriteRow

  • Writes data to a specified row.

    • # Name Type(s) Default Value
    1 sheetName String
    2 rowNumber int
    3 data List

    Properties

    Image Description
    Image Description
    Properties

    CredentialsJson

  • Gets the credentials JSON file content.

  • Sets the credentials JSON file content.

    • # Name Type(s) Default Value
    1 CredentialsJson String
    2 CredentialsJson String
    Image Description
    Image Description
    Properties

    SpreadsheetID

  • Gets the ID of the Google Sheet.

  • Sets the ID of the Google Sheet.

    • # Name Type(s) Default Value
    1 SpreadsheetID String
    2 SpreadsheetID String