GSheets Operator > Google Sheets Operator > Write Values to Sheet

Write Values to Sheet

Set values from the Sheet Tab Data Object starting from a specified cell. If values exist in this range, they will be overwritten.
Note that if the range you want to update exceeds grid limits and bAppendToSheet is false, this operation will fail. Best practice is to use bAppendToSheet or append enough rows and columns for your range before writing using AppendDimension.

Inputs

In
Exec

In Token
Google Sheets Web Token Object Reference

A validated UGoogleSheetsWebToken object. Used to authenticate the Sheets operation.
Operation Params
Google Sheets Operation Params Structure

Generic request operation parameters
Call on Complete
Delegate (by ref)

This delegate will be called when the operation completes and tell you whether or not it was successful and return the response as a string.
In Spreadsheet Id
String

This is the spreadsheet ID number or key. Get it from your spreadsheet URL by calling GetSpreadsheetIdFromUrl.
In Sheet Id
Integer

This is the sheet ID number or GID. Get it from your sheet URL by calling GetSheetIdFromUrl or from a UGoogleSheetsObjectSpreadsheet calling GetSheetIdFromSheetIndex().
In Starting Cell
String

The single cell from which you wish to start writing your values. Please ensure this cell exists before writing. Please do not put a range into InStartingCell.
Values to Write
Google Sheets Sheet Tab Data Object Reference

A UGoogleSheetsObjectSheet Tab Data Object containing the data you wish to write. You can create a UGoogleSheetsObjectSheet Tab Data Object by calling CreateNewSheetTabDataObjectFrom2dStringArray or CreateNewBlankSheetTabDataObject the add values to it with AppendStringValues.
Append to Sheet
Boolean

If true, StartingCell will be ignored and these values will be appended to the end of the sheet. You don't need to worry about row count if this option is true; rows will be automatically added as needed. Column count will need to match or exceed the number of values in each row or the operation will fail.

Outputs

Out
Exec