OfficeWriter Documentation
.
ExcelWriter v8 Docs
Space Shortcuts
Page tree
ConfigureSpace tools

Versions Compared

Old Version 6

changes.mady.by.user Wiki Administrator

Saved on

compared with

New Version Current

changes.mady.by.user Wiki Administrator

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

Description

Excerpt

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

Signature
C#
C#
 public int[] ColumnIndexFilter{ get; set; }
{signature}{signature:
}
Signature
vb.net
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#}
Remarks

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 ColumnIndexFilter overwrites any previous ColumnNameFilter setting.

Example
Code Block
csharp
csharp
titleC#


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

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


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

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

{example}