Jython での改ページの管理
Contents
[
Hide
]
Aspose.Cells - ページの区切りを管理する
Aspose.Cells Java for Jythonを使用してドキュメントを追加します。ここでは例を示します。
Jythonコード
from aspose-cells import Settings
from com.aspose.cells import Workbook
from com.aspose.cells import SaveFormat
class ManagingPageBreaks:
def __init__(self):
# Adding Page Breaks
self.add_page_breaks()
# Clearing All Page Breaks
self.clear_all_page_breaks()
# Removing Specific Page Break
self.remove_page_break()
def add_page_breaks(dataDir):
dataDir = Settings.dataDir + 'WorkingWithWorksheets/ManagingPageBreaks/'
# Instantiating a Workbook object
workbook = Workbook(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(dataDir + "Add Page Breaks.xls")
print "Add page breaks, please check the output file."
def clear_all_page_breaks(dataDir):
dataDir = Settings.dataDir + 'WorkingWithWorksheets/ManagingPageBreaks/'
# Instantiating a Workbook object
workbook = Workbook(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(dataDir + "Clear All Page Breaks.xls")
print "Clear all page breaks, please check the output file."
def remove_page_break(dataDir):
dataDir = Settings.dataDir + 'WorkingWithWorksheets/ManagingPageBreaks/'
# Instantiating a Workbook object
workbook = Workbook(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(dataDir + "Remove Page Break.xls")
print "Remove page break, please check the output file."
if __name__ == '__main__':
ManagingPageBreaks()
ランニングコードのダウンロード
以下に示すいずれかのソーシャルコーディングサイトからAspose.Cellsのドキュメントを追加するをダウンロード: