OfficeWriter Documentation
.
WordWriter v12 Docs
Space Shortcuts
Page tree
    Loading...
Skip to end of metadata
Go to start of metadata

Description

This class is used to control settings for importing data into a table or table cell.

C#
?
public sealed class DataImportProperties
vb.net
?
Public NotInheritable Class DataImportProperties

Remarks

To create a DataImportProperties object, use Document.CreateDataImportProperties.

To actually import data, use Element.ImportData and pass in a DataImportProperties object along with the data to import.

Examples

C#
?
WordApplication app = new WordApplication();
Document doc = app.Create();
DataImportProperties importProps = doc.CreateDataImportProperties();
 
//--- Set a few properties
importProps.UseColumnNames = true;
importProps.AutoFit = true;
 
//--- Import data into a new table and apply the DataImportProperties
Table dataImportTable = oTable.ImportData(oDataTable, importProps);
vb.net
?
Dim app As New WordApplication()
Dim doc As Document = app.Create()
Dim importProps As DataImportProperties = doc.CreateDataImportProperties()
 
'--- Set a few properties
importProps.UseColumnNames = True
importProps.AutoFit = True
 
'--- Import data into a new table and apply the DataImportProperties
Table dataImportTable = oTable.ImportData(oDataTable, importProps)

Properties

Name

Description

AutoFit

 Sets or returns a boolean representing whether or not the table that is automatically created for the imported data will automatically be sized to fit the data being imported.

AutoFormatter

 Sets or returns an AutoFormatter that specifies how the imported data should be formatted in the table.

ColumnIndexFilter

 Sets or returns an array of column indexes specifying the columns to import.

ColumnNameFilter

 Sets or returns an array of columns names specifying the columns to import. If the length of the specified array is greater than MaxColumns, or exceeds the size of the target area, the columns will be added in the order in which they appear in the array.

MaxColumns

 Sets or returns an int that represents the maximum number of columns to be imported. If more columns than this are in the data source, the extra ones will be ignored.

MaxRows

 Returns or set an int that represents the maximum number of rows to be imported. If more rows than this are in the data source, the extra ones will be ignored.

UseColumnNames

 Sets or returns a boolean that represents whether to use the column names from the data source when importing the data. This property is set to true by default.
  • No labels