Delete Empty Dimensions
Removes all empty dimensions of a specified type (rows or columns).
Side note, it's bonkers that Google Sheets doesn't have a way to do this natively in their API.
I can't be the only one who does this. Or maybe I am and I'm out of touch.
No, no. It's the Google that is wrong.
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. |
|
Dimension
EGoogleSheetsMajorDimension Enum
|
Specify the dimension considered for this operation. |
|
Should Consider Inner Dimensions for Deletion
Boolean
|
If true, dimensions that come before the last dimension with data will be considered for removal. If false, only dimensions that come after the last dimension with data will be considered. For example, if an empty row comes before the last row with data in it, setting this to true will remove that row. |
Outputs
|
Out
Exec
|