# GrapeCity.Spreadsheet.IRange.TextToColumns

## Content

<div class="doc-site-dotnet-api-container">



<h1 id="GrapeCity_Spreadsheet_IRange_TextToColumns_" data-uid="GrapeCity.Spreadsheet.IRange.TextToColumns*">TextToColumns Method
</h1>
<div class="markdown level0 summary"></div>
<div class="markdown level0 conceptual"></div>



<a id="GrapeCity_Spreadsheet_IRange_TextToColumns_" data-uid="GrapeCity.Spreadsheet.IRange.TextToColumns*"></a>
<h4 id="GrapeCity_Spreadsheet_IRange_TextToColumns_System_Int32_System_Int32_GrapeCity_Spreadsheet_TextParsingType_GrapeCity_Spreadsheet_TextQualifier_System_Boolean_System_Boolean_System_Boolean_System_Boolean_System_Boolean_System_Boolean_System_Char_System_Tuple_System_Int32_GrapeCity_Spreadsheet_ColumnDataType____System_Char_System_Char_System_Boolean_" data-uid="GrapeCity.Spreadsheet.IRange.TextToColumns(System.Int32,System.Int32,GrapeCity.Spreadsheet.TextParsingType,GrapeCity.Spreadsheet.TextQualifier,System.Boolean,System.Boolean,System.Boolean,System.Boolean,System.Boolean,System.Boolean,System.Char,System.Tuple{System.Int32,GrapeCity.Spreadsheet.ColumnDataType}[],System.Char,System.Char,System.Boolean)">TextToColumns(int, int, TextParsingType, TextQualifier, bool, bool, bool, bool, bool, bool, char, Tuple&lt;int, ColumnDataType&gt;[], char, char, bool)</h4>
<div class="markdown level1 summary"><p>Parses a column of cells that contain text into several columns.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">ActionResult&lt;object&gt; TextToColumns(int row = -1, int column = -1, TextParsingType dataType = TextParsingType.Delimited, TextQualifier textQualifier = TextQualifier.None, bool consecutiveDelimiter = false, bool tab = false, bool semicolon = false, bool comma = false, bool space = false, bool other = false, char otherChar = &#39;\0&#39;, Tuple&lt;int, ColumnDataType&gt;[] fieldInfo = null, char decimalSeparator = &#39;\0&#39;, char thousandsSeparator = &#39;\0&#39;, bool trailingMinusNumbers = false)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Function TextToColumns(Optional row As Integer = -1, Optional column As Integer = -1, Optional dataType As TextParsingType = TextParsingType.Delimited, Optional textQualifier As TextQualifier = TextQualifier.None, Optional consecutiveDelimiter As Boolean = False, Optional tab As Boolean = False, Optional semicolon As Boolean = False, Optional comma As Boolean = False, Optional space As Boolean = False, Optional other As Boolean = False, Optional otherChar As Char = vbNullChar, Optional fieldInfo As Tuple(Of Integer, ColumnDataType)() = Nothing, Optional decimalSeparator As Char = vbNullChar, Optional thousandsSeparator As Char = vbNullChar, Optional trailingMinusNumbers As Boolean = False) As ActionResult(Of Object)</code></pre>
</div>
<h5 class="parameters">Parameters</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Name</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">row</span></td>
      <td><p>An integer value that specifies the row where Spread will place the results.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">column</span></td>
      <td><p>An integer value that specifies the column where Spread will place the results.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="GrapeCity.Spreadsheet.TextParsingType.html">TextParsingType</a></td>
      <td><span class="parametername">dataType</span></td>
      <td><p>The format of the text to be split into columns.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="GrapeCity.Spreadsheet.TextQualifier.html">TextQualifier</a></td>
      <td><span class="parametername">textQualifier</span></td>
      <td><p>Specifies whether to use single, double, or no quotes as the text qualifier.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">consecutiveDelimiter</span></td>
      <td><p>True to have Spread consider consecutive delimiters as one delimiter. The default value is False.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">tab</span></td>
      <td><p><code>true</code> to have <code class="paramref">dataType</code> be <a class="xref" href="GrapeCity.Spreadsheet.TextParsingType.html#GrapeCity_Spreadsheet_TextParsingType_Delimited">Delimited</a> and to have the tab character be a delimiter.
