Table of Contents

ExcelFile.GetRadioButtonState Method

Gets if a radio button in the active sheet is selected or not. Note that this only works for radio buttons added through the Forms toolbar. It won't return the values of ActiveX radio buttons.

Remarks

Note that if the radio button is linked to a cell and you changed the cell value, this method will return the cell value.

Syntax

Namespace: FlexCel.Core

public abstract Boolean GetRadioButtonState(Int32 objectIndex, String objectPath)

Parameters

<-> Parameter Type Description
objectIndex Int32 Index of the object (1 based)
objectPath String Index to the child object you want to change the property.
If it is a simple object, you can use String.Empty here, if not you need to get the ObjectPath from GetObjectProperties(Int32, Boolean)
If it is "absolute"(it starts with "\"), then the path includes the objectIndex, and the objectIndex is not used. An object path of "\1\2\3" is exactly the same as using objectIndex = 1 and objectPath = "2\3"

Returns

If the radio button is selected or not.

Examples

To get all the radio buttons in the active sheet, you can use this code:

    XlsFile xls = new XlsFile("radiobuttons.xls"); //Open the file we want to read.
    for (int i = 1; i <= xls.ObjectCount; i++) //Loop over all objects.
    {
        TShapeProperties shp = xls.GetObjectProperties(i, false);
        if (shp.ObjectType == TObjectType.OptionButton) //Is it a radio button?
        {
            LogMessage(shp.Text + " :" + xls.GetRadioButtonState(i, null).ToString()); //Log the state of the radio button.
        }
    }

See also