This project has moved and is read-only. For the latest updates, please go here.

How to change Checkbox value in xlsx?

Apr 16, 2014 at 4:16 PM
I have a template file xlsx with checkbox objects. Is there a way to set values in checkbox? I can't find methods in the library for working with that.
I tried just to put TRUE/FALSE into LinkedCell, but when I open an edited xlsx it doesn't take the values for setting into checkboxes.
Apr 18, 2014 at 5:20 PM
Edited Apr 18, 2014 at 5:23 PM
I have the same controls in my template. When adding the value to the cell, set it as a bool value. For example:

bool isChecked = false;
sheet.Cells["C10"].Value = isChecked;