Android (Java/Kotlin) Google Sheets API: Find/Get Number of Rows

April 7, 2019

Append Rows

If you just need to append new rows, you don’t need to get the number of rows.

Solution 1: Retrieve all cells of a column

val service = ...
val spreadsheetId = ...
val sheetName = ...

val result = service.spreadsheets().values().get(spreadsheetId, "'$sheetName'!A:A").execute()
Timber.d("rows=${result.getValues().size}")

NOTE: result.getValues() and result.values return different things.

NOTE: service is Sheets. Refer to Get Google Sheets service instance.

NOTE: Refer to Get Sheet Name.

Doesn’t Work: gridProperties.rowCount

gridProperties.rowCount return all rows including blank rows.

val spreadsheet = service.spreadsheets().get(spreadsheetId).execute()

for (sheet in spreadsheet.sheets) {
    Timber.d("sheetId=${sheet.properties.sheetId}, title=${sheet.properties.title}, rows=${sheet.properties.gridProperties.rowCount}")
}

❤️ Is this article helpful?

Buy me a coffee☕ or support my work to keep this space 🖖 and ad-free.
If you can't, do send some 💖 to @d_luaz or help to share this article.

👶 Apps I built

Travelopy - discover travel places in Malaysia, Singapore, Taiwan, Japan.
Pixtory App (Alpha) - easily organize photos on your phone into a blog.
暖心芽 (WIP) 🌞❤️🌱 - reminder of hope, warmth, thoughts and feelings (or just quotes).
LuaPass - offline password manager

By Desmond Lua

A dream boy who enjoys making apps, travelling and gardening. Follow me on @d_luaz.

Tags:

Setup Google Sheets API for Android (Java/Kotlin)

Android (Java/Kotlin) Google Sheets API: Add New Sheet

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

Android (Java/Kotlin) Google Sheets API: Protect Column/Cell From Edit

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

Android (Java/Kotlin) Google Sheets API: Update Column Width (or Auto Resize)

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

Android (Java/Kotlin) Google Sheets API: Set Frozen Row

Android (Java/Kotlin) Google Sheets API: Update Cell Value