GetTextToColumnsCount Method
In This Topic
Determines the how many columns can be extracted from source range data.
Syntax
'Declaration
Public Function GetTextToColumnsCount( _
ByVal As Integer, _
ByVal column As Integer, _
ByVal As Integer, _
ByVal columnCount As Integer, _
ByVal As TextParsingType, _
ByVal () As Tuple(Of Integer,ColumnDataType), _
ByVal As Boolean, _
ByVal As Boolean, _
ByVal As Boolean, _
ByVal As Boolean, _
ByVal As Boolean, _
ByVal As Boolean, _
ByVal As Char, _
Optional ByVal As TextQualifier _
) As Integer
'Usage
Dim instance As Worksheet
Dim row As Integer
Dim column As Integer
Dim rowCount As Integer
Dim columnCount As Integer
Dim dataType As TextParsingType
Dim fieldInfo() As Tuple(Of Integer,ColumnDataType)
Dim consecutiveDelimiter As Boolean
Dim tab As Boolean
Dim semicolon As Boolean
Dim comma As Boolean
Dim space As Boolean
Dim other As Boolean
Dim otherChar As Char
Dim textQualifier As TextQualifier
Dim value As Integer
value = instance.GetTextToColumnsCount(row, column, rowCount, columnCount, dataType, fieldInfo, consecutiveDelimiter, tab, semicolon, comma, space, other, otherChar, textQualifier)
public int GetTextToColumnsCount(
int ,
int column,
int ,
int columnCount,
TextParsingType ,
Tuple<int,ColumnDataType>[] ,
bool ,
bool ,
bool ,
bool ,
bool ,
bool ,
char ,
TextQualifier
)
Parameters
- row
- The top-left row of source range.
- column
- The top-left column of source range.
- rowCount
- The row count of source range.
- columnCount
- The column count of source range.
- dataType
- The format of the text to be split into columns.
- fieldInfo
- An array containing parse information for the individual columns of data. The interpretation depends on the value of . When the data is delimited, this argument is an array of two-element arrays, with each two-element array specifying the conversion options for a particular column. The first element is the column number, and the second element is one of the ColumnDataType constants specifying how the column is parsed.
- consecutiveDelimiter
- True to have Excel consider consecutive delimiters as one delimiter. The default value is False.
- tab
- true to have be TextParsingType.Delimited and to have the tab character be a delimiter. The default value is true.
- semicolon
- true to have be TextParsingType.Delimited and to have the semicolon character be a delimiter. The default value is true.
- comma
- true to have be TextParsingType.Delimited and to have the comma character be a delimiter. The default value is true.
- space
- true to have be TextParsingType.Delimited and to have the space character be a delimiter. The default value is true.
- other
- true to have be TextParsingType.Delimited and to have the character be a delimiter. The default value is true.
- otherChar
- Required if is True; the delimiter character when is True. If more than one character is specified, only the first character of the string is used; the remaining characters are ignored.
- textQualifier
- Specifies whether to use single, double, or no quotes as the text qualifier.
See Also