How to Rotate a Cell in Excel in Python. For more information, please follow link: https://kb.aspose.com/cells/python/how-to-rotate-a-cell-in-excel-using-python/

How to Rotate a Cell in Excel in Python.py

import jpype
import csv
import asposecells
jpype.startJVM()
from asposecells.api import License, Workbook


# Instantiate a license to avoid watermark in the output Excel file having pivot table
cellsLicense = License()
cellsLicense.setLicense("Aspose.Cells.lic")

# Instantiate a workbook
wbForRotatedText =  Workbook()

# Get first worksheet
wsForRotatedText = wbForRotatedText.getWorksheets().get(0)

# Get cells collection
cellsForRotatedText = wsForRotatedText.getCells()

# Get target cell
cellForRotatedText = cellsForRotatedText.get("D5")

# Put cell text
cellForRotatedText.putValue("Text to be rotated")

# Get cell style
objStyle = cellForRotatedText.getStyle()

# Set rotation angle
objStyle.setRotationAngle(90)

# Set cell style
cellForRotatedText.setStyle(objStyle)

# Save the workbook
wbForRotatedText.save("RotateText_test.xlsx")

jpype.shutdownJVM()