Use ColumnNameFilter to select specific columns within the imported data. Only the specified columns will be imported to the worksheet.

 public System.String[] ColumnNameFilter{ get; set; }

Public Property ColumnNameFilter() As String()

If the length of the specified array is greater than MaxColumns, or exceeds the size of the target area and Truncate is set to true, the smaller value will be used.

Using ColumnNameFilter overwrites any previous ColumnIndexFilter setting.


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

          //--- Set ColumnNameFilter
          importProps.ColumnNameFilter = arrNames;
        

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

          '--- Set ColumnNameFilter
          importProps.ColumnNameFilter = arrNames