# GrapeCity.Spreadsheet.IWorksheet.SetValue

## Content

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



<h1 id="GrapeCity_Spreadsheet_IWorksheet_SetValue_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue*">SetValue Method
</h1>
<div class="markdown level0 summary"></div>
<div class="markdown level0 conceptual"></div>



<a id="GrapeCity_Spreadsheet_IWorksheet_SetValue_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue*"></a>
<h4 id="GrapeCity_Spreadsheet_IWorksheet_SetValue_System_Int32_System_Int32_System_Boolean_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue(System.Int32,System.Int32,System.Boolean)">SetValue(int, int, bool)</h4>
<div class="markdown level1 summary"><p>Sets the <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a> value for the cell of the specified row and column.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">bool SetValue(int row, int column, bool value)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Function SetValue(row As Integer, column As Integer, value As Boolean) As Boolean</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 indicates the row index of cell.</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 indicates the column index of cell.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">value</span></td>
      <td><p>An <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a> value to set</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="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><p><code>true</code> if success, <code>false</code> otherwise.</p>
</td>
    </tr>
  </tbody>
</table>


<a id="GrapeCity_Spreadsheet_IWorksheet_SetValue_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue*"></a>
<h4 id="GrapeCity_Spreadsheet_IWorksheet_SetValue_System_Int32_System_Int32_System_Byte_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue(System.Int32,System.Int32,System.Byte)">SetValue(int, int, byte)</h4>
<div class="markdown level1 summary"><p>Sets the <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a> value for the cell of the specified row and column.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">bool SetValue(int row, int column, byte value)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Function SetValue(row As Integer, column As Integer, value As Byte) As Boolean</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 indicates the row index of cell.</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 indicates the column index of cell.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.byte">byte</a></td>
      <td><span class="parametername">value</span></td>
      <td><p>An <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.byte">byte</a> value to set</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="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><p><code>true</code> if success, <code>false</code> otherwise.</p>
</td>
    </tr>
  </tbody>
</table>


<a id="GrapeCity_Spreadsheet_IWorksheet_SetValue_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue*"></a>
<h4 id="GrapeCity_Spreadsheet_IWorksheet_SetValue_System_Int32_System_Int32_GrapeCity_CalcEngine_CalcError_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue(System.Int32,System.Int32,GrapeCity.CalcEngine.CalcError)">SetValue(int, int, CalcError)</h4>
<div class="markdown level1 summary"><p>Sets the <a class="xref" href="../GrapeCity.CalcEngine/GrapeCity.CalcEngine.CalcError.html">CalcError</a> value for the cell of the specified row and column.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">bool SetValue(int row, int column, CalcError value)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Function SetValue(row As Integer, column As Integer, value As CalcError) As Boolean</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 indicates the row index of cell.</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 indicates the column index of cell.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="../GrapeCity.CalcEngine/GrapeCity.CalcEngine.CalcError.html">CalcError</a></td>
      <td><span class="parametername">value</span></td>
      <td><p>An <a class="xref" href="../GrapeCity.CalcEngine/GrapeCity.CalcEngine.CalcError.html">CalcError</a> value to set</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="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><p><code>true</code> if success, <code>false</code> otherwise.</p>
</td>
    </tr>
  </tbody>
</table>


<a id="GrapeCity_Spreadsheet_IWorksheet_SetValue_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue*"></a>
<h4 id="GrapeCity_Spreadsheet_IWorksheet_SetValue_System_Int32_System_Int32_System_DateTime_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue(System.Int32,System.Int32,System.DateTime)">SetValue(int, int, DateTime)</h4>
<div class="markdown level1 summary"><p>Sets the <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.datetime">DateTime</a> value for the cell of the specified row and column.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">bool SetValue(int row, int column, DateTime value)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Function SetValue(row As Integer, column As Integer, value As Date) As Boolean</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 indicates the row index of cell.</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 indicates the column index of cell.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.datetime">DateTime</a></td>
      <td><span class="parametername">value</span></td>
      <td><p>An <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.datetime">DateTime</a> value to set</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="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><p><code>true</code> if success, <code>false</code> otherwise.</p>
</td>
    </tr>
  </tbody>
</table>


