隐藏和显示 Python 中的行和列
Contents
[
Hide
]
Aspose.Cells - 控制行和列的可见性
如何隐藏行和列
开发者可以分别调用Cells集合的HideRow和HideColumn方法来隐藏行或列。这两种方法都以行/列索引作为参数来隐藏特定的行或列。
红宝石代码
def hide_rows_columns(self):
\# Instantiating a Workbook object by excel file path
workbook = self.Workbook(self.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(self.dataDir + "Hide Rows And Columns.xls")
print "Hide Rows And Columns Successfully."
如何显示行和列
开发人员可以通过分别调用 Cells 集合的 UnhideRow 和 UnhideColumn 方法来取消隐藏任何隐藏的行或列。两种方法都采用两个参数:
- 行/列索引行或列的索引,用于显示特定的行或列。
- 行高或列宽显示后分配给行或列的行高或列宽。
红宝石代码
def unhide_rows_columns(self):
\# Instantiating a Workbook object by excel file path
workbook = self.Workbook(self.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(self.dataDir + "Unhide Rows And Columns.xls")
print "Unhide Rows And Columns Successfully."
下载运行代码
下载**控制行和列的可见性 (Aspose.Cells)**来自以下任何一个社交编码网站: