Wiki Markup |
---|
{description} {excerpt}Use [ColumnIndexFilter|DataImportProperties.ColumnIndexFilter] to select specific columns within the imported data. Only the specified columns will be imported to the worksheet.{excerpt} {signature:C#} public int[] ColumnIndexFilter{ get; set; } {signature}{signature: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#} //--- Get ColumnIndexFilter int[] arrFilter = importProps.ColumnIndexFilter; //--- Set ColumnIndexFilter importProps.ColumnIndexFilter = arrFilter; {code} {code:vb.net|title=vb.net} '--- Get ColumnIndexFilter Dim arrFilter() As Integer = importProps.ColumnIndexFilter '--- Set ColumnIndexFilter importProps.ColumnIndexFilter = arrFilter {code} {example} |
Page History
Overview
Content Tools