Aspose.Cells.Examples.CSharp.Articles.UpdateActiveXComboBoxControl.Run C# (CSharp) Метод

        public static void Run()
        {
            // ExStart:UpdateActiveXComboBoxControl
            // The path to the documents directory.
            string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

            // Create a workbook
            Workbook wb = new Workbook(dataDir + "SourceFile.xlsx");

            // Access first shape from first worksheet
            Shape shape = wb.Worksheets[0].Shapes[0];

            // Access ActiveX ComboBox Control and update its value
            if (shape.ActiveXControl != null)
            {
                // Access Shape ActiveX Control
                ActiveXControl c = shape.ActiveXControl;

                // Check if ActiveX Control is ComboBox Control
                if (c.Type == ControlType.ComboBox)
                {
                    // Type cast ActiveXControl into ComboBoxActiveXControl and change its value
                    ComboBoxActiveXControl comboBoxActiveX = (ComboBoxActiveXControl)c;
                    comboBoxActiveX.Value = "This is combo box control with updated value.";
                }
            }

            // Save the workbook
            wb.Save(dataDir + "OutputFile_out.xlsx");
            // ExEnd:UpdateActiveXComboBoxControl
        }
    }