Wiki Markup |
---|
{description} {excerpt}The [DataImportProperties|DataImportProperties] contains a set of properties that can be used when importing data into a [Worksheet|Worksheet] or [Area|Area]. To return a {{DataImportProperties}} object, call [Workbook.CreateDataImportProperties|Workbook.CreateDataImportProperties()].{excerpt} {signature:C#} public sealed class DataImportProperties {signature}{signature:vb.net} Public NotInheritable Class DataImportProperties {signature} {example}{code:csharp|title=C#} ExcelApplication xla = new ExcelApplication(); Workbook wb = xla.Create(); DataImportProperties importProps = wb.CreateDataImportProperties(); {code} {code:vb.net|title=vb.net} Dim xla As New ExcelApplication() Dim wb As Workbook = xla.Create() Dim importProps As DataImportProperties = wb.CreateDataImportProperties() {code} {example} {fields} || Name || Description || | [ALLCOLUMNS|DataImportProperties.ALLCOLUMNS] | {excerpt-include:DataImportProperties.ALLCOLUMNS|nopanel=true} | | [ALLROWS|DataImportProperties.ALLROWS]\\ | {excerpt-include:DataImportProperties.ALLROWS|nopanel=true} | {properties} || Name || Description || | [ColumnIndexFilter|DataImportProperties.ColumnIndexFilter]\\ | {excerpt-include:DataImportProperties.ColumnIndexFilter|nopanel=true} | | [ColumnNameFilter|DataImportProperties.ColumnNameFilter]\\ | {excerpt-include:DataImportProperties.ColumnNameFilter|nopanel=true} | | [IgnoreNulls|DataImportProperties.IgnoreNulls]\\ | {excerpt-include:DataImportProperties.IgnoreNulls|nopanel=true} | | [MaxColumns|DataImportProperties.MaxColumns]\\ | {excerpt-include:DataImportProperties.MaxColumns|nopanel=true} | | [MaxRows|DataImportProperties.MaxRows]\\ | {excerpt-include:DataImportProperties.MaxRows|nopanel=true} | | [Transpose|DataImportProperties.Transpose]\\ | {excerpt-include:DataImportProperties.Transpose|nopanel=true} | | [Truncate|DataImportProperties.Truncate]\\ | {excerpt-include:DataImportProperties.Truncate|nopanel=true} | | [TruncateColumns|DataImportProperties.TruncateColumns]\\ | {excerpt-include:DataImportProperties.TruncateColumns|nopanel=true} | | [TruncateRows|DataImportProperties.TruncateRows]\\ | {excerpt-include:DataImportProperties.TruncateRows|nopanel=true} | | [UseColumnNames|DataImportProperties.UseColumnNames]\\ | {excerpt-include:DataImportProperties.UseColumnNames|nopanel=true} | | [ConvertStrings|DataImportProperties.ConvertStrings]\\ | {excerpt-include:DataImportProperties.ConvertStrings|nopanel=true} | | [ConversionCulture|DataImportProperties.ConversionCulture]\\ | {excerpt-include:DataImportProperties.ConversionCulture|nopanel=true} | |
Page History
Overview
Content Tools