在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'
# Hiding Rows and Columns
self.hide_rows_columns()
# Showing Rows and Columns
self.unhide_rows_columns()
def hide_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()
# Hiding the 3rd row of the worksheet
cells.hideRow(2)
# Hiding the 2nd column of the worksheet
cells.hideColumn(1)
# Saving the modified Excel file in default (that is Excel 2003) format
workbook.save(dataDir + "Hide Rows And Columns.xls")
print "Hide Rows And Columns Successfully."
def unhide_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()
# Unhiding the 3rd row and setting its height to 13.5
cells.unhideRow(2,13.5)
# Unhiding the 2nd column and setting its width to 8.5
cells.unhideColumn(1,8.5)
# Saving the modified Excel file in default (that is Excel 2003) format
workbook.save(dataDir + "Unhide Rows And Columns.xls")
print "Unhide Rows And Columns Successfully."
if __name__ == '__main__':
RowsAndColumns()
下载运行代码
从以下任何社交编码网站下载Append Documents (Aspose.Cells)