Modifing an Excel File's radio button

Aspose.Cells Product Family
1

Currently I have a button on a C# web form that exports all of the user specified values to an Excel file using Aspose. Everything works great until I get to where I need to update a value in the excel file that is a radio button.

I tried a couple different methods… Below I’m trying to update the radio button as checked\true\1, it is located on the worksheet named _sheetSummary on the 6th tab.

Aspose.Cells.Worksheet _sheetSummary = _book.Worksheets[6];
_sheetSummary.Cells[“B29”].Value = _Created;
_sheetSummary.CheckBoxes(“obs2”).Object.value = true;

“obs2” is the name of the radio button in the excel file. As I noted the other excel values update perfectly with no problem, but when I try to modify the radio button, I get nothing…

Any assistance would be greatly welcomed…

2

@Orthalt

Thanks for using Aspose APIs.

OBS2 is not a valid name of the check box. Please name it something else like OBSSS2. OBS2 is a cell name. If you will type OBS2 in Name Box, you will jump to column OBS and row 2.

Please also note, Radio Button is also called Option Button in MS-Excel but they are not called Check Boxes. It means, Radio Button and Check Box are two different controls.

Besides, some of the controls are found inside Normal Controls and are also found inside ActiveX Controls. So Normal Control Check Box will be different than ActiveX Control Check Box.