This article guides on using ActiveX controls in Excel using Node.js. It has the resources for setting the IDE for development, a list of steps for writing the application, and a sample code for adding an ActiveX command button using Node.js. You will learn the properties to customize the control shape and behavior.
Steps to Insert ActiveX Controls in Excel using Node.js
- Set the IDE to use Aspose.Cells for Node.js via Java for using ActiveX controls
- Create an empty workbook and access the shapes collection in the target sheet for adding a button ActiveX control
- Call the addActiveXControl() method from the ShapeCollection class
- Provide the destination cell references, offset from the cell, and size of the control
- Access the newly added control and link it with a cell
- Save the output file with an ActiveX control in it
These steps describe how to use ActiveX controls in Excel using Node.js. Create a workbook, access a sheet, and add an ActiveX control using the addActiveXControl() method in the ShapeCollection that is part of each worksheet. This method requires the control type, position, and size of the control.
Code to Add Active X Controls in Excel using Node.js
This code has demonstrated the usage of Active X for Excel using Node.js. The ControlType enumerator contains a long list of controls you can add to the sheet. Once you add an ActiveX control, you may typecast it to the respective control and set specific properties related to that control.
In this topic, we have learned to add an ActiveX control in an Excel file. To make a dropdown list in an Excel file, refer to the article on how to make a dropdown list in Excel using Node.js.