
		Forums Knowledge Base OfficeWriter Online


	This documentation is for OfficeWriter v3.0.4 .NET Platform View Docs for Another Version or Platform

Programmer's Reference > ExcelApplication API > DataImportProperties > ColumnIndexFilter

ColumnIndexFilter Property

C# Signature:

VB.NET Signature:

Description:

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

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.

ColumnIndexFilter is a read / write property.

Examples:

[csharp]

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

// Set ColumnIndexFilter
importProps.ColumnIndexFilter = arrFilter;

[vbnet]

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

' Set ColumnIndexFilter
importProps.ColumnIndexFilter = arrFilter

Getter

Signature:

public            int[]
     ColumnIndexFilter

Returns:

int[] An array of columns indexes.

Setter

Signature:

public void ColumnIndexFilter                      int[]
     aFilter

Type:

int[]