The default value is <code>true</code>.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">semicolon</span></td>
      <td><p><code>true</code> to have <code class="paramref">dataType</code> be <a class="xref" href="GrapeCity.Spreadsheet.TextParsingType.html#GrapeCity_Spreadsheet_TextParsingType_Delimited">Delimited</a> and to have the semicolon character be a delimiter.
The default value is <code>true</code>.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">comma</span></td>
      <td><p><code>true</code> to have <code class="paramref">dataType</code> be <a class="xref" href="GrapeCity.Spreadsheet.TextParsingType.html#GrapeCity_Spreadsheet_TextParsingType_Delimited">Delimited</a> and to have the comma character be a delimiter.
The default value is <code>true</code>.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">space</span></td>
      <td><p><code>true</code> to have <code class="paramref">dataType</code> be <a class="xref" href="GrapeCity.Spreadsheet.TextParsingType.html#GrapeCity_Spreadsheet_TextParsingType_Delimited">Delimited</a> and to have the space character be a delimiter.
The default value is <code>true</code>.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">other</span></td>
      <td><p><code>true</code> to have <code class="paramref">dataType</code> be <a class="xref" href="GrapeCity.Spreadsheet.TextParsingType.html#GrapeCity_Spreadsheet_TextParsingType_Delimited">Delimited</a> and to have the <code class="paramref">otherChar</code> character be a delimiter.
The default value is <code>true</code>.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.char">char</a></td>
      <td><span class="parametername">otherChar</span></td>
      <td><p>Required if <code class="paramref">other</code> is <code>true</code>; the delimiter character when <code class="paramref">other</code> is <code>true</code>.
If more than one character is specified, only the first character of the string is used; the remaining characters are ignored.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.tuple-2">Tuple</a>&lt;<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a>, <a class="xref" href="GrapeCity.Spreadsheet.ColumnDataType.html">ColumnDataType</a>&gt;[]</td>
      <td><span class="parametername">fieldInfo</span></td>
      <td><p>An array containing parse information for the individual columns of data. The interpretation depends on the value of <code class="paramref">dataType</code>.
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 <a class="xref" href="GrapeCity.Spreadsheet.ColumnDataType.html">ColumnDataType</a> constants specifying how the column is parsed.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.char">char</a></td>
      <td><span class="parametername">decimalSeparator</span></td>
      <td><p>The decimal separator that Spread uses when recognizing numbers. The default setting is the system setting.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.char">char</a></td>
      <td><span class="parametername">thousandsSeparator</span></td>
      <td><p>The thousands separator that Spread uses when recognizing numbers. The default setting is the system setting.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">trailingMinusNumbers</span></td>
      <td><p>Numbers that begin with a minus character.</p>
</td>
    </tr>
  </tbody>
</table>
<h5 class="returns">Returns</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="GrapeCity.Spreadsheet.ActionResult-1.html">ActionResult</a>&lt;<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.object">object</a>&gt;</td>
      <td><p><code>true</code> if the columns are inserted successful, <code>false</code> otherwise.</p>
</td>
    </tr>
  </tbody>
</table>


<a id="GrapeCity_Spreadsheet_IRange_TextToColumns_" data-uid="GrapeCity.Spreadsheet.IRange.TextToColumns*"></a>
<h4 id="GrapeCity_Spreadsheet_IRange_TextToColumns_GrapeCity_Spreadsheet_IRange_GrapeCity_Spreadsheet_TextParsingType_GrapeCity_Spreadsheet_TextQualifier_System_Boolean_System_Boolean_System_Boolean_System_Boolean_System_Boolean_System_Boolean_System_Char_System_Tuple_System_Int32_GrapeCity_Spreadsheet_ColumnDataType____System_Char_System_Char_System_Boolean_" data-uid="GrapeCity.Spreadsheet.IRange.TextToColumns(GrapeCity.Spreadsheet.IRange,GrapeCity.Spreadsheet.TextParsingType,GrapeCity.Spreadsheet.TextQualifier,System.Boolean,System.Boolean,System.Boolean,System.Boolean,System.Boolean,System.Boolean,System.Char,System.Tuple{System.Int32,GrapeCity.Spreadsheet.ColumnDataType}[],System.Char,System.Char,System.Boolean)">TextToColumns(IRange, TextParsingType, TextQualifier, bool, bool, bool, bool, bool, bool, char, Tuple&lt;int, ColumnDataType&gt;[], char, char, bool)</h4>
<div class="markdown level1 summary"><p>Parses a column of cells that contain text into several columns.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">ActionResult&lt;object&gt; TextToColumns(IRange destination, TextParsingType dataType = TextParsingType.Delimited, TextQualifier textQualifier = TextQualifier.None, bool consecutiveDelimiter = false, bool tab = false, bool semicolon = false, bool comma = false, bool space = false, bool other = false, char otherChar = &#39;\0&#39;, Tuple&lt;int, ColumnDataType&gt;[] fieldInfo = null, char decimalSeparator = &#39;\0&#39;, char thousandsSeparator = &#39;\0&#39;, bool trailingMinusNumbers = false)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Function TextToColumns(destination As IRange, Optional dataType As TextParsingType = TextParsingType.Delimited, Optional textQualifier As TextQualifier = TextQualifier.None, Optional consecutiveDelimiter As Boolean = False, Optional tab As Boolean = False, Optional semicolon As Boolean = False, Optional comma As Boolean = False, Optional space As Boolean = False, Optional other As Boolean = False, Optional otherChar As Char = vbNullChar, Optional fieldInfo As Tuple(Of Integer, ColumnDataType)() = Nothing, Optional decimalSeparator As Char = vbNullChar, Optional thousandsSeparator As Char = vbNullChar, Optional trailingMinusNumbers As Boolean = False) As ActionResult(Of Object)</code></pre>
</div>
<h5 class="parameters">Parameters</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Name</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="GrapeCity.Spreadsheet.IRange.html">IRange</a></td>
      <td><span class="parametername">destination</span></td>
      <td><p>An <a class="xref" href="GrapeCity.Spreadsheet.IRange.html">IRange</a> object that specifies where Spread will place the results. If the range is larger than a single cell, the top left cell is used.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="GrapeCity.Spreadsheet.TextParsingType.html">TextParsingType</a></td>
      <td><span class="parametername">dataType</span></td>
      <td><p>The format of the text to be split into columns.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="GrapeCity.Spreadsheet.TextQualifier.html">TextQualifier</a></td>
      <td><span class="parametername">textQualifier</span></td>
      <td><p>Specifies whether to use single, double, or no quotes as the text qualifier.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">consecutiveDelimiter</span></td>
      <td><p>True to have Spread consider consecutive delimiters as one delimiter. The default value is False.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">tab</span></td>
      <td><p><code>true</code> to have <code class="paramref">dataType</code> be <a class="xref" href="GrapeCity.Spreadsheet.TextParsingType.html#GrapeCity_Spreadsheet_TextParsingType_Delimited">Delimited</a> and to have the tab character be a delimiter.
The default value is <code>true</code>.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">semicolon</span></td>
      <td><p><code>true</code> to have <code class="paramref">dataType</code> be <a class="xref" href="GrapeCity.Spreadsheet.TextParsingType.html#GrapeCity_Spreadsheet_TextParsingType_Delimited">Delimited</a> and to have the semicolon character be a delimiter.
The default value is <code>true</code>.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">comma</span></td>
      <td><p><code>true</code> to have <code class="paramref">dataType</code> be <a class="xref" href="GrapeCity.Spreadsheet.TextParsingType.html#GrapeCity_Spreadsheet_TextParsingType_Delimited">Delimited</a> and to have the comma character be a delimiter.
The default value is <code>true</code>.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">space</span></td>
      <td><p><code>true</code> to have <code class="paramref">dataType</code> be <a class="xref" href="GrapeCity.Spreadsheet.TextParsingType.html#GrapeCity_Spreadsheet_TextParsingType_Delimited">Delimited</a> and to have the space character be a delimiter.
The default value is <code>true</code>.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">other</span></td>
      <td><p><code>true</code> to have <code class="paramref">dataType</code> be <a class="xref" href="GrapeCity.Spreadsheet.TextParsingType.html#GrapeCity_Spreadsheet_TextParsingType_Delimited">Delimited</a> and to have the <code class="paramref">otherChar</code> character be a delimiter.
