val service = ...val spreadsheetId = ...val sheetId = 0val 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.