Android (Java/Kotlin) Google Sheets API: Hide Columns

April 7, 2019
val service = ...
val spreadsheetId = ...
val sheetId = 0

val 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.

This work is licensed under a
Creative Commons Attribution-NonCommercial 4.0 International License.