'Declaration
 
Public Function GetTextToColumnsCount( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal rowCount As Integer, _
   ByVal columnCount As Integer, _
   ByVal dataType As TextParsingType, _
   ByVal fieldInfo() As Tuple(Of Integer,ColumnDataType), _
   ByVal consecutiveDelimiter As Boolean, _
   ByVal tab As Boolean, _
   ByVal semicolon As Boolean, _
   ByVal comma As Boolean, _
   ByVal space As Boolean, _
   ByVal other As Boolean, _
   ByVal otherChar As Char, _
   Optional ByVal textQualifier 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 row,
   int column,
   int rowCount,
   int columnCount,
   TextParsingType dataType,
   Tuple<int,ColumnDataType>[] fieldInfo,
   bool consecutiveDelimiter,
   bool tab,
   bool semicolon,
   bool comma,
   bool space,
   bool other,
   char otherChar,
   TextQualifier 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 dataType. 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 dataType be TextParsingType.Delimited and to have the tab character be a delimiter. The default value is true.

semicolon

true to have dataType be TextParsingType.Delimited and to have the semicolon character be a delimiter. The default value is true.

comma

true to have dataType be TextParsingType.Delimited and to have the comma character be a delimiter. The default value is true.

space

true to have dataType be TextParsingType.Delimited and to have the space character be a delimiter. The default value is true.

other

true to have dataType be TextParsingType.Delimited and to have the otherChar character be a delimiter. The default value is true.

otherChar

Required if other is True; the delimiter character when other 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.

Reference

Worksheet Class
Worksheet Members