GetRangeByName always return null

Hi,

I wish to get the range by is name in the workbook.
But when I tried to retrieve it by using this function (GetRangeByName ) it always return null.
Please find attach the file.

Regards

Hi,

Please try the following code with the latest version:
Aspose.Cells for .NET 7.0.3
and it is working fine and returns the range.

I have tested it with your given file.

C#


string path = @“F:\Shak-Data-RW\Downloads\FormatTemplate.xls”;


Workbook workbook = new Workbook(path);


Worksheet worksheet = workbook.Worksheets[0];


Range rng = workbook.Worksheets.GetRangeByName(“BlueFont”);


Thank you very much, I saw my mistake then !!

Best regards