Remove ActiveX Control

Remove ActiveX Control

Aspose.Cells provides the ability to remove ActiveX Control from workbooks. For this, the API provides the Shape.RemoveActiveXControl method. The following code snippet demonstrates the use of the Shape.RemoveActiveXControl method to remove ActiveX Control.

Sample Code

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
//Source directory
string sourceDir = RunExamples.Get_SourceDirectory();
//Output directory
string outputDir = RunExamples.Get_OutputDirectory();
// Create a workbook
Workbook wb = new Workbook(sourceDir + "sampleUpdateActiveXComboBoxControl.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)
{
// Remove Shape ActiveX Control
shape.RemoveActiveXControl();
}
// Save the workbook
wb.Save(outputDir + "RemoveActiveXControl_our.xlsx");