Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0
Description

Excerpt

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

|Document.CreateDataImportProperties()].

To actually import data, use [Element.ImportData|Element.ImportData(Object()())] and pass in a {{DataImportProperties}} object along with the data to import.

{remarks}
{example}{code:csharp|title=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);
        
{code}
{code:vbnet|title=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)
        
Signature
C#C#
Wiki Markup
{description}
{excerpt}This class is used to control settings for importing data into a table or table cell.{excerpt}
{signature:C#}
 public sealed class DataImportProperties
Signature
{signature}{signature:vb.net
vb.net
}
Public NotInheritable Class DataImportProperties
Remarks
To create a DataImportProperties object, use
{signature}
{remarks}To create a [DataImportProperties|DataImportProperties] object, use [Document.CreateDataImportProperties
.

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

Example
Code Block
csharpcsharp
titleC#
Code Block
vbnetvbnettitle
Properties

...

Name

...

Description

...

AutoFit

...

{code}

{example}
{properties}
||Name||Description||
|[AutoFit|DataImportProperties.AutoFit]|{excerpt-include:DataImportProperties.AutoFit

...

AutoFormatter

|nopanel=true}|
|[AutoFormatter|DataImportProperties.AutoFormatter]|{excerpt-include

...

:DataImportProperties.AutoFormatter

...

ColumnIndexFilter

|nopanel=true}|
|[ColumnIndexFilter|DataImportProperties.ColumnIndexFilter]|{excerpt-include

...

:DataImportProperties.ColumnIndexFilter

...

ColumnNameFilter

|nopanel=true}|
|[ColumnNameFilter|DataImportProperties.ColumnNameFilter]|{excerpt-include

...

:DataImportProperties.ColumnNameFilter

...

MaxColumns

|nopanel=true}|
|[MaxColumns|DataImportProperties.MaxColumns]|{excerpt-include

...

:DataImportProperties.MaxColumns

...

MaxRows

|nopanel=true}|
|[MaxRows|DataImportProperties.MaxRows]|{excerpt-include

...

:DataImportProperties.MaxRows

...

UseColumnNames

|nopanel=true}|
|[UseColumnNames|DataImportProperties.UseColumnNames]|{excerpt-include

...

:DataImportProperties.UseColumnNames

...

|nopanel=true}|