Agregar controles ActiveX usando Aspose.Cells

Agregar control ActiveX de botón de alternancia con Aspose.Cells

El siguiente código de muestra agrega un control ActiveX de botón de alternancia utilizando Aspose.Cells. Descargue el archivo de Excel de salida generado con este código para su referencia.

// 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);