
		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 > ColumnNameFilter

ColumnNameFilter Property

C# Signature:

VB.NET Signature:

Description:

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

ColumnNameFilter is a read / write property.

Examples:

[csharp]

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

// Set ColumnNameFilter
importProps.ColumnNameFilter = arrNames;

[vbnet]

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

' Set ColumnNameFilter
importProps.ColumnNameFilter = arrNames

Getter

Signature:

public            String[]
     ColumnNameFilter

Returns:

String[] An array of columns names.

Setter

Signature:

public void ColumnNameFilter                      String[]
     aFilter

Type:

String[]