# GrapeCity.Documents.Excel.ITableColumn.DataBodyRange

## Content

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



<h1 id="GrapeCity_Documents_Excel_ITableColumn_DataBodyRange_" data-uid="GrapeCity.Documents.Excel.ITableColumn.DataBodyRange*">DataBodyRange Property
</h1>
<div class="markdown level0 summary"></div>
<div class="markdown level0 conceptual"></div>



<a id="GrapeCity_Documents_Excel_ITableColumn_DataBodyRange_" data-uid="GrapeCity.Documents.Excel.ITableColumn.DataBodyRange*"></a>
<h4 id="GrapeCity_Documents_Excel_ITableColumn_DataBodyRange" data-uid="GrapeCity.Documents.Excel.ITableColumn.DataBodyRange">DataBodyRange</h4>
<div class="markdown level1 summary"><p>Gets the <a class="xref" href="GrapeCity.Documents.Excel.IRange.html">IRange</a> that represents the data body cells of this table column.</p>
<p>
The returned range includes only the data rows in the column and excludes
the header cell and totals cell.
</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">IRange DataBodyRange { get; }</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">ReadOnly Property DataBodyRange As IRange</code></pre>
</div>
<h5 id="GrapeCity_Documents_Excel_ITableColumn_DataBodyRange_examples">Examples</h5>
<pre><code class="lang-csharp">worksheet.Range["A1:B3"].Value = new object[,] {
    {"Product", "Amount"},
    {"Apple", 100},
    {"Pear", 200}
};
ITable table = worksheet.Tables.Add(worksheet.Range["A1:B3"], true);
ITableColumn tableColumn = table.Columns[1];
IRange dataBodyRange = tableColumn.DataBodyRange;
dataBodyRange.Value = new object[,] {{120}, {220}};</code></pre>

</div>