InsertColumns Method

Inserts columns at the specified index.

Syntax

[VB.NET]
Public Sub InsertColumns(ByVal ColumnIndex As Integer, ByVal ColumnCount As Integer)

[C#]
public void InsertColumns(int columnIndex, int columnCount);

Remarks

This method inserts ColumnCount columns at the specified ColumnIndex. The ColumnIndex parameter is 0-based. Valid values for ColumnIndex are from 0 to ColumnCount. When inserting columns, the existing columns will be shifted to the right. Cell formatting will be preserved. For instance to insert 3 columns at column C:

Exceldoc1.InsertColumn(2,3);