在Jython中对行和列进行分组和取消分组
Contents
[
Hide
]
Aspose.Cells - 对行和列进行分组和取消分组
使用Aspose.Cells Java for Jython进行附加文档。这里可以看到示例代码。
Jython 代码
from aspose-cells import Settings
from com.aspose.cells import Workbook
class RowsAndColumns:
def __init__(self):
dataDir = Settings.dataDir + 'WorkingWithRowsAndColumns/RowsAndColumns'
# Grouping Rows & Columns
self.group_rows_columns()
# Ungrouping Rows & Columns
self.ungroup_rows_columns()
def group_rows_columns(dataDir):
dataDir = Settings.dataDir + 'WorkingWithRowsAndColumns/RowsAndColumns/'
# Instantiating a Workbook object by excel file path
workbook = Workbook(dataDir + 'Book1.xls')
# Accessing the first worksheet in the Excel file
worksheet = workbook.getWorksheets().get(0)
cells = worksheet.getCells()
# Grouping first six rows (from 0 to 5) and making them hidden by passing true
cells.groupRows(0,5,True)
# Grouping first three columns (from 0 to 2) and making them hidden by passing true
cells.groupColumns(0,2,True)
# Saving the modified Excel file in default (that is Excel 2003) format
workbook.save(dataDir + "Group Rows And Columns.xls")
print "Group Rows And Columns Successfully."
def ungroup_rows_columns(dataDir):
dataDir = Settings.dataDir + 'WorkingWithRowsAndColumns/RowsAndColumns/'
# Instantiating a Workbook object by excel file path
workbook = Workbook(dataDir + 'Group Rows And Columns.xls')
# Accessing the first worksheet in the Excel file
worksheet = workbook.getWorksheets().get(0)
cells = worksheet.getCells()
# Ungrouping first six rows (from 0 to 5)
cells.ungroupRows(0,5)
# Ungrouping first three columns (from 0 to 2)
cells.ungroupColumns(0,2)
# Saving the modified Excel file in default (that is Excel 2003) format
workbook.save(dataDir + "Ungroup Rows And Columns.xls")
print "Ungroup Rows And Columns Successfully."
if __name__ == '__main__':
RowsAndColumns()
下载运行代码
从以下任何社交编码网站下载Append Documents (Aspose.Cells)