Table of Contents

ExcelFile.SetLink Method

Changes the external link at position i for a new value. Note that you can't add new links with this method, external links are added automatically when you add formulas that reference other worksheets. This method is only to change existing links to point to other place. All formulas pointing to the old link will point to the new.

Note that the replacing filename should have the same sheets as the original, or the formulas might break.

Syntax

Namespace: FlexCel.Core

public abstract void SetLink(Int32 index, String value)

Parameters

<-> Parameter Type Description
index Int32 Index of the link (1 based). i goes between 1 and LinkCount
value String Please make sure this is a VALID filename, or you are likely to crash Excel. Also, xls file format doesn't like paths starting with "..", so you might need to enter the full path here.

See also