Page History

{description}
{excerpt}Use [ColumnNameFilter|DataImportProperties.ColumnNameFilter] to select  specific columns within the imported data.  Only the  specified columns will be imported to the worksheet.{excerpt}
{signature:C#}
 public System.String[] ColumnNameFilter{ get; set; }
{signature}{signature:vb.net}
Public Property ColumnNameFilter() As String()
{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   {{ColumnNameFilter}} overwrites  any previous [ColumnIndexFilter|DataImportProperties.ColumnIndexFilter] setting.

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

          //--- Get ColumnNameFilter
          string[] arrNames = importProps.ColumnNameFilter;

          //--- Set ColumnNameFilter
          importProps.ColumnNameFilter = arrNames;
        {code}
{code:vb.net|title=vb.net}

          '--- Get ColumnNameFilter
          Dim arrNames() As String = importProps.ColumnNameFilter

          '--- Set ColumnNameFilter
          importProps.ColumnNameFilter = arrNames
        {code}

{example}