删除工作簿中的未使用样式

Contents
[ ]

下面的代码解释了Workbook.RemoveUnusedStyles()的用法。该代码加载了可以从提供的链接下载的模板Excel文件。它包含一个名为AsposeStyle的未使用样式,此样式和所有其他未使用的样式将在执行代码后被移除。

todo:image_alt_text

// 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);
// Load template excel file containing unused styles
Workbook workbook = new Workbook(dataDir + "Template-With-Unused-Custom-Style.xlsx");
// Remove all unused styles inside the template this will also remove AsposeStyle which is an unused style inside the template
workbook.RemoveUnusedStyles();
// Save the file
workbook.Save(dataDir + "output_out.xlsx");