Build 3.5.0.112 of xlsgen adds exposure to external links from any XLS or XLSX file (and their variants).

External references are created in about any formula, be it in cells, defined names, charts, conditional formattings, ...

The exposure of external references makes it possible to know the dependencies of a given spreadsheet.

Here is a sample code in C++ :

xlsgen::IXlsExternalReferencesPtr extRefs = workbook->ExternalReferences;

int nbExternalReferences = extRefs->Count;

for (int i = 1; i <= nbExternalReferences; i++)
{
    xlsgen::IXlsExternalReferencePtr ref = extRefs->Item[i];
    
    _bstr_t filepath = ref->ExcelFilepath;

    BOOL IsDDE = ref->DDE;
    BOOL IsOLE = ref->OLE;
}