ExternalWorkbookCollection.Replace(Int32, ExternalWorkbook, String) Method

Replaces an element with the specified index with a specified element.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v23.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

void Replace(
    int itemIndex,
    ExternalWorkbook newItem,
    string alias
)

VB.NET

Sub Replace(
    itemIndex As Integer,
    newItem As ExternalWorkbook,
    alias As String
)

Parameters

Name	Type	Description
itemIndex	Int32	An integer that is the index in the collection.
newItem	ExternalWorkbook	An ExternalWorkbook object that is the new element to insert into the collection.
alias	String	A String value specifying the custom workbook name that can be used in external references.

Remarks

Use the Replace method to replace cached references in a workbook with the updateable references.

The alias parameter of the current Replace method allows you to specify a custom workbook name that you can use in external references instead of the original file name or when the external workbook is not saved to a file.