Create OTS File in Python Excel Library

Create OTS File Using Python Excel Library

How to Create OTS in Python Excel Library

It is easy for the developers to create, load, modify and convert OTS files within running different reporting applications for data processing in just a few lines of code.

1. Create Workbook class instance.
2. Access the first worksheet of the workbook.
3. Get the desired cell(s) of the worksheet and input the value into the cell(s).
4. Use Save method to save the workbook as OTS file.

from aspose import pycore
from aspose.cells import Workbook, SaveFormat, FileFormatType

# Create Workbook object.
workbook = Workbook()

# Access the first worksheet of the workbook.
worksheet = workbook.worksheets[0]

# Get the desired cell(s) of the worksheet and input the value into the cell(s).
worksheet.cells.get("A1").put_value("ColumnA")
worksheet.cells.get("B1").put_value("ColumnB")
worksheet.cells.get("A2").put_value("ValueA")
worksheet.cells.get("B2").put_value("ValueB")

# Save the workbook as OTS file.
workbook.save("output.ots")

Python Excel Library to Create OTS File

We host our Python packages in PyPi repositories.

Install Aspose.Cells for Python from pypi, use command as: $ pip install aspose-cells-python.

And you can also follow the step-by-step instructions on how to install “Aspose.Cells for Python via .NET” to your developer environment.

System Requirements

Aspose.Cells for Python is platform-independent API and can be used on any platform (Windows, Linux), just make sure that system have Python 3.7 or higher.