The default value is <code>true</code>.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.char">char</a></td>
      <td><span class="parametername">otherChar</span></td>
      <td><p>Required if <code class="paramref">other</code> is <code>true</code>; the delimiter character when <code class="paramref">other</code> is <code>true</code>.
If more than one character is specified, only the first character of the string is used; the remaining characters are ignored.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.tuple-2">Tuple</a>&lt;<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a>, <a class="xref" href="GrapeCity.Spreadsheet.ColumnDataType.html">ColumnDataType</a>&gt;[]</td>
      <td><span class="parametername">fieldInfo</span></td>
      <td><p>An array containing parse information for the individual columns of data. The interpretation depends on the value of <code class="paramref">dataType</code>.
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 <a class="xref" href="GrapeCity.Spreadsheet.ColumnDataType.html">ColumnDataType</a> constants specifying how the column is parsed.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.char">char</a></td>
      <td><span class="parametername">decimalSeparator</span></td>
      <td><p>The decimal separator that Spread uses when recognizing numbers. The default setting is the system setting.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.char">char</a></td>
      <td><span class="parametername">thousandsSeparator</span></td>
      <td><p>The thousands separator that Spread uses when recognizing numbers. The default setting is the system setting.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">trailingMinusNumbers</span></td>
      <td><p>Numbers that begin with a minus character.</p>
</td>
    </tr>
  </tbody>
</table>
<h5 class="returns">Returns</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="GrapeCity.Spreadsheet.ActionResult-1.html">ActionResult</a>&lt;<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.object">object</a>&gt;</td>
      <td><p><code>true</code> if the columns are inserted successful, <code>false</code> otherwise.</p>
</td>
    </tr>
  </tbody>
</table>


