GSheets Operator > Google Sheets Operator > Write Csv to Sheet

Write Csv to Sheet

Clears the sheet, writes the values in the given CSV, then removes empty dimensions.
It's recommended to use a long token expiration for this operation, like 60 seconds.

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 Csv
String

This is the Csv data represented as a string. To load a CSV document from a file, use LoadStringFromFile().

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().

Outputs

Out
Exec