Wiki Markup |
---|
{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} |
Page History
Overview
Content Tools