The DataImportProperties contains a set of properties that can be used when importing data into a Worksheet or Area. To return a DataImportProperties object, call Workbook.CreateDataImportProperties.

 public sealed class DataImportProperties
Public NotInheritable Class DataImportProperties

          ExcelApplication xla = new ExcelApplication();
          Workbook wb = xla.Create();
          DataImportProperties importProps = wb.CreateDataImportProperties();
        

          Dim xla As New ExcelApplication()
          Dim wb As Workbook = xla.Create()
          Dim importProps As DataImportProperties = wb.CreateDataImportProperties()
        

Name

Description

ALLCOLUMNS

ALLROWS

Name

Description

ColumnIndexFilter

ColumnNameFilter

IgnoreNulls

MaxColumns

MaxRows

Transpose

Truncate

TruncateColumns

TruncateRows

UseColumnNames

ConvertStrings

ConversionCulture