
		Forums Knowledge Base OfficeWriter Online


	This documentation is for OfficeWriter v3.0.4 .NET Platform View Docs for Another Version or Platform

Programmer's Reference > ExcelApplication API > DataImportProperties

The DataImportProperties Object

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.

Examples:

[csharp]

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

[vbnet]

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

DataImportProperties Constants

Name	Description
ALLCOLUMNS	255
ALLROWS	65536

DataImportProperties Properties

Property	Type	Access	Description
ColumnIndexFilter	int[]	read write	Use `ColumnIndexFilter` to select specific columns within the imported data
ColumnNameFilter	String[]	read write	Use `ColumnNameFilter` to select specific columns within the imported data
MaxColumns	int	read write	Sets or returns the maximum number of columns to import from the data source
MaxRows	int	read write	Sets or returns the maximum number of rows to import from the data source
Transpose	boolean	read write	When data is imported from a two-dimensional or rectangular array, the first dimension of the array corresponds to column and the second to row
Truncate	boolean	write	Sets whether ExcelWriter should truncate imported data rows and columns that do not fit within the target rows and columns in the spreadsheet
TruncateColumns	boolean	read write	Sets or returns whether imported data columns will be truncated if the number of columns imported exceeds the number of target columns in the spreadsheet
TruncateRows	boolean	read write	Sets or returns whether imported data rows will be truncated if the number of rows imported exceeds the number of target rows in the spreadsheet
UseColumnNames	boolean	read write	Sets or returns whether to import column names to the first row (or first column if `Transpose` is set to `true` ) of the imported data's target cells

This object does not have any methods defined.