Add Borders in Excel using Python. For more details: https://kb.aspose.com/cells/python/add-borders-in-excel-using-python/

Add Borders in Excel using Python.py

import jpype
jpype.startJVM()

from asposecells.api import Workbook, CellBorderType, Color

# Instantiate a workbook
book = Workbook()

# Get access to a sheet
sheet = book.getWorksheets().get("Sheet1")

# Set sample text
sheet.getCells().get(1, 0).putValue("Thick Lines")

# Create a range of cells for setting border
borderRange = sheet.getCells().createRange("C2", "C2")

# Set the borders for the defined range of cells
borderRange.setOutlineBorders(CellBorderType.THICK, Color.getBlack())

# Adjust columns width
sheet.autoFitColumn(2)

# Save the output
book.save("Borders.xlsx")

print("Border added successfully")
jpype.shutdownJVM()