Insert Method

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

public XLColumn Insert(int index)

Public Function Insert(index As Integer) As XLColumn

Type	Name	Description
int	index	Position where the new item will be inserted.

Type	Description
XLColumn	A reference to the new item.

Inserts an XLColumn object at a specific position in the collection.

public XLColumn Insert(int index, XLColumn col)

Public Function Insert(index As Integer, col As XLColumn) As XLColumn

Type	Name	Description
int	index	Position where the item will be inserted.
XLColumn	col	Item that will be inserted.

Type	Description
XLColumn	A reference to the item that was added to the collection.

The maximum number of XLColumn objects in an XLSheet is 256. This is a limitation imposed by Excel 2003 and below.

For Excel 2007 and above, the maximum number of XLColumn objects in an XLSheet is 18,278.

Inserts an XLColumn object at a specific position in the collection.

public XLColumn Insert(int index, XLColumn col, XLCell[] cells)

Public Function Insert(index As Integer, col As XLColumn, cells As XLCell()) As XLColumn

Type	Name	Description
int	index	Position where the item will be inserted.
XLColumn	col	Item that will be inserted.
XLCell[]	cells	Array ot the cells for inserted column.

Type	Description
XLColumn	A reference to the item that was added to the collection.