GetNamedRanges() error

Hello!


There is an exception when running the code below with the file attached:
string sourseFileName = rootFolder + “9.xlsx”;
using (FileStream fstream = new FileStream(sourseFileName, FileMode.Open))
{
var sourceWorkbook = new AC.Workbook(
fstream,
new AC.LoadOptions() {ParsingFormulaOnOpen = false });
var namedRanges = sourceWorkbook.Worksheets.GetNamedRanges();
}

Thanks,
Leo

Hi Leo,

Thanks for your posting and using Aspose.Cells.

Please download and use the latest version: Aspose.Cells
for .NET v8.0.0.2
it is working fine.

We have tested your issue with the following code and it did not throw any exception.

C#


string filePath = @“F:\Shak-Data-RW\Downloads\9.xlsx”;


var sourceWorkbook = new Workbook(filePath, new LoadOptions() {ParsingFormulaOnOpen = false });

var namedRanges = sourceWorkbook.Worksheets.GetNamedRanges();

Thank you Shakeel. Yes, looks like an issue in old Aspose version.

Hi Leo,

Thanks for your feedback and using Aspose.Cells.

It is good to know that your issue is resolved with the latest version. Let us know if you encounter any other issue, we will be glad to look into it and help you further.