设置工作表标签颜色
Contents
[
Hide
]
Aspose.Cells允许您更改单个工作表标签的颜色,使其与其他工作表区分开。例如,您可以将支出设置为红色,销售设置为绿色,资产设置为蓝色,等等。
使用Microsoft Excel设置工作表标签颜色
- 在当前工作表底部的标签工作表上右键单击。
- 选择标签颜色。
- 从调色板中选择一种颜色。
- 点击确定。
使用Aspose.Cells设置工作表选项卡颜色
以下示例代码显示如何使用Aspose.Cells来设置选项卡颜色。
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// 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); | |
// Instantiate a new Workbook | |
// Open an Excel file | |
Workbook workbook = new Workbook(dataDir+ "Book1.xlsx"); | |
// Get the first worksheet in the book | |
Worksheet worksheet = workbook.Worksheets[0]; | |
// Set the tab color | |
worksheet.TabColor = Color.Red; | |
// Save the Excel file | |
workbook.Save(dataDir+ "worksheettabcolor.out.xls"); |