检查工作簿是否包含隐藏的外部链接

可能的使用场景

有时，工作簿中包含隐藏外部链接，不能在Microsoft Excel中查看。Aspose.Cells for Python via .NET 可以检索所有外部链接，无论它们是隐藏还是可见。你还可以检查ExternalLink.is_visible属性，了解外部链接是否可见。

检查工作簿是否包含隐藏的外部链接

以下示例代码加载包含隐藏外部链接的源Excel文件。这些链接在Microsoft Excel中无法查看，但它们存在于工作簿内。在打印ExternalLink.data_source和ExternalLink.is_referred属性后，会打印ExternalLink.is_visible属性。在下方的控制台输出中，您会看到，它的所有外部链接都不可见。

示例代码

from aspose.cells import Workbook

#  For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
#  The path to the documents directory.
dataDir = RunExamples.GetDataDir(".")
#  Loads the workbook which contains hidden external links
workbook = Workbook(dataDir + "sample.xlsx")
#  Access the external link collection of the workbook
links = workbook.worksheets.external_links
#  Print all the external links and check there IsVisible property
for i in range(links.count):
    print("Data Source: "  + links[i].data_source)
    print("Is Referred: "  + str(links[i].is_referred))
    print("Is Visible: "  + str(links[i].is_visible))
    print()

控制台输出

这是执行给定源Excel文件时上述示例代码的控制台输出。

 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