val service = ...val spreadsheetId = ...val sheetId = 0val requests = listOf<Request>( // Hide G, H, I Request().setUpdateDimensionProperties( UpdateDimensionPropertiesRequest().apply { range = DimensionRange().apply { this.sheetId = sheetId dimension = "COLUMNS" startIndex = colToIndex('G') endIndex = colToIndex('G') + 3 } properties = DimensionProperties().apply { hiddenByUser = true } fields = "hiddenByUser" } )}val body = BatchUpdateSpreadsheetRequest().setRequests(requests)service.spreadsheets().batchUpdate(spreadsheetId, body).execute()
fun colToIndex(char: Char): Int { return char.toInt() - 65}
NOTE: service
is Sheets. Refer to Get Google Sheets service instance.
NOTE: Refer to Get Sheet Id.