Excel 主题和颜色
Contents
[
Hide
]
如何在Excel中应用和创建颜色方案
文档主题使得轻松协调Excel文档的颜色、字体和图形格式效果，并快速更新它们。
主题提供统一的外观，包括命名样式、图形效果和工作簿中使用的其他对象。例如，Accent1 样式在 Office 和 Apex 主题中的外观不同。通常，您会应用文档主题，然后根据需要进行修改。
如何在Excel中应用颜色方案
- 打开Excel，并转到Excel功能区的"页面布局"选项卡。
- 在"主题"部分的"颜色"按钮上单击。
- 选择与您的要求相匹配的调色板，或将鼠标悬停在一个方案上以查看实时预览。
如何在Excel中创建自定义颜色方案
您可以创建自己的颜色集，为您的文档带来新的、独特的外观，或者遵守您组织的品牌标准。
-
打开Excel，并转到Excel功能区的"页面布局"选项卡。
-
在"主题"部分的"颜色"按钮上单击。
-
单击"自定义颜色…" 按钮。
-
在"创建新主题颜色"对话框中，您可以通过单击旁边的颜色下拉菜单来选择每个元素的颜色。您可以从调色板中选择颜色，或者使用"更多颜色"选项定义自定义颜色。
-
在选择所有所需的颜色后，在“名称”字段中提供自定义颜色方案的名称。
-
点击“保存”按钮以保存您的自定义颜色方案。 您的自定义颜色方案现在将在“颜色”下拉菜单中可供将来使用。
如何在Aspose.Cells中创建和应用颜色方案
Aspose.Cells提供了自定义主题和颜色的功能。
如何在Aspose.Cells中创建自定义颜色主题
如果文件中使用了主题色，我们无需逐个修改每个单元格，只需修改主题中的颜色即可。
以下示例显示如何应用具有您所需颜色的自定义主题。 我们使用在Microsoft Excel 2007中手动创建的示例模板文件。
以下示例加载一个模板 XLSX 文件，为不同的主题色类型定义颜色，应用自定义颜色，然后保存 Excel 文件。
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Example</title>
</head>
<body>
<h1>Apply Custom Theme Example</h1>
<input type="file" id="fileInput" accept=".xls,.xlsx,.csv" />
<button id="runExample">Run Example</button>
<a id="downloadLink" style="display: none;">Download Result</a>
<div id="result"></div>
</body>
<script src="aspose.cells.js.min.js"></script>
<script type="text/javascript">
const { Workbook, SaveFormat, Color } = AsposeCells;
AsposeCells.onReady({
license: "/lic/aspose.cells.enc",
fontPath: "/fonts/",
fontList: [
"arial.ttf",
"NotoSansSC-Regular.ttf"
]
}).then(() => {
console.log("Aspose.Cells initialized");
});
document.getElementById('runExample').addEventListener('click', async () => {
const fileInput = document.getElementById('fileInput');
if (!fileInput.files.length) {
document.getElementById('result').innerHTML = '<p style="color: red;">Please select an Excel file.</p>';
return;
}
const file = fileInput.files[0];
const arrayBuffer = await file.arrayBuffer();
// Instantiating a Workbook object by opening the uploaded Excel file
const workbook = new Workbook(new Uint8Array(arrayBuffer));
// Define Color array (of 12 colors) for Theme.
const carr = [
new Color("AntiqueWhite"), // Background1
new Color("Brown"), // Text1
new Color("AliceBlue"), // Background2
new Color("Yellow"), // Text2
new Color("YellowGreen"), // Accent1
new Color("Red"), // Accent2
new Color("Pink"), // Accent3
new Color("Purple"), // Accent4
new Color("PaleGreen"), // Accent5
new Color("Orange"), // Accent6
new Color("Green"), // Hyperlink
new Color("Gray") // Followed Hyperlink
];
// Set the custom theme with specified colors.
workbook.customTheme("CustomeTheme1", carr);
// Save as the excel file.
const outputData = workbook.save(SaveFormat.Xlsx);
const blob = new Blob([outputData]);
const downloadLink = document.getElementById('downloadLink');
downloadLink.href = URL.createObjectURL(blob);
downloadLink.download = 'output.out.xlsx';
downloadLink.style.display = 'block';
downloadLink.textContent = 'Download Modified Excel File';
document.getElementById('result').innerHTML = '<p style="color: green;">Custom theme applied successfully! Click the download link to get the modified file.</p>';
});
</script>
</html>
如何在Aspose.Cells中应用主题颜色
以下示例根据工作簿的默认主题色类型，应用单元格的前景色和字体颜色。它还将 Excel 文件保存到磁盘。
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Example</title>
</head>
<body>
<h1>Aspose.Cells Example</h1>
<input type="file" id="fileInput" accept=".xls,.xlsx,.csv" />
<button id="runExample">Run Example</button>
<a id="downloadLink" style="display: none;">Download Result</a>
<div id="result"></div>
</body>
<script src="aspose.cells.js.min.js"></script>
<script type="text/javascript">
const { Workbook, SaveFormat } = AsposeCells;
AsposeCells.onReady({
license: "/lic/aspose.cells.enc",
fontPath: "/fonts/",
fontList: [
"arial.ttf",
"NotoSansSC-Regular.ttf"
]
}).then(() => {
console.log("Aspose.Cells initialized");
});
document.getElementById('runExample').addEventListener('click', async () => {
// Instantiate a Workbook.
const workbook = new Workbook();
// Get cells collection in the first (default) worksheet.
const cells = workbook.worksheets.get(0).cells;
// Get the D3 cell.
const c = cells.get("D3");
// Get the style of the cell.
const s = c.style;
// Set foreground color for the cell from the default theme Accent2 color.
s.foregroundThemeColor = new AsposeCells.ThemeColor(AsposeCells.ThemeColorType.Accent2, 0.5);
// Set the pattern type.
s.pattern = AsposeCells.BackgroundType.Solid;
// Get the font for the style.
const f = s.font;
// Set the theme color.
f.themeColor = new AsposeCells.ThemeColor(AsposeCells.ThemeColorType.Accent4, 0.1);
// Apply style.
c.style = s;
// Put a value.
c.value = "Testing1";
// Save the excel file and provide download link.
const outputData = workbook.save(SaveFormat.Xlsx);
const blob = new Blob([outputData]);
const downloadLink = document.getElementById('downloadLink');
downloadLink.href = URL.createObjectURL(blob);
downloadLink.download = 'output.out.xlsx';
downloadLink.style.display = 'block';
downloadLink.textContent = 'Download Excel File';
document.getElementById('result').innerHTML = '<p style="color: green;">Workbook created. Click the download link to save the file.</p>';
});
</script>
</html>
如何在Aspose.Cells中获取和设置主题颜色
以下是实现主题颜色的几种方法和属性。
- Style.foregroundThemeColor：用于设置前景色。
- Style.backgroundThemeColor：用于设置背景色。
- Font.themeColor：用于设置字体颜色。
- Workbook.themeColor：用于获取主题色。
- Workbook.themeColor：用于设置主题色。
以下示例演示如何获取和设置主题颜色。
以下示例使用模板 XLSX 文件，获取不同主题色类型的颜色，修改颜色，然后保存为 Microsoft Excel 文件。
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Example</title>
</head>
<body>
<h1>Theme Color Example</h1>
<input type="file" id="fileInput" accept=".xls,.xlsx,.csv" />
<button id="runExample">Run Example</button>
<a id="downloadLink" style="display: none;">Download Result</a>
<div id="result"></div>
</body>
<script src="aspose.cells.js.min.js"></script>
<script type="text/javascript">
const { Workbook, SaveFormat, Color, ThemeColorType } = AsposeCells;
AsposeCells.onReady({
license: "/lic/aspose.cells.enc",
fontPath: "/fonts/",
fontList: [
"arial.ttf",
"NotoSansSC-Regular.ttf"
]
}).then(() => {
console.log("Aspose.Cells initialized");
});
document.getElementById('runExample').addEventListener('click', async () => {
const fileInput = document.getElementById('fileInput');
if (!fileInput.files.length) {
document.getElementById('result').innerHTML = '<p style="color: red;">Please select an Excel file.</p>';
return;
}
const file = fileInput.files[0];
const arrayBuffer = await file.arrayBuffer();
// Instantiating a Workbook object and opening the uploaded Excel file
const workbook = new Workbook(new Uint8Array(arrayBuffer));
// Get the Background1 theme color.
let c = workbook.themeColor(ThemeColorType.Background1);
console.log("theme color Background1: ", c);
// Get the Accent2 theme color.
c = workbook.themeColor(ThemeColorType.Accent2);
console.log("theme color Accent2: ", c);
// Change the Background1 theme color.
workbook.themeColor(ThemeColorType.Background1, Color.Red);
// Get the updated Background1 theme color.
c = workbook.themeColor(ThemeColorType.Background1);
console.log("theme color Background1 changed to: ", c);
// Change the Accent2 theme color.
workbook.themeColor(ThemeColorType.Accent2, Color.Blue);
// Get the updated Accent2 theme color.
c = workbook.themeColor(ThemeColorType.Accent2);
console.log("theme color Accent2 changed to: ", c);
// Saving the updated file
const outputData = workbook.save(SaveFormat.Xlsx);
const blob = new Blob([outputData]);
const downloadLink = document.getElementById('downloadLink');
downloadLink.href = URL.createObjectURL(blob);
downloadLink.download = 'output.out.xlsx';
downloadLink.style.display = 'block';
downloadLink.textContent = 'Download Updated Excel File';
// Display results
let resultHtml = '';
resultHtml += `<p>theme color Background1: ${JSON.stringify(workbook.themeColor(ThemeColorType.Background1))}</p>`;
resultHtml += `<p>theme color Accent2: ${JSON.stringify(workbook.themeColor(ThemeColorType.Accent2))}</p>`;
document.getElementById('result').innerHTML = '<p style="color: green;">Operation completed successfully! See console for detailed logs.</p>' + resultHtml;
});
</script>
</html>