A way to add DataValidation about gspread HOT 6 CLOSED

On Tue, Feb 27, 2024 at 7:42 PM alifeee ***@***.***> wrote: Hi. This is a nice idea. I think it is quite large in scope. I do not have time to implement such a large feature. If you wanted to, I could help you think about it. For now, I suggest using Spreadsheet.batch_update <https://github.com/burnash/gspread/blob/cb1a63e563164546189472944927830f1bb01c4e/gspread/spreadsheet.py#L88-L97>, and building the request yourself with help from Google's docs <https://developers.google.com/sheets/api/samples/data#data-validation>. For example, using the example from that page, this works for me: import gspread gc = gspread.service_account(filename="google_credentials.json")sh = gc.open("gspread test spreadsheet") sh.batch_update( { "requests": [ { "setDataValidation": { "range": { "sheetId": sh.sheet1.id, "startRowIndex": 0, "endRowIndex": 10, "startColumnIndex": 0, "endColumnIndex": 4, }, "rule": { "condition": { "type": "NUMBER_GREATER", "values": [{"userEnteredValue": "5"}], }, "inputMessage": "Value must be > 5", "strict": True, }, } } ] } ) — Reply to this email directly, view it on GitHub <#1420 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AI2VVZVZCGTHQBOII4H762TYVXWEHAVCNFSM6AAAAABDVLNOUWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSNRWG4YDIOJTG4> . You are receiving this because you authored the thread.Message ID: ***@***.***>