Page History

{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} |