Android (Java/Kotlin) Google Sheets API: Update Sheet Name/Title

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

val requests = listOf<Request>(
    // froze 1st column
    Request().setUpdateSheetProperties(
        UpdateSheetPropertiesRequest().apply {
            properties = SheetProperties().apply {
                this.sheetId = sheetId
                title = "Hello"
            }
            fields = "title"
        }
    )
)

val body = BatchUpdateSpreadsheetRequest()
    .setRequests(requests)

service.spreadsheets().batchUpdate(spreadsheetId, body).execute()

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.