Split Panes in Python

Aspose.Cells - Split Panes

To Split Panes using Aspose.Cells Java for Python, simply invoke SplitPanes module.

Python Code

 saveFormat = self.SaveFormat;

workbook = self.Workbook(self.dataDir + "Book1.xls")

#Set the active cell

workbook.getWorksheets().get(0).setActiveCell("A20");

#Split the worksheet window

workbook.getWorksheets().get(0).split();

#Save the excel file

workbook.save(self.dataDir + "book.out.xls", saveFormat.EXCEL_97_TO_2003);

#Print Message

print "Panes split successfully."

Download Running Code

Download Split Panes (Aspose.Cells) from any of the below mentioned social coding sites:

• GitHub