OfficeWriter Documentation
.
ExcelWriter v8 Docs
Space Shortcuts
Page tree
ConfigureSpace tools

Versions Compared

Old Version 3

changes.mady.by.user Unknown User (ozgurt)

Saved on

compared with

New Version 4

changes.mady.by.user Unknown User (ozgurt)

Saved on

Key

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

Excerpt

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.

...

ALLCOLUMNS

...

ALLROWS

...

Properties

...

Name

...

Description

...

ColumnIndexFilter

...

ColumnNameFilter

...

IgnoreNulls

...

MaxColumns

...

MaxRows

...

Transpose

...

Truncate

...

TruncateColumns

...

TruncateRows

...

UseColumnNames

...

ConvertStrings

...

ConversionCulture

...

{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()
Signature
C#C#
Wiki Markup
{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}{signature:vb.net
vb.net
}
Public NotInheritable Class DataImportProperties
Example
Code Block
csharpcsharp
titleC#
Code Block
vb.nettitle
Fields

...

Name

...

Description 

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