GSheets Operator > Google Sheets Operator > Auto Resize Dimension

Auto Resize Dimension

Automatically resize columns or rows to be just the size they need to be to accomodate their data.

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

The ID number or GID of the sheet tab. Must not be negative.

Start at Index
Integer

The first row or column index that will be resized. This index is 0-based, so column A or Row 1 will be index 0.

End at Index
Integer

The final row or column index that will be resized. This index is 0-based, so column A or Row 1 will be index 0.

Dimension
EGoogleSheetsMajorDimension Enum

The dimension which will be resized

Outputs

Out
Exec