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

val service = ...val spreadsheetId = ...val sheetId = 0val requests = listOf<Request>(    // set Col A to AutoResize    Request().setAutoResizeDimensions(        AutoResizeDimensionsRequest().apply {            dimensions = DimensionRange().apply {                this.sheetId = sheetId                dimension = "COLUMNS"                startIndex = 0 // A                endIndex = 1            }        }    ),    // set Col B to 350    Request().setUpdateDimensionProperties(        UpdateDimensionPropertiesRequest().apply {            range = DimensionRange().apply {                this.sheetId = sheetId                dimension = "COLUMNS"                startIndex = 1 // B                endIndex = 2            }            properties = DimensionProperties().apply {                pixelSize = 300            }            fields = "pixelSize"        }    ))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.

References:

❤️ Is this article helpful?

Buy me a coffee ☕ or support my work via PayPal to keep this space 🖖 and ad-free.

Do send some 💖 to @d_luaz or share this article.

✨ By Desmond Lua

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

👶 Apps I built

Travelopy - discover travel places in Malaysia, Singapore, Taiwan, Japan.