How to update Google sheet CheckBox using Google.Apis.Sheets.v4?
Checking or unchecking checkboxes with the Google Sheets API is equivalent to updating the cell values to the booleans true
and false
.
- Use the method spreadsheets.values.update
- Base your request on the featured example code for C#
- I am not an expert in C#, but the value range in your request body should look something like this:
var list = new List<object>() { true };
requestBody.Values = new List<IList<object>> { list };
Reference for updating vlaues in C#:
- Update a Cell with C# and Sheets API v4
- In C# how do I go through a Google Sheets document and write into a specific cell