在加载工作簿时过滤定义名称
Contents
[
Hide
]
可能的使用场景
Aspose.Cells for Python via .NET 允许你过滤或删除工作簿内的定义名称。加载工作簿时,请使用 LoadDataFilterOptions.DEFINED_NAMES 来加载定义名称,使用 ~LoadDataFilterOptions.DEFINED_NAMES 来删除它们。请注意,如果删除定义名称,工作簿内的公式可能会出错。
在加载工作簿时过滤定义名称
以下示例代码加载了包含单元格C1中包含定义名称的公式的示例Excel文件。由于在加载工作簿时使用了~LoadDataFilterOptions.DEFINED_NAMES来移除定义名称,所以输出Excel文件中单元格C1中的公式中断了,您会看到*#NAME?*。请参阅以下截图,显示了代码对示例Excel文件的影响。
示例代码
This file contains hidden or 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
from aspose.cells import LoadDataFilterOptions, LoadFilter, LoadOptions, Workbook | |
# Specify the load options | |
opts = LoadOptions() | |
# We do not want to load defined names | |
opts.load_filter = LoadFilter(~LoadDataFilterOptions.DEFINED_NAMES) | |
# Load the workbook | |
wb = Workbook(sourceDir + "sampleFilterDefinedNamesWhileLoadingWorkbook.xlsx", opts) | |
# Save the output Excel file, it will break the formula in C1 | |
wb.save(outputDir + "outputFilterDefinedNamesWhileLoadingWorkbook.xlsx") | |
print("FilterDefinedNamesWhileLoadingWorkbook executed successfully.") |