在 Python 中管理分页符
Contents
[
Hide
]
Aspose.Cells - 管理分页符
添加分页符
添加分页符使用Aspose.Cells Java 红宝石， 称呼添加分页符的方法分页符模块。您可以在下面看到代码示例。
Python 代码
def add_page_breaks(self):
\# Instantiating a Workbook object
workbook = self.Workbook(self.dataDir + "Book1.xls")
worksheets = workbook.getWorksheets()
worksheet = worksheets.get(0)
h_page_breaks = worksheet.getHorizontalPageBreaks()
h_page_breaks.add("Y30")
v_page_breaks = worksheet.getVerticalPageBreaks()
v_page_breaks.add("Y30")
\# Saving the modified Excel file in default (that is Excel 2003) format
workbook.save(self.dataDir + "Add Page Breaks.xls")
print "Add page breaks, please check the output file."清除所有分页符
使用清除所有分页符Aspose.Cells Java for Python， 称呼clear_all_page_breaks的方法分页符模块。您可以在下面看到代码示例。
Python 代码
def clear_all_page_breaks(self):
\# Instantiating a Workbook object
workbook = self.Workbook(self.dataDir + "Book1.xls")
workbook.getWorksheets().get(0).getHorizontalPageBreaks().clear()
workbook.getWorksheets().get(0).getVerticalPageBreaks().clear()
\# Saving the modified Excel file in default (that is Excel 2003) format
workbook.save(self.dataDir + "Clear All Page Breaks.xls")
print "Clear all page breaks, please check the output file."删除特定分页符
使用删除特定分页符Aspose.Cells Java for Python， 称呼删除分页符的方法分页符模块。您可以在下面看到代码示例。
Python 代码
def remove_page_break(self):
\# Instantiating a Workbook object
workbook = self.Workbook(self.dataDir + "Book1.xls")
worksheets = workbook.getWorksheets()
worksheet = worksheets.get(0)
h_page_breaks = worksheet.getHorizontalPageBreaks()
h_page_breaks.removeAt(0)
v_page_breaks = worksheet.getVerticalPageBreaks()
v_page_breaks.removeAt(0)
\# Saving the modified Excel file in default (that is Excel 2003) format
workbook.save(self.dataDir + "Remove Page Break.xls")
print "Remove page break, please check the output file."下载运行代码
下载**管理分页符 (Aspose.Cells)**来自以下任何社交编码网站：