Freeze Panes in Python
Contents
[
Hide
]
Aspose.Cells - Freeze Panes
To Freeze Panes in the Spreadsheet Document using Aspose.Cells Java for Python, simply invoke FreezePanes module.
Python Code
workbook = self.Workbook(self.dataDir + "Book1.xls")
#Accessing the first worksheet in the Excel file
worksheets = workbook.getWorksheets()
worksheet = worksheets.get(0)
#Applying freeze panes settings
worksheet.freezePanes(3,2,3,2)
#Saving the modified Excel file in default format
workbook.save(self.dataDir + "book.out.xls")
#Print Message
print "Panes freeze successfull."
Download Running Code
Download Hello World (Aspose.Cells) from any of the below mentioned social coding sites: