Page History

{description}
{excerpt}Use [ColumnIndexFilter|DataImportProperties.ColumnIndexFilter] to select  specific columns within the imported data.  Only the specified columns will be imported to the worksheet.{excerpt}
{signature:C#}
 public int[] ColumnIndexFilter{ get; set; }
{signature}{signature:vb.net}
Public Property ColumnIndexFilter() As Integer()
{signature}
{remarks}If the length of the specified array is greater than  [MaxColumns|DataImportProperties.MaxColumns], or exceeds the size of the target area  and [Truncate|DataImportProperties.Truncate] is set to {{true}},  the smaller value will be used.

Using  {{ColumnIndexFilter}} overwrites  any previous [ColumnNameFilter|DataImportProperties.ColumnNameFilter] setting.

{remarks}
{example}{code:csharp|title=C#}

          //--- Get ColumnIndexFilter
          int[] arrFilter = importProps.ColumnIndexFilter;

          //--- Set ColumnIndexFilter
          importProps.ColumnIndexFilter = arrFilter;
        {code}
{code:vb.net|title=vb.net}

          '--- Get ColumnIndexFilter
          Dim arrFilter() As Integer = importProps.ColumnIndexFilter

          '--- Set ColumnIndexFilter
          importProps.ColumnIndexFilter = arrFilter
        {code}

{example}