Excel "option button" controls

[Melinda Peirce]

Is there a way to get information about Option buttons or checkbox controls contained in an excel spreadsheet? I am opening an existing spreadsheet and reading the data in to an essential grid control cell by cell bringing all formatting also. Some of my excel documents may contain option groups or checkboxes inserted with the 'forms' toolbox, and I don't seem to be able to find them in the XlsIO spreadsheet object.

is there a way to do this?

[Geetha M]

Hi Melinda,

Thank you for your interest in Syncfusion products.

You can check the existence of Group (option button) using the code snippet given below:

sheet.Range[2, 2, 4, 4].IsGroupedByRow;

sheet.Range[2, 2, 4, 4].IsGroupedByColumn;

Also using our latest version (v7.2.0.20), you can read and write checkboxes. Please refer to our documentation in the link below:
http://help.syncfusion.com/ug_72/xlsio/CheckBox.html

Please try this and let me know if you have any questions.

Regards,
Geetha