Excel 主题和颜色

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

文档主题使得轻松协调Excel文档的颜色、字体和图形格式效果，并快速更新它们。
主题提供统一的外观，包括命名样式、图形效果和工作簿中使用的其他对象。例如，Accent1 样式在 Office 和 Apex 主题中的外观不同。通常，您会应用文档主题，然后根据需要进行修改。

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

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

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

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

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

	const path = require("path");
	const AsposeCells = require("aspose.cells.node");

	// The path to the documents directory.
	const dataDir = path.join(__dirname, "data");
	const filePath = path.join(dataDir, "book1.xlsx");

	// Define Color array (of 12 colors) for Theme.
	const carr = [
	new AsposeCells.Color("AntiqueWhite"), // Background1
	new AsposeCells.Color("Brown"), // Text1
	new AsposeCells.Color("AliceBlue"), // Background2
	new AsposeCells.Color("Yellow"), // Text2
	new AsposeCells.Color("YellowGreen"), // Accent1
	new AsposeCells.Color("Red"), // Accent2
	new AsposeCells.Color("Pink"), // Accent3
	new AsposeCells.Color("Purple"), // Accent4
	new AsposeCells.Color("PaleGreen"), // Accent5
	new AsposeCells.Color("Orange"), // Accent6
	new AsposeCells.Color("Green"), // Hyperlink
	new AsposeCells.Color("Gray") // Followed Hyperlink
	];

	// Instantiate a Workbook.
	// Open the template file.
	const workbook = new AsposeCells.Workbook(filePath);

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

	// Save as the excel file.
	workbook.save(path.join(dataDir, "output.out.xlsx"));

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

	const path = require("path");
	const AsposeCells = require("aspose.cells.node");

	// The path to the documents directory.
	const dataDir = path.join(__dirname, "data");

	// Create directory if it is not already present.
	if (!require("fs").existsSync(dataDir)) {
	require("fs").mkdirSync(dataDir);
	}

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

	// Get cells collection in the first (default) worksheet.
	const cells = workbook.getWorksheets().get(0).getCells();

	// Get the D3 cell.
	const c = cells.get("D3");

	// Get the style of the cell.
	const s = c.getStyle();

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

	// Set the pattern type.
	s.setPattern(AsposeCells.BackgroundType.Solid);

	// Get the font for the style.
	const f = s.getFont();

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

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

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

	// Save the excel file.
	workbook.save(path.join(dataDir, "output.out.xlsx"));

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

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

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

	const path = require("path");
	const AsposeCells = require("aspose.cells.node");

	// The path to the documents directory.
	const dataDir = path.join(__dirname, "data");
	const filePath = path.join(dataDir, "book1.xlsx");

	// Instantiate Workbook object.
	// Open an existing excel file.
	const workbook = new AsposeCells.Workbook(filePath);

	// Get the Background1 theme color.
	let c = workbook.getThemeColor(AsposeCells.ThemeColorType.Background1);

	// Print the color.
	console.log("theme color Background1: ", c);

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

	// Print the color.
	console.log("theme color Accent2: ", c);

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

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

	// Print the updated color for confirmation.
	console.log("theme color Background1 changed to: ", c);

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

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

	// Print the updated color for confirmation.
	console.log("theme color Accent2 changed to: ", c);

	// Save the updated file.
	workbook.save(path.join(dataDir, "output.out.xlsx"));