Create ODS File in Python

Create ODS File Using Python

How to Create ODS in Python

It is easy for the developers to create, load, modify and convert ODS 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 ODS 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 ODS file.
workbook.save("output.ods")

Python library to create ODS 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.