I am trying to adjust the width of columns in a google sheet using GSpread, however I can’t find any documentation on the subject all across the web. I have tried the actual project documents itself, and stack overflow.
I have looked through the documentation, and stack overflow, and nobody has asked a question like this before.
No code to show, as I haven’t found any that may be relevant.
I am expecting the widen column ‘A’ in my sheet by around 100.
Thanks in advance for the help.
Cheers.
Advertisement
Answer
- You want to know how to adjust the width of the column of Google Spreadsheet using gspread.
- You want to set the column “A” to 100 pixels.
- You have already been able to put and get values to the Spreadsheet using gspread.
If my understanding is correct, how about this answer? In this modification, batch_update()
method is used.
Sample script:
Please set spreadsheetId
, sheetName
and the gridrange of range
.
spreadsheetId = "###" sheetName = "Sheet1" client = gspread.authorize(credentials) ss = client.open_by_key(spreadsheetId) sheetId = ss.worksheet(sheetName)._properties['sheetId'] body = { "requests": [ { "updateDimensionProperties": { "range": { "sheetId": sheetId, "dimension": "COLUMNS", "startIndex": 0, "endIndex": 1 }, "properties": { "pixelSize": 100 }, "fields": "pixelSize" } } ] } res = ss.batch_update(body)
Note:
- Please set the range as the gridrange.
- In this sample script,
startIndex: 0
andendIndex: 1
mean the column “A” because ofdimension: "COLUMNS"
.
- In this sample script,
- In this sample script, the width of the column “A” is set to 100 pixels.
- When
dimension
is changed toROWS
, the height of rows can be adjusted.
References:
If this was not useful for your situation, I apologize.