显示和隐藏行、列和滚动条
显示和隐藏行和列
Aspose.Cells提供了一个表示Microsoft Excel文件的类Workbook。Workbook 类包含一个Worksheets集合,允许开发人员访问Excel文件中的每个工作表。一个工作表由Worksheet类表示。Worksheet 类提供了一个Cells集合,代表工作表中的所有单元格。Cells集合提供了若干用于管理工作表中的行或列的方法。其中一些将在下面讨论。
显示行和列
开发人员可以通过调用Cells集合的UnhideRow和UnhideColumn方法,分别显示任何隐藏的行或列。两种方法都需要两个参数:
- 行或列索引 - 用于显示特定行或列的索引。
- 行高或列宽 - 在取消隐藏后分配给行或列的行高或列宽。
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
// The path to the documents directory. | |
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); | |
// Creating a file stream containing the Excel file to be opened | |
FileStream fstream = new FileStream(dataDir + "book1.xls", FileMode.Open); | |
// Instantiating a Workbook object | |
// Opening the Excel file through the file stream | |
Workbook workbook = new Workbook(fstream); | |
// Accessing the first worksheet in the Excel file | |
Worksheet worksheet = workbook.Worksheets[0]; | |
// Unhiding the 3rd row and setting its height to 13.5 | |
worksheet.Cells.UnhideRow(2, 13.5); | |
// Unhiding the 2nd column and setting its width to 8.5 | |
worksheet.Cells.UnhideColumn(1, 8.5); | |
// Saving the modified Excel file | |
workbook.Save(dataDir + "output.xls"); | |
// Closing the file stream to free all resources | |
fstream.Close(); |
隐藏行和列
开发人员可以通过调用Cells集合的HideRow和HideColumn方法,分别隐藏行或列。两种方法都以行索引或列索引作为参数,以隐藏特定的行或列。
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
// The path to the documents directory. | |
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); | |
// Creating a file stream containing the Excel file to be opened | |
FileStream fstream = new FileStream(dataDir + "book1.xls", FileMode.Open); | |
// Instantiating a Workbook object | |
// Opening the Excel file through the file stream | |
Workbook workbook = new Workbook(fstream); | |
// Accessing the first worksheet in the Excel file | |
Worksheet worksheet = workbook.Worksheets[0]; | |
// Hiding the 3rd row of the worksheet | |
worksheet.Cells.HideRow(2); | |
// Hiding the 2nd column of the worksheet | |
worksheet.Cells.HideColumn(1); | |
// Saving the modified Excel file | |
workbook.Save(dataDir + "output.out.xls"); | |
// Closing the file stream to free all resources | |
fstream.Close(); |
隐藏多个行和列
开发人员可以通过调用Cells集合的HideRows和HideColumns方法,分别一次隐藏多行或列。两种方法都需要起始行或列索引和应该隐藏的行数或列数作为参数。
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
// The path to the documents directory. | |
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); | |
// Creating a file stream containing the Excel file to be opened | |
FileStream fstream = new FileStream(dataDir + "book1.xls", FileMode.Open); | |
// Instantiating a Workbook object | |
// Opening the Excel file through the file stream | |
Workbook workbook = new Workbook(fstream); | |
// Accessing the first worksheet in the Excel file | |
Worksheet worksheet = workbook.Worksheets[0]; | |
// Hiding 3,4 and 5 rows in the worksheet | |
worksheet.Cells.HideRows(2, 3); | |
// Hiding 2 and 3 columns in the worksheet | |
worksheet.Cells.HideColumns(1, 2); | |
// Saving the modified Excel file | |
workbook.Save(dataDir + "outputxls"); | |
// Closing the file stream to free all resources | |
fstream.Close(); |
显示和隐藏滚动条
滚动条用于浏览任何文件的内容。通常有两种类型的滚动条:
- 垂直滚动条
- 水平滚动条
Microsoft Excel还提供水平和垂直滚动条,以便用户可以滚动工作表内容。使用Aspose.Cells,开发人员可以控制Excel文件中两种类型滚动条的可见性。
控制滚动条的可见性
Aspose.Cells 提供了代表 Excel 文件的一个类,Workbook。Workbook 类提供了一系列用于管理 Excel 文件的属性和方法。要控制滚动条的可见性,请使用 Workbook 类的 WorkbookSettings.IsVScrollBarVisible 和 WorkbookSettings.IsHScrollBarVisible 属性。WorkbookSettings.IsVScrollBarVisible 和 WorkbookSettings.IsHScrollBarVisible 都是布尔属性,这意味着这些属性只能存储 true 或 false 值。
显示滚动条
通过将 Workbook 类的 WorkbookSettings.IsVScrollBarVisible 或 WorkbookSettings.IsHScrollBarVisible 属性设置为 true 来使滚动条可见。
隐藏滚动条
通过将 Workbook 类的 WorkbookSettings.IsVScrollBarVisible 或 WorkbookSettings.IsHScrollBarVisible 属性设置为 false 来隐藏滚动条。
示例代码
下面是一个完整的代码,打开一个Excel文件book1.xls,隐藏两个滚动条,然后将修改后的文件保存为output.xls。
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
// The path to the documents directory. | |
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); | |
// Creating a file stream containing the Excel file to be opened | |
FileStream fstream = new FileStream(dataDir + "book1.xls", FileMode.Open); | |
// Instantiating a Workbook object | |
// Opening the Excel file through the file stream | |
Workbook workbook = new Workbook(fstream); | |
// Hiding the vertical scroll bar of the Excel file | |
workbook.Settings.IsVScrollBarVisible = false; | |
// Hiding the horizontal scroll bar of the Excel file | |
workbook.Settings.IsHScrollBarVisible = false; | |
// Saving the modified Excel file | |
workbook.Save(dataDir + "output.xls"); | |
// Closing the file stream to free all resources | |
fstream.Close(); |