HotXLS Belgeleri İçindekiler Ana sayfa Genel bakış XLSX Facade Ana sayfa İçindekiler XLSX Facade Overview

TXLSXExternalLink / TXLSXExternalLinks classes

Workbook-level collection of external workbook references (OOXML externalLinks part). Each entry describes one linked .xlsx file by its target URL and an optional list of sheet names drawn from the cached metadata inside the link part. The collection lives on TXLSXWorkbook.ExternalLinks Declared in lxHandleX

TXLSXExternalLink declaration

type TXLSXExternalLink = class constructor Create(const ATarget: WideString); destructor Destroy; override; property Target: WideString; property SheetNames: TStringList; end;

TXLSXExternalLink üyeleri

Target URL of the referenced external workbook. For a workbook in the same directory use a relative path such as '../Reports/Sales.xlsx'; for a network location use a full UNC or file URI. SaveAs writes this verbatim as the relationship target and into xl/externalLinks/externalLinkN.xml.rels SheetNames Optional list of sheet names inside the external workbook. When populated, SaveAs emits <sheetNames> children inside the <externalBook> element so Excel can resolve cross-workbook references without opening the linked file. Populated automatically by Open when round-tripping an existing workbook. Leave empty when building a link from scratch; Excel will resolve the sheet names the next time the external file is opened

TXLSXExternalLinks declaration

type TXLSXExternalLinks = class constructor Create; destructor Destroy; override; function Add(const ATarget: WideString): TXLSXExternalLink; function IndexOfTarget(const ATarget: WideString): Integer; function FindByTarget(const ATarget: WideString): TXLSXExternalLink; function DeleteByTarget(const ATarget: WideString): Boolean; procedure Delete(Index: Integer); procedure Clear; property Count: Integer; property Items[Index: Integer]: TXLSXExternalLink; default; end;

TXLSXExternalLinks üyeleri

Add(Target) Appends a new external link with the given target URL and returns the new TXLSXExternalLink instance. Populate SheetNames on the returned object if known IndexOfTarget / FindByTarget Locate the first external workbook link whose Target matches the requested path or URL. Matching is case-insensitive DeleteByTarget / Delete / Clear Delete one link by target, delete one link by 0-based index, or clear the whole collection Count / Items[Index] Inspect external links by 0-based index. Items is the default property

SaveAs / Open behavior

When Workbook.ExternalLinks.Count > 0, SaveAs emits:

An <externalReferences> block in xl/workbook.xml with one <externalReference r:id="rIdN"/> per link
A relationship entry in xl/_rels/workbook.xml.rels pointing to externalLinks/externalLinkN.xml
xl/externalLinks/externalLinkN.xml containing the <externalBook> element with the target relation and optional <sheetNames>
xl/externalLinks/externalLinkN.xml.rels with the actual Target URL

Open round-trips Target and SheetNames; cached cell values inside <sheetDataSet> are not preserved by the current release

Örnek

var wb: TXLSXWorkbook; link: TXLSXExternalLink; begin wb := TXLSXWorkbook.Create; try link := wb.ExternalLinks.Add('../Data/Source.xlsx'); link.SheetNames.Add('Sheet1'); link.SheetNames.Add('Sheet2'); wb.Sheets.Add('Report'); wb.Sheets[0].Cells.Item[1, 1].Formula := '[Source.xlsx]Sheet1!$A$1'; wb.SaveAs('report.xlsx'); finally wb.Free; end; end;