Add ActiveX Controls using Aspose.Cells

Add Toggle Button ActiveX Control using Aspose.Cells

The following sample code adds Toggle Button ActiveX Control using Aspose.Cells. Please download the output excel file generated with this code for your reference.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
// The path to the documents directory.
String dataDir = Utils.getDataDir(AddActiveXControl.class);
// Create workbook object
Workbook wb = new Workbook();
// Access first worksheet
Worksheet sheet = wb.getWorksheets().get(0);
// Add Toggle Button ActiveX Control inside the Shape Collection
Shape s = sheet.getShapes().addActiveXControl(ControlType.TOGGLE_BUTTON, 4, 0, 4, 0, 100, 30);
// Access the ActiveX control object and set its linked cell property
ActiveXControl c = s.getActiveXControl();
c.setLinkedCell("A1");
// Save the worbook in xlsx format
wb.save(dataDir + "output.xlsx", SaveFormat.XLSX);