Unable to cast object of type ' ' to type ' and breaking in the system

Aspose.Cells Product Family
,
1

Description
foreach (var sheet in workbook.Worksheets)

** {**
** foreach (Cell cell in sheet.Cells)**

** {**

** try**

** {**

** if (cell.ContainsExternalLink)**
** {**

** }**

** }**

** catch (Exception e)**

** {**

** Console.WriteLine(e.Message);**

** }**

** }**

** }**

The highlighted method is giving the exception with the message Unable to cast object of type ’ ’ to type ’ and breaking in the system.

This issue started happening from v20.11 and working fine in v20.10.

2

@sindhu0234,
I have tried the scenario with own sample file but could not observe any issue using below code with the latest version Aspose.Cells for .NET 20.12. You may please share your template Excel file for our reference as we will reproduce the issue and share our feedback accordingly.

Workbook workbook = new Workbook("Book1.xlsx");
Worksheet sheet = workbook.Worksheets[0];
foreach (Cell cell in sheet.Cells) 
{
    try
    {
        if (cell.ContainsExternalLink) 
        {
            Console.WriteLine("Contains External Links");
        }
        else
        {
            Console.WriteLine("No External Links found");
        }
    }
    catch (Exception e)
    {
        Console.WriteLine(e.Message); 
    }
}