PNG
JPG
BMP
TIFF
XLSX
Insert ComboBox(Form control) into Excel using Python via java
Insert objects using server-side APIs without any software like Microsoft or Open Office, Adobe PDF, etc.
How to Insert ComboBox(Form control) into Excel File Using Python via java
In order to insert ComboBox(Form control) into excel file, we’ll use
Aspose.Cells for Python via java
API which is a feature-rich, powerful and easy to use document manipulation API for Python via java platform.The API provides Excel file creation, manipulation, conversion and rendering. All without relying on Microsoft Office or Excel applications.You can install from the console using the following command.
Command
> pip install aspose-cells
Steps to insert ComboBox(Form control) to Excel file using Python via java
You need the Aspose.Cells to try the following workflow in your own environment.
- Instantiating a Workbook object.(or->Load the XLSX file with full path.)
- Select Worksheet via its index.
- Use the shapecollection’s add method to insert a ComboBox(Form control) in the selected worksheet.
- Save workbook in XLSX format.
System Requirements
Aspose.Cells for Python via java is platform-independent API and can be used on any platform (Windows, Linux and MacOS), just make sure that system have Java 1.8 or higher, Python 3.5 or higher.
- Any operating system that can run Python via java scripts, such as Windows, Linux and MacOS
- Install Java and add it to PATH environment variable, for example:
PATH=C:\Program Files\Java\jdk1.8.0_131;
. - Install Aspose.Cells for Python via java from pypi, use command as:
$ pip install aspose-cells
.