Skip to main content

Write Range

Description​

This activity imports the specified DataTable content inside the selected spreadsheet and at the specified cell range.

note

This activity works only inside Google Context activity.

Properties​

Location​

  • Spreadsheet Path / Id - Specify the relative spreadsheet path or id in the drive.
  • Starting Cell Address - Specify the cell address from which you want to start writing.
  • Data Table - Specify the data table you want to import into the spreadsheet.

Misc​

  • DisplayName – Add a display name to your activity.
  • Private – Logs the variable and argument values at the Verbose level when unchecked.

Optional​

  • Sheet Name - It specifies the sheet's name from where you want to write the data. By default, the operation will be performed on the currently active sheet.
  • IncludeHeader - If true, the column headers from the DataTable will be imported as the header row inside the sheet. By default, it is false.
  • Transpose - Specify how you want to import the data from DataTable. If true, it imports each column in the DataTable as a row inside the sheet. The default value is false.
  • Continue On Error – Specifies if the automation should continue even when the Activity throws an error. This field only supports Boolean values (True, False). The default value is False.
    note

    Catches no error if this Activity is present inside the Try-Catch block and the value of this property is True.

Output​

Example​

Download Example

Write Range