Class: FixedWidthImportSettings

defines how to import data from a delimited source for tabular data.

Methods

Name Description
Clear()
RemoveAt(Int32) Removes the import definition at the specified index.
UseColumn(Int32, VariableType, VariableClassification, String, String) Add a column to be imported from the specified data source column index and configured as the specified variable type. The order in which columns are added determines their order in the data imported to . If is `null`, the default unit (in the active unit system) for the specified variable type will be assumed during import. If is `null` or empty, a unique name will be generated from the specified variableType during import. A reference to the instance is returned so that invocations can be chained together.

Properties

Name Description
ColumnWidths Gets or sets the specified column widths. When setting, The value provided to may be either: A `string` using Fortran-esque fixed-format specifications. This is similar to the “User-Defined” format specifier for External Data as described in the product documentation. Note, however, that regardless of the format specifier all imported columns WILL be interpreted using the .NET command `double.TryParse()` to support the requirements of the underlying variable data for Table. An containing the widths of each column. Negative values may be specified to define a negated width, meaning ‘-2’ would be equivalent to the fixed-width string specification ’2X’.
Count Gets the number of column definitions.
Format Gets the existing corresponding format.
Item
PathType Gets or sets the type of URI provided for Table import. Default:
SkipFooter Gets or sets the number of rows to ignore at the end of the file during import.
SkipRows Gets or sets the number of rows to skip over at the start of the file during import.