How to update Google sheet CheckBox using Google.Apis.Sheets.v4?

Question

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...

what if you simply set value to `True/False` or `0/1`? – Lei Yang Jan 14 '22 at 05:51 — Lei Yang, Jan 14 '22 at 05:51

score 2 · Accepted Answer · answered Jan 14 '22 at 09:19

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#:

My bad, didn't check send types by myself. Thanks for help it works. — SkyDancer, Jan 14 '22 at 12:05

How to update Google sheet CheckBox using Google.Apis.Sheets.v4?

1 Answers1

Checking or unchecking checkboxes with the Google Sheets API is equivalent to updating the cell values to the booleans true and false.

Checking or unchecking checkboxes with the Google Sheets API is equivalent to updating the cell values to the booleans `true` and `false`.