Create XLTM File in Python

Create XLTM File Using Python

How to Create XLTM in Python

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

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