<a id="GrapeCity_Spreadsheet_IRange_TextToColumns_" data-uid="GrapeCity.Spreadsheet.IRange.TextToColumns*"></a>
<h4 id="GrapeCity_Spreadsheet_IRange_TextToColumns_System_String_GrapeCity_Spreadsheet_TextParsingType_GrapeCity_Spreadsheet_TextQualifier_System_Boolean_System_Boolean_System_Boolean_System_Boolean_System_Boolean_System_Boolean_System_Char_System_Tuple_System_Int32_GrapeCity_Spreadsheet_ColumnDataType____System_Char_System_Char_System_Boolean_" data-uid="GrapeCity.Spreadsheet.IRange.TextToColumns(System.String,GrapeCity.Spreadsheet.TextParsingType,GrapeCity.Spreadsheet.TextQualifier,System.Boolean,System.Boolean,System.Boolean,System.Boolean,System.Boolean,System.Boolean,System.Char,System.Tuple{System.Int32,GrapeCity.Spreadsheet.ColumnDataType}[],System.Char,System.Char,System.Boolean)">TextToColumns(string, TextParsingType, TextQualifier, bool, bool, bool, bool, bool, bool, char, Tuple&lt;int, ColumnDataType&gt;[], char, char, bool)</h4>
<div class="markdown level1 summary"><p>Parses a column of cells that contain text into several columns.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">ActionResult&lt;object&gt; TextToColumns(string destination, TextParsingType dataType = TextParsingType.Delimited, TextQualifier textQualifier = TextQualifier.None, bool consecutiveDelimiter = false, bool tab = false, bool semicolon = false, bool comma = false, bool space = false, bool other = false, char otherChar = &#39;\0&#39;, Tuple&lt;int, ColumnDataType&gt;[] fieldInfo = null, char decimalSeparator = &#39;\0&#39;, char thousandsSeparator = &#39;\0&#39;, bool trailingMinusNumbers = false)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Function TextToColumns(destination As String, Optional dataType As TextParsingType = TextParsingType.Delimited, Optional textQualifier As TextQualifier = TextQualifier.None, Optional consecutiveDelimiter As Boolean = False, Optional tab As Boolean = False, Optional semicolon As Boolean = False, Optional comma As Boolean = False, Optional space As Boolean = False, Optional other As Boolean = False, Optional otherChar As Char = vbNullChar, Optional fieldInfo As Tuple(Of Integer, ColumnDataType)() = Nothing, Optional decimalSeparator As Char = vbNullChar, Optional thousandsSeparator As Char = vbNullChar, Optional trailingMinusNumbers As Boolean = False) As ActionResult(Of Object)</code></pre>
</div>
<h5 class="parameters">Parameters</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Name</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.string">string</a></td>
      <td><span class="parametername">destination</span></td>
      <td><p>A string value that specifies where Spread will place the results. If the range is larger than a single cell, the top left cell is used.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="GrapeCity.Spreadsheet.TextParsingType.html">TextParsingType</a></td>
      <td><span class="parametername">dataType</span></td>
      <td><p>The format of the text to be split into columns.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="GrapeCity.Spreadsheet.TextQualifier.html">TextQualifier</a></td>
      <td><span class="parametername">textQualifier</span></td>
      <td><p>Specifies whether to use single, double, or no quotes as the text qualifier.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">consecutiveDelimiter</span></td>
      <td><p><code>true</code> to have Spread consider consecutive delimiters as one delimiter.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">tab</span></td>
      <td><p><code>true</code> to have <code class="paramref">dataType</code> be <a class="xref" href="GrapeCity.Spreadsheet.TextParsingType.html#GrapeCity_Spreadsheet_TextParsingType_Delimited">Delimited</a> and to have the tab character be a delimiter.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">semicolon</span></td>
      <td><p><code>true</code> to have <code class="paramref">dataType</code> be <a class="xref" href="GrapeCity.Spreadsheet.TextParsingType.html#GrapeCity_Spreadsheet_TextParsingType_Delimited">Delimited</a> and to have the semicolon character be a delimiter.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">comma</span></td>
      <td><p><code>true</code> to have <code class="paramref">dataType</code> be <a class="xref" href="GrapeCity.Spreadsheet.TextParsingType.html#GrapeCity_Spreadsheet_TextParsingType_Delimited">Delimited</a> and to have the comma character be a delimiter.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">space</span></td>
      <td><p><code>true</code> to have <code class="paramref">dataType</code> be <a class="xref" href="GrapeCity.Spreadsheet.TextParsingType.html#GrapeCity_Spreadsheet_TextParsingType_Delimited">Delimited</a> and to have the space character be a delimiter.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">other</span></td>
      <td><p><code>true</code> to have <code class="paramref">dataType</code> be <a class="xref" href="GrapeCity.Spreadsheet.TextParsingType.html#GrapeCity_Spreadsheet_TextParsingType_Delimited">Delimited</a> and to have the <code class="paramref">otherChar</code> character be a delimiter.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.char">char</a></td>
      <td><span class="parametername">otherChar</span></td>
      <td><p>Required if <code class="paramref">other</code> is <code>true</code>; the delimiter character when <code class="paramref">other</code> is <code>true</code>.
If more than one character is specified, only the first character of the string is used; the remaining characters are ignored.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.tuple-2">Tuple</a>&lt;<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a>, <a class="xref" href="GrapeCity.Spreadsheet.ColumnDataType.html">ColumnDataType</a>&gt;[]</td>
      <td><span class="parametername">fieldInfo</span></td>
      <td><p>An array containing parse information for the individual columns of data. The interpretation depends on the value of <code class="paramref">dataType</code>.
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 <a class="xref" href="GrapeCity.Spreadsheet.ColumnDataType.html">ColumnDataType</a> constants specifying how the column is parsed.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.char">char</a></td>
      <td><span class="parametername">decimalSeparator</span></td>
      <td><p>The decimal separator that Spread uses when recognizing numbers. The default setting is the system setting.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.char">char</a></td>
      <td><span class="parametername">thousandsSeparator</span></td>
      <td><p>The thousands separator that Spread uses when recognizing numbers. The default setting is the system setting.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">trailingMinusNumbers</span></td>
      <td><p>Numbers that begin with a minus character.</p>
</td>
    </tr>
  </tbody>
</table>
<h5 class="returns">Returns</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="GrapeCity.Spreadsheet.ActionResult-1.html">ActionResult</a>&lt;<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.object">object</a>&gt;</td>
      <td><p><code>true</code> if the columns are inserted successful, <code>false</code> otherwise.</p>
</td>
    </tr>
  </tbody>
</table>
</div>