How to set checkbox state in excel with spire.xls?

[Jay.L]

There are some checkboxes in a Excel,can I set their checked/unchecked states with Spire.xls?

[Betsy.jiang]

Dear Jay.L,

Thanks for your inquiry.
Here is sample code for your kind reference.

Code: Select all

            Workbook book = new Workbook();
            book.LoadFromFile(@"F:\testing\xls test form\sample document\9201.xlsx");
            Worksheet sheet = book.Worksheets[0];
            ICheckBoxes checkboxes = sheet.CheckBoxes;
            //change the state
            checkboxes[0].CheckState = CheckState.Checked;
            book.SaveToFile("9201.xlsx", ExcelVersion.Version2013);

Sincerely,
Betsy
E-iceblue support team

[Betsy.jiang]

Dear Jay.L,

Did you test the code ? Did it help you to solve the issue ?

Thanks,
Betsy
E-iceblue support team

[Jay.L]

Dear Jay.L,

Did you test the code ? Did it help you to solve the issue ?

Thanks,
Betsy
E-iceblue support team

Dear support team,
I am sorry for late reply. I have tested the code and it does help me.Thanks very much!

[Betsy.jiang]

Dear Jay.L,

Thanks for your feedback.
Welcome to write to us again for further question.

Sincerely,
Betsy
E-iceblue support team