Android (Java/Kotlin) Google Sheets API: Add Note to Cell

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

val requests = listOf<Request>(
    // Add Note to D1
    Request().setRepeatCell(
        RepeatCellRequest().apply {
            range = GridRange().apply {
                this.sheetId = sheetId
                startRowIndex = 1
                endRowIndex = startRowIndex + 1
                startColumnIndex = colToIndex('D')
                endColumnIndex = startRowIndex + 1
            }
            cell = CellData().apply {
                note = "1 - Published\n0 - Not published"
            }
            fields = "note"
        }
    )
)

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.