Spread Windows Forms 17
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet Namespace / Worksheet Class / GetTextToColumnsCount Method
The top-left row of source range.
The top-left column of source range.
The row count of source range.
The column count of source range.
The format of the text to be split into columns.
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.
True to have Excel consider consecutive delimiters as one delimiter. The default value is False.
true to have dataType be TextParsingType.Delimited and to have the tab character be a delimiter. The default value is true.
true to have dataType be TextParsingType.Delimited and to have the semicolon character be a delimiter. The default value is true.
true to have dataType be TextParsingType.Delimited and to have the comma character be a delimiter. The default value is true.
true to have dataType be TextParsingType.Delimited and to have the space character be a delimiter. The default value is true.
true to have dataType be TextParsingType.Delimited and to have the otherChar character be a delimiter. The default value is true.
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.
Specifies whether to use single, double, or no quotes as the text qualifier.


In This Topic
    GetTextToColumnsCount Method
    In This Topic
    Determines the how many columns can be extracted from source range data.
    Syntax
    '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)

    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.
    See Also