Check if Workbook contains hidden External Links

Possible Usage Scenarios

Sometimes, the workbook contains external links which are hidden and cannot be viewed in Microsoft Excel. Aspose.Cells for Python via .NET retrieves all the external links whether they are visible or hidden. However, you can check the ExternalLink.is_visible property to check if the external link is visible or not.

The following sample code loads the source excel file which contains hidden external links. These links cannot be viewed in Microsoft Excel but they are present inside the workbook. After printing ExternalLink.data_source and ExternalLink.is_referred property, it prints the ExternalLink.is_visible property. In the console output below, you see, all of its external links are not visible.

Sample Code

Console Output

Here is the console output of the above sample code when executed with the given sample excel file.

 Data Source: C:\International\DDB\FAS 133\Swap Rates\GS_1M_3M_1_2_5_¥$_(B)IRSwaps_0400.xls

Is Referred: True

Is Visible: False

Data Source: C:\DIST DAY\MAY TEMPLATES\030601t.xls

Is Referred: True

Is Visible: False

Data Source: C:\AREVIEW\2002 Controllable\Autobrct.xls

Is Referred: True

Is Visible: False

Data Source: C:\CARDSFO\Main Files\Rate Forecast\FY 11\IFR 11 01 (New Model REPORTS 11.08.07).xls

Is Referred: True

Is Visible: False
Update Power Query Formula Item Change the Absolute Path of External Link Data Source File