Excel 主题和颜色

如何在Excel中应用和创建颜色方案

文档主题使得轻松协调Excel文档的颜色、字体和图形格式效果，并快速更新它们。主题提供了具有命名样式、图形效果和工作簿中使用的其他对象的统一外观。例如，Accent1样式在Office和Apex主题中看起来不同。通常，您应用文档主题，然后修改它以满足您的要求。

您可以创建自己的颜色集，为您的文档带来新的、独特的外观，或者遵守您组织的品牌标准。

Aspose.Cells提供了自定义主题和颜色的功能。

如果文件中使用主题颜色，则我们无需逐个修改每个单元格，我们只需要修改主题中的颜色。

以下示例显示如何应用具有您所需颜色的自定义主题。我们使用在Microsoft Excel 2007中手动创建的示例模板文件。

下面的示例加载一个模板XLSX文件，为不同的主题颜色类型定义颜色，应用自定义颜色并保存Excel文件。

	// 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);

	// Define Color array (of 12 colors) for Theme.
	Color[] carr = new Color[12];
	carr[0] = Color.AntiqueWhite; // Background1
	carr[1] = Color.Brown; // Text1
	carr[2] = Color.AliceBlue; // Background2
	carr[3] = Color.Yellow; // Text2
	carr[4] = Color.YellowGreen; // Accent1
	carr[5] = Color.Red; // Accent2
	carr[6] = Color.Pink; // Accent3
	carr[7] = Color.Purple; // Accent4
	carr[8] = Color.PaleGreen; // Accent5
	carr[9] = Color.Orange; // Accent6
	carr[10] = Color.Green; // Hyperlink
	carr[11] = Color.Gray; // Followed Hyperlink

	// Instantiate a Workbook.
	// Open the template file.
	Workbook workbook = new Workbook(dataDir + "book1.xlsx");

	// Set the custom theme with specified colors.
	workbook.CustomTheme("CustomeTheme1", carr);

	// Save as the excel file.
	workbook.Save(dataDir + "output.out.xlsx");

下面的示例根据工作簿的默认主题颜色类型，应用单元格的前景色和字体颜色。它还将Excel文件保存到磁盘。

	// 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);

	// Create directory if it is not already present.
	bool IsExists = System.IO.Directory.Exists(dataDir);
	if (!IsExists)
	System.IO.Directory.CreateDirectory(dataDir);

	// Instantiate a Workbook.
	Workbook workbook = new Workbook();

	// Get cells collection in the first (default) worksheet.
	Cells cells = workbook.Worksheets[0].Cells;

	// Get the D3 cell.
	Aspose.Cells.Cell c = cells["D3"];

	// Get the style of the cell.
	Style s = c.GetStyle();

	// Set foreground color for the cell from the default theme Accent2 color.
	s.ForegroundThemeColor = new ThemeColor(ThemeColorType.Accent2, 0.5);

	// Set the pattern type.
	s.Pattern = BackgroundType.Solid;

	// Get the font for the style.
	Aspose.Cells.Font f = s.Font;

	// Set the theme color.
	f.ThemeColor = new ThemeColor(ThemeColorType.Accent4, 0.1);

	// Apply style.
	c.SetStyle(s);

	// Put a value.
	c.PutValue("Testing1");

	// Save the excel file.
	workbook.Save(dataDir + "output.out.xlsx");

以下是实现主题颜色的几种方法和属性。

以下示例演示如何获取和设置主题颜色。

以下示例使用了一个模板 XLSX 文件，获取了不同主题颜色类型的颜色，更改了颜色，然后保存了 Microsoft Excel 文件。

	// 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 Workbook object.
	// Open an exiting excel file.
	Workbook workbook = new Workbook(dataDir + "book1.xlsx");

	// Get the Background1 theme color.
	Color c = workbook.GetThemeColor(ThemeColorType.Background1);

	// Print the color.
	Console.WriteLine("theme color Background1: " + c);

	// Get the Accent2 theme color.
	c = workbook.GetThemeColor(ThemeColorType.Accent2);

	// Print the color.
	Console.WriteLine("theme color Accent2: " + c);

	// Change the Background1 theme color.
	workbook.SetThemeColor(ThemeColorType.Background1, Color.Red);

	// Get the updated Background1 theme color.
	c = workbook.GetThemeColor(ThemeColorType.Background1);

	// Print the updated color for confirmation.
	Console.WriteLine("theme color Background1 changed to: " + c);

	// Change the Accent2 theme color.
	workbook.SetThemeColor(ThemeColorType.Accent2, Color.Blue);

	// Get the updated Accent2 theme color.
	c = workbook.GetThemeColor(ThemeColorType.Accent2);

	// Print the updated color for confirmation.
	Console.WriteLine("theme color Accent2 changed to: " + c);

	// Save the updated file.
	workbook.Save(dataDir + "output.out.xlsx");