[]
        
(Showing Draft Content)

C1.Excel.XLExternalBookCollection

XLExternalBookCollection Class

Collection of XLExternalBook objects that represent the individual worksheets in a C1XLBook.

Inheritance
XLExternalBookCollection
Implements
Namespace: C1.Excel
Assembly: C1.Excel.dll
Syntax
public class XLExternalBookCollection : IEnumerable

Properties

Name Description
Book

Gets a reference to the C1XLBook that owns the collection.

Count

Gets the number of XLExternalBook objects in the collection.

this[int]

Gets the XLSheet at a given position in the collection.

this[string]

Gets the XLSheet with the given name (case-insensitive).

Methods

Name Description
Add(XLExternalBook)

Appends an existing XLExternalBook to the collection.

Add(string)

Creates a new XLExternalBook with a given name and appends it to the collection.

Clear()

Removes all items from the collection.

Contains(XLExternalBook)

Determines whether the collection contains a specific XLSheet object.

Contains(string)

Determines whether the collection contains an XLExternalBook object with a given name.

IndexOf(XLExternalBook)

Gets the index of a given XLExternalBook in the collection.

IndexOf(string)

Gets the position of the sheet with the specified name in the collection.

Insert(int, XLExternalBook)

Inserts an XLSheet object into the collection at the specified position.

Insert(int, string)

Creates a new XLExternalBook and inserts it at a specific position in the collection.

Remove(XLExternalBook)

Removes an XLExternalBook from the collection.

Remove(string)

Removes the XLExternalBook with the specified name from the collection.

RemoveAt(int)

Removes the XLSheet at a specific index from the collection.