<a id="GrapeCity_Spreadsheet_IWorksheet_SetValue_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue*"></a>
<h4 id="GrapeCity_Spreadsheet_IWorksheet_SetValue_System_Int32_System_Int32_System_Decimal_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue(System.Int32,System.Int32,System.Decimal)">SetValue(int, int, decimal)</h4>
<div class="markdown level1 summary"><p>Sets the <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a> value for the cell of the specified row and column.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">bool SetValue(int row, int column, decimal value)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Function SetValue(row As Integer, column As Integer, value As Decimal) As Boolean</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 indicates the row index of cell.</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 indicates the column index of cell.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.decimal">decimal</a></td>
      <td><span class="parametername">value</span></td>
      <td><p>An <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.decimal">decimal</a> value to set</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="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><p><code>true</code> if success, <code>false</code> otherwise.</p>
</td>
    </tr>
  </tbody>
</table>


<a id="GrapeCity_Spreadsheet_IWorksheet_SetValue_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue*"></a>
<h4 id="GrapeCity_Spreadsheet_IWorksheet_SetValue_System_Int32_System_Int32_System_Double_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue(System.Int32,System.Int32,System.Double)">SetValue(int, int, double)</h4>
<div class="markdown level1 summary"><p>Sets the <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.double">double</a> value for the cell of the specified row and column.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">bool SetValue(int row, int column, double value)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Function SetValue(row As Integer, column As Integer, value As Double) As Boolean</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 indicates the row index of cell.</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 indicates the column index of cell.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.double">double</a></td>
      <td><span class="parametername">value</span></td>
      <td><p>An <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.double">double</a> value to set</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="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><p><code>true</code> if success, <code>false</code> otherwise.</p>
</td>
    </tr>
  </tbody>
</table>


<a id="GrapeCity_Spreadsheet_IWorksheet_SetValue_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue*"></a>
<h4 id="GrapeCity_Spreadsheet_IWorksheet_SetValue_System_Int32_System_Int32_System_Single_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue(System.Int32,System.Int32,System.Single)">SetValue(int, int, float)</h4>
<div class="markdown level1 summary"><p>Sets the <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a> value for the cell of the specified row and column.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">bool SetValue(int row, int column, float value)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Function SetValue(row As Integer, column As Integer, value As Single) As Boolean</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 indicates the row index of cell.</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 indicates the column index of cell.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.single">float</a></td>
      <td><span class="parametername">value</span></td>
      <td><p>An <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.single">float</a> value to set</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="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><p><code>true</code> if success, <code>false</code> otherwise.</p>
</td>
    </tr>
  </tbody>
</table>


<a id="GrapeCity_Spreadsheet_IWorksheet_SetValue_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue*"></a>
<h4 id="GrapeCity_Spreadsheet_IWorksheet_SetValue_System_Int32_System_Int32_System_Int32_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue(System.Int32,System.Int32,System.Int32)">SetValue(int, int, int)</h4>
<div class="markdown level1 summary"><p>Sets the <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a> value for the cell of the specified row and column.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">bool SetValue(int row, int column, int value)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Function SetValue(row As Integer, column As Integer, value As Integer) As Boolean</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 indicates the row index of cell.</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 indicates the column index of cell.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">value</span></td>
      <td><p>An <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a> value to set</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="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><p><code>true</code> if success, <code>false</code> otherwise.</p>
</td>
    </tr>
  </tbody>
</table>


<a id="GrapeCity_Spreadsheet_IWorksheet_SetValue_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue*"></a>
<h4 id="GrapeCity_Spreadsheet_IWorksheet_SetValue_System_Int32_System_Int32_System_Int64_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue(System.Int32,System.Int32,System.Int64)">SetValue(int, int, long)</h4>
<div class="markdown level1 summary"><p>Sets the <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a> value for the cell of the specified row and column.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">bool SetValue(int row, int column, long value)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Function SetValue(row As Integer, column As Integer, value As Long) As Boolean</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 indicates the row index of cell.</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 indicates the column index of cell.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int64">long</a></td>
      <td><span class="parametername">value</span></td>
      <td><p>An <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int64">long</a> value to set</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="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><p><code>true</code> if success, <code>false</code> otherwise.</p>
</td>
    </tr>
  </tbody>
</table>


<a id="GrapeCity_Spreadsheet_IWorksheet_SetValue_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue*"></a>
<h4 id="GrapeCity_Spreadsheet_IWorksheet_SetValue_System_Int32_System_Int32_System_Object_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue(System.Int32,System.Int32,System.Object)">SetValue(int, int, object)</h4>
<div class="markdown level1 summary"><p>Sets the <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.object">object</a> value for the cell of the specified row and column.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">bool SetValue(int row, int column, object value)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Function SetValue(row As Integer, column As Integer, value As Object) As Boolean</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 indicates the row index of cell.</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 indicates the column index of cell.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.object">object</a></td>
      <td><span class="parametername">value</span></td>
      <td><p>An <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.object">object</a> value to set</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="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><p><code>true</code> if success, <code>false</code> otherwise.</p>
</td>
    </tr>
  </tbody>
</table>


<a id="GrapeCity_Spreadsheet_IWorksheet_SetValue_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue*"></a>
<h4 id="GrapeCity_Spreadsheet_IWorksheet_SetValue_System_Int32_System_Int32_System_Object_0__0___" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue(System.Int32,System.Int32,System.Object[0:,0:])">SetValue(int, int, object[,])</h4>
<div class="markdown level1 summary"><p>Sets an object array into a specified range of cells.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">bool SetValue(int row, int column, object[,] values)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Function SetValue(row As Integer, column As Integer, values As Object(,)) As Boolean</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>Row index of the start of the range of cells</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>Column index of the start of the range of cells</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.object">object</a>[,]</td>
      <td><span class="parametername">values</span></td>
      <td><p>Two-dimensional object array[row,column] that contains the values</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="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><p><code>true</code> if success, <code>false</code> otherwise.</p>
</td>
    </tr>
  </tbody>
</table>


<a id="GrapeCity_Spreadsheet_IWorksheet_SetValue_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue*"></a>
<h4 id="GrapeCity_Spreadsheet_IWorksheet_SetValue_System_Int32_System_Int32_System_Object_0__0___System_Boolean_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue(System.Int32,System.Int32,System.Object[0:,0:],System.Boolean)">SetValue(int, int, object[,], bool)</h4>
<div class="markdown level1 summary"><p>Sets an object array into a specified range of cells.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">bool SetValue(int row, int column, object[,] values, bool vertical)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Function SetValue(row As Integer, column As Integer, values As Object(,), vertical As Boolean) As Boolean</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>Row index of the start of the range of cells</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>Column index of the start of the range of cells</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.object">object</a>[,]</td>
      <td><span class="parametername">values</span></td>
      <td><p>Two-dimensional object array[row,column] that contains the values</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">vertical</span></td>
      <td><p>if True, array will be set follow column index, other, it will be set follow row index.</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="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><p><code>true</code> if success, <code>false</code> otherwise.</p>
</td>
    </tr>
  </tbody>
</table>


<a id="GrapeCity_Spreadsheet_IWorksheet_SetValue_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue*"></a>
<h4 id="GrapeCity_Spreadsheet_IWorksheet_SetValue_System_Int32_System_Int32_GrapeCity_CalcEngine_CellValue__" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue(System.Int32,System.Int32,GrapeCity.CalcEngine.CellValue@)">SetValue(int, int, ref CellValue)</h4>
<div class="markdown level1 summary"><p>Sets the <a class="xref" href="../GrapeCity.CalcEngine/GrapeCity.CalcEngine.CellValue.html">CellValue</a> value for the cell of the specified row and column.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">void SetValue(int row, int column, ref CellValue cellValue)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Sub SetValue(row As Integer, column As Integer, ByRef cellValue As CellValue)</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 indicates the row index of cell.</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 indicates the column index of cell.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="../GrapeCity.CalcEngine/GrapeCity.CalcEngine.CellValue.html">CellValue</a></td>
      <td><span class="parametername">cellValue</span></td>
      <td><p>An <a class="xref" href="../GrapeCity.CalcEngine/GrapeCity.CalcEngine.CellValue.html">CellValue</a> value to set</p>
</td>
    </tr>
  </tbody>
</table>


<a id="GrapeCity_Spreadsheet_IWorksheet_SetValue_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue*"></a>
<h4 id="GrapeCity_Spreadsheet_IWorksheet_SetValue_System_Int32_System_Int32_System_Int16_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue(System.Int32,System.Int32,System.Int16)">SetValue(int, int, short)</h4>
<div class="markdown level1 summary"><p>Sets the <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a> value for the cell of the specified row and column.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">bool SetValue(int row, int column, short value)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Function SetValue(row As Integer, column As Integer, value As Short) As Boolean</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 indicates the row index of cell.</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 indicates the column index of cell.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int16">short</a></td>
      <td><span class="parametername">value</span></td>
      <td><p>An <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int16">short</a> value to set</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="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><p><code>true</code> if success, <code>false</code> otherwise.</p>
</td>
    </tr>
  </tbody>
</table>


<a id="GrapeCity_Spreadsheet_IWorksheet_SetValue_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue*"></a>
<h4 id="GrapeCity_Spreadsheet_IWorksheet_SetValue_System_Int32_System_Int32_System_String_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue(System.Int32,System.Int32,System.String)">SetValue(int, int, string)</h4>
<div class="markdown level1 summary"><p>Sets the <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.string">string</a> value for the cell of the specified row and column.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">bool SetValue(int row, int column, string value)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Function SetValue(row As Integer, column As Integer, value As String) As Boolean</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 indicates the row index of cell.</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 indicates the column index of cell.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.string">string</a></td>
      <td><span class="parametername">value</span></td>
      <td><p>An <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.string">string</a> value to set</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="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><p><code>true</code> if success, <code>false</code> otherwise.</p>
</td>
    </tr>
  </tbody>
</table>


<a id="GrapeCity_Spreadsheet_IWorksheet_SetValue_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue*"></a>
<h4 id="GrapeCity_Spreadsheet_IWorksheet_SetValue__1_System_Int32_System_Int32___0_0__0___" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue``1(System.Int32,System.Int32,``0[0:,0:])">SetValue&lt;T&gt;(int, int, T[,])</h4>
<div class="markdown level1 summary"><p>Sets an object array into a specified range of cells.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">bool SetValue&lt;T&gt;(int row, int column, T[,] values)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Function SetValue(Of T)(row As Integer, column As Integer, values As T(,)) As Boolean</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>Row index of the start of the range of cells</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>Column index of the start of the range of cells</p>
</td>
    </tr>
    <tr>
      <td>T[,]</td>
      <td><span class="parametername">values</span></td>
      <td><p>Two-dimensional object array[row,column] that contains the values</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="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><p><code>true</code> if success, <code>false</code> otherwise.</p>
</td>
    </tr>
  </tbody>
</table>
<h5 class="typeParameters">Type Parameters</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Name</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><span class="parametername">T</span></td>
      <td></td>
    </tr>
  </tbody>
</table>


<a id="GrapeCity_Spreadsheet_IWorksheet_SetValue_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue*"></a>
<h4 id="GrapeCity_Spreadsheet_IWorksheet_SetValue__1_System_Int32_System_Int32___0_0__0___System_Boolean_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue``1(System.Int32,System.Int32,``0[0:,0:],System.Boolean)">SetValue&lt;T&gt;(int, int, T[,], bool)</h4>
<div class="markdown level1 summary"><p>Sets an object array into a specified range of cells.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">bool SetValue&lt;T&gt;(int row, int column, T[,] values, bool vertical)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Function SetValue(Of T)(row As Integer, column As Integer, values As T(,), vertical As Boolean) As Boolean</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>Row index of the start of the range of cells</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>Column index of the start of the range of cells</p>
</td>
    </tr>
    <tr>
      <td>T[,]</td>
      <td><span class="parametername">values</span></td>
      <td><p>Two-dimensional object array[row,column] that contains the values</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">vertical</span></td>
      <td><p>if True, array will be set follow column index, other, it will be set follow row index.</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="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><p><code>true</code> if success, <code>false</code> otherwise.</p>
</td>
    </tr>
  </tbody>
</table>
<h5 class="typeParameters">Type Parameters</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Name</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><span class="parametername">T</span></td>
      <td></td>
    </tr>
  </tbody>
</table>


<a id="GrapeCity_Spreadsheet_IWorksheet_SetValue_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue*"></a>
<h4 id="GrapeCity_Spreadsheet_IWorksheet_SetValue_System_Int32_System_Int32_System_Int32_System_Int32_System_Boolean_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue(System.Int32,System.Int32,System.Int32,System.Int32,System.Boolean)">SetValue(int, int, int, int, bool)</h4>
<div class="markdown level1 summary"><p>Sets the <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a> value for the cell of the specified cell range.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">bool SetValue(int row, int column, int row2, int column2, bool value)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Function SetValue(row As Integer, column As Integer, row2 As Integer, column2 As Integer, value As Boolean) As Boolean</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 indicates the top row index of cell range.</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 indicates the left column index of cell range.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">row2</span></td>
      <td><p>An integer value indicates the bottom row index of cell range.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">column2</span></td>
      <td><p>An integer value indicates the right column index of cell range.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">value</span></td>
      <td><p>An <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a> value to set</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="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><p><code>true</code> if success, <code>false</code> otherwise.</p>
</td>
    </tr>
  </tbody>
</table>


<a id="GrapeCity_Spreadsheet_IWorksheet_SetValue_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue*"></a>
<h4 id="GrapeCity_Spreadsheet_IWorksheet_SetValue_System_Int32_System_Int32_System_Int32_System_Int32_GrapeCity_CalcEngine_CalcError_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue(System.Int32,System.Int32,System.Int32,System.Int32,GrapeCity.CalcEngine.CalcError)">SetValue(int, int, int, int, CalcError)</h4>
<div class="markdown level1 summary"><p>Sets the <a class="xref" href="../GrapeCity.CalcEngine/GrapeCity.CalcEngine.CalcError.html">CalcError</a> value for the cell of the specified cell range.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">bool SetValue(int row, int column, int row2, int column2, CalcError value)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Function SetValue(row As Integer, column As Integer, row2 As Integer, column2 As Integer, value As CalcError) As Boolean</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 indicates the top row index of cell range.</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 indicates the left column index of cell range.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">row2</span></td>
      <td><p>An integer value indicates the bottom row index of cell range.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">column2</span></td>
      <td><p>An integer value indicates the right column index of cell range.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="../GrapeCity.CalcEngine/GrapeCity.CalcEngine.CalcError.html">CalcError</a></td>
      <td><span class="parametername">value</span></td>
      <td><p>An <a class="xref" href="../GrapeCity.CalcEngine/GrapeCity.CalcEngine.CalcError.html">CalcError</a> value to set</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="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><p><code>true</code> if success, <code>false</code> otherwise.</p>
</td>
    </tr>
  </tbody>
</table>


<a id="GrapeCity_Spreadsheet_IWorksheet_SetValue_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue*"></a>
<h4 id="GrapeCity_Spreadsheet_IWorksheet_SetValue_System_Int32_System_Int32_System_Int32_System_Int32_System_DateTime_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue(System.Int32,System.Int32,System.Int32,System.Int32,System.DateTime)">SetValue(int, int, int, int, DateTime)</h4>
<div class="markdown level1 summary"><p>Sets the <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.datetime">DateTime</a> value for the cell of the specified cell range.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">bool SetValue(int row, int column, int row2, int column2, DateTime value)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Function SetValue(row As Integer, column As Integer, row2 As Integer, column2 As Integer, value As Date) As Boolean</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 indicates the top row index of cell range.</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 indicates the left column index of cell range.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">row2</span></td>
      <td><p>An integer value indicates the bottom row index of cell range.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">column2</span></td>
      <td><p>An integer value indicates the right column index of cell range.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.datetime">DateTime</a></td>
      <td><span class="parametername">value</span></td>
      <td><p>An <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.datetime">DateTime</a> value to set</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="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><p><code>true</code> if success, <code>false</code> otherwise.</p>
</td>
    </tr>
  </tbody>
</table>


<a id="GrapeCity_Spreadsheet_IWorksheet_SetValue_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue*"></a>
<h4 id="GrapeCity_Spreadsheet_IWorksheet_SetValue_System_Int32_System_Int32_System_Int32_System_Int32_System_Double_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue(System.Int32,System.Int32,System.Int32,System.Int32,System.Double)">SetValue(int, int, int, int, double)</h4>
<div class="markdown level1 summary"><p>Sets the <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.double">double</a> value for the cell of the specified cell range.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">bool SetValue(int row, int column, int row2, int column2, double value)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Function SetValue(row As Integer, column As Integer, row2 As Integer, column2 As Integer, value As Double) As Boolean</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 indicates the top row index of cell range.</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 indicates the left column index of cell range.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">row2</span></td>
      <td><p>An integer value indicates the bottom row index of cell range.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">column2</span></td>
      <td><p>An integer value indicates the right column index of cell range.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.double">double</a></td>
      <td><span class="parametername">value</span></td>
      <td><p>An <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.double">double</a> value to set</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="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><p><code>true</code> if success, <code>false</code> otherwise.</p>
</td>
    </tr>
  </tbody>
</table>


<a id="GrapeCity_Spreadsheet_IWorksheet_SetValue_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue*"></a>
<h4 id="GrapeCity_Spreadsheet_IWorksheet_SetValue_System_Int32_System_Int32_System_Int32_System_Int32_System_Int32_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue(System.Int32,System.Int32,System.Int32,System.Int32,System.Int32)">SetValue(int, int, int, int, int)</h4>
<div class="markdown level1 summary"><p>Sets the <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a> value for the cell of the specified cell range.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">bool SetValue(int row, int column, int row2, int column2, int value)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Function SetValue(row As Integer, column As Integer, row2 As Integer, column2 As Integer, value As Integer) As Boolean</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 indicates the top row index of cell range.</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 indicates the left column index of cell range.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">row2</span></td>
      <td><p>An integer value indicates the bottom row index of cell range.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">column2</span></td>
      <td><p>An integer value indicates the right column index of cell range.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">value</span></td>
      <td><p>An <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a> value to set</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="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><p><code>true</code> if success, <code>false</code> otherwise.</p>
</td>
    </tr>
  </tbody>
</table>


<a id="GrapeCity_Spreadsheet_IWorksheet_SetValue_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue*"></a>
<h4 id="GrapeCity_Spreadsheet_IWorksheet_SetValue_System_Int32_System_Int32_System_Int32_System_Int32_System_Object_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue(System.Int32,System.Int32,System.Int32,System.Int32,System.Object)">SetValue(int, int, int, int, object)</h4>
<div class="markdown level1 summary"><p>Sets the value for the cell of the specified cell range.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">bool SetValue(int row, int column, int row2, int column2, object value)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Function SetValue(row As Integer, column As Integer, row2 As Integer, column2 As Integer, value As Object) As Boolean</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 indicates the top row index of cell range.</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 indicates the left column index of cell range.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">row2</span></td>
      <td><p>An integer value indicates the bottom row index of cell range.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">column2</span></td>
      <td><p>An integer value indicates the right column index of cell range.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.object">object</a></td>
      <td><span class="parametername">value</span></td>
      <td><p>An <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.object">object</a> value to set</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="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><p><code>true</code> if success, <code>false</code> otherwise.</p>
</td>
    </tr>
  </tbody>
</table>


<a id="GrapeCity_Spreadsheet_IWorksheet_SetValue_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue*"></a>
<h4 id="GrapeCity_Spreadsheet_IWorksheet_SetValue_System_Int32_System_Int32_System_Int32_System_Int32_System_String_" data-uid="GrapeCity.Spreadsheet.IWorksheet.SetValue(System.Int32,System.Int32,System.Int32,System.Int32,System.String)">SetValue(int, int, int, int, string)</h4>
<div class="markdown level1 summary"><p>Sets the <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.string">string</a> value for the cell of the specified cell range.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">bool SetValue(int row, int column, int row2, int column2, string value)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Function SetValue(row As Integer, column As Integer, row2 As Integer, column2 As Integer, value As String) As Boolean</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 indicates the top row index of cell range.</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 indicates the left column index of cell range.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">row2</span></td>
      <td><p>An integer value indicates the bottom row index of cell range.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">column2</span></td>
      <td><p>An integer value indicates the right column index of cell range.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.string">string</a></td>
      <td><span class="parametername">value</span></td>
      <td><p>An <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.string">string</a> value to set</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="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><p><code>true</code> if success, <code>false</code> otherwise.</p>
</td>
    </tr>
  </tbody>
</table>
</div>