Filter Defined Names while Loading a Workbook
Contents
[
Hide
]
Possible Usage Scenarios
Aspose.Cells allows you to filter or remove defined names present inside a workbook. Please use LoadDataFilterOptions_DefinedNames to filter defined names while loading the workbook. Please note that if you remove defined names, formulas inside the workbook may break.
Filter Defined Names while Loading a Workbook
The following sample code loads the sample Excel file, which has a formula in cell C1 containing the defined names, i.e., =SUM(MyName1, MyName2). Since we are using LoadDataFilterOptions_DefinedNames to remove the defined names while loading the workbook, the formula in cell C1 of the output Excel file breaks up, and you see #NAME? instead. Please see the following screenshot that shows the effect of the code on the sample Excel file.
