I'm trying to update one cell that has CheckBox data type. Is there any way to set CheckBox to state Checked trough the API? Can't find any c# example...

CodePudding user response：

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