Adjust Row Height and Column Width in Excel using Python

readme.md

Read the complete article on how to adjust row height and column width in Excel using Python: https://blog.aspose.com/cells/adjust-row-height-column-width-in-excel-python/

set-column-width.py

import jpype
import asposecells

jpype.startJVM()
from asposecells.api import Workbook

# Load Excel file
workbook = Workbook("source.xlsx")

# Access the first worksheet in the Excel file
worksheet = workbook.getWorksheets().get(0)

# Get cells collection
cells = worksheet.getCells()

# Set the height of the second column to 40
cells.setColumnWidth(1, 40)

# Save the updated Excel file
workbook.save("column-adjustment.xlsx")

set-row-height.py

import jpype
import asposecells

jpype.startJVM()
from asposecells.api import Workbook

# Load Excel file
workbook = Workbook("source.xlsx")

# Access the first worksheet in the Excel file
worksheet = workbook.getWorksheets().get(0)

# Get cells collection
cells = worksheet.getCells()

# Set the height of the second row to 50
cells.setRowHeight(1, 50)

# Save the updated Excel file
workbook.save("row-adjustment.xlsx")