# GrapeCity.Spreadsheet.ITable

## Content

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



  <h1 id="GrapeCity_Spreadsheet_ITable" data-uid="GrapeCity.Spreadsheet.ITable" class="text-break">ITable Interface
</h1>
  <div class="markdown level0 summary"><p>Represents a table of the worksheet.</p>
</div>
  <div class="markdown level0 conceptual"></div>
  <h6><strong>Namespace</strong>: <a class="xref" href="GrapeCity.Spreadsheet.html">GrapeCity.Spreadsheet</a></h6>
  <h6><strong>Assembly</strong>: GrapeCity.Spreadsheet.dll</h6>
  <h5 id="GrapeCity_Spreadsheet_ITable_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">public interface ITable</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">Public Interface ITable</code></pre>
  </div>
  <h3 id="properties">Properties
</h3>
  <table class="table table-bordered table-condensed">
    <thead>
      <tr>
        <th>Name</th>
        <th>Description</th>
      </tr>
    </thead>
    <tbody>
      <tr>
        <td id="GrapeCity_Spreadsheet_ITable_Active" data-uid="GrapeCity.Spreadsheet.ITable.Active">
          <a class="xref" href="GrapeCity.Spreadsheet.ITable.Active.html#GrapeCity_Spreadsheet_ITable_Active">Active</a>
        </td>
        <td class="markdown level1 summary"><p>Gets a value indicating whether the active cell of worksheet is inside the range of this <a class="xref" href="GrapeCity.Spreadsheet.ITable.html">ITable</a> object.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ITable_AutoFilter" data-uid="GrapeCity.Spreadsheet.ITable.AutoFilter">
          <a class="xref" href="GrapeCity.Spreadsheet.ITable.AutoFilter.html#GrapeCity_Spreadsheet_ITable_AutoFilter">AutoFilter</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the filter of this <a class="xref" href="GrapeCity.Spreadsheet.ITable.html">ITable</a>.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ITable_AutoGenerateColumns" data-uid="GrapeCity.Spreadsheet.ITable.AutoGenerateColumns">
          <a class="xref" href="GrapeCity.Spreadsheet.ITable.AutoGenerateColumns.html#GrapeCity_Spreadsheet_ITable_AutoGenerateColumns">AutoGenerateColumns</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether to generate the columns automatically based on the data source.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ITable_Comment" data-uid="GrapeCity.Spreadsheet.ITable.Comment">
          <a class="xref" href="GrapeCity.Spreadsheet.ITable.Comment.html#GrapeCity_Spreadsheet_ITable_Comment">Comment</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the comment associated with the <a class="xref" href="GrapeCity.Spreadsheet.ITable.html">ITable</a> object.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ITable_DataAllowAddNew" data-uid="GrapeCity.Spreadsheet.ITable.DataAllowAddNew">
          <a class="xref" href="GrapeCity.Spreadsheet.ITable.DataAllowAddNew.html#GrapeCity_Spreadsheet_ITable_DataAllowAddNew">DataAllowAddNew</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether to allow the user to add a new row when the table is bound.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ITable_DataBodyRange" data-uid="GrapeCity.Spreadsheet.ITable.DataBodyRange">
          <a class="xref" href="GrapeCity.Spreadsheet.ITable.DataBodyRange.html#GrapeCity_Spreadsheet_ITable_DataBodyRange">DataBodyRange</a>
        </td>
        <td class="markdown level1 summary"><p>Gets an <a class="xref" href="GrapeCity.Spreadsheet.IRange.html">IRange</a> object that represents the range of values, excluding the header row, in a table.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ITable_DataSource" data-uid="GrapeCity.Spreadsheet.ITable.DataSource">
          <a class="xref" href="GrapeCity.Spreadsheet.ITable.DataSource.html#GrapeCity_Spreadsheet_ITable_DataSource">DataSource</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the data source that populates the table.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ITable_HeaderRowRange" data-uid="GrapeCity.Spreadsheet.ITable.HeaderRowRange">
          <a class="xref" href="GrapeCity.Spreadsheet.ITable.HeaderRowRange.html#GrapeCity_Spreadsheet_ITable_HeaderRowRange">HeaderRowRange</a>
        </td>
        <td class="markdown level1 summary"><p>Gets an <a class="xref" href="GrapeCity.Spreadsheet.IRange.html">IRange</a> object that represents the range of the header row for a table.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ITable_Name" data-uid="GrapeCity.Spreadsheet.ITable.Name">
          <a class="xref" href="GrapeCity.Spreadsheet.ITable.Name.html#GrapeCity_Spreadsheet_ITable_Name">Name</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the name of <a class="xref" href="GrapeCity.Spreadsheet.ITable.html">ITable</a> object.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ITable_Range" data-uid="GrapeCity.Spreadsheet.ITable.Range">
          <a class="xref" href="GrapeCity.Spreadsheet.ITable.Range.html#GrapeCity_Spreadsheet_ITable_Range">Range</a>
        </td>
        <td class="markdown level1 summary"><p>Gets an <a class="xref" href="GrapeCity.Spreadsheet.IRange.html">IRange</a> object that represents the range to which the specified table in the above list applies.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ITable_ShowAutoFilter" data-uid="GrapeCity.Spreadsheet.ITable.ShowAutoFilter">
          <a class="xref" href="GrapeCity.Spreadsheet.ITable.ShowAutoFilter.html#GrapeCity_Spreadsheet_ITable_ShowAutoFilter">ShowAutoFilter</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets a boolean value indicating whether the <a class="xref" href="GrapeCity.Spreadsheet.ITable.AutoFilter.html#GrapeCity_Spreadsheet_ITable_AutoFilter">AutoFilter</a> will be displayed.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ITable_ShowAutoFilterDropDown" data-uid="GrapeCity.Spreadsheet.ITable.ShowAutoFilterDropDown">
          <a class="xref" href="GrapeCity.Spreadsheet.ITable.ShowAutoFilterDropDown.html#GrapeCity_Spreadsheet_ITable_ShowAutoFilterDropDown">ShowAutoFilterDropDown</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets a boolean value indicating whether the <a class="xref" href="GrapeCity.Spreadsheet.ITable.AutoFilter.html#GrapeCity_Spreadsheet_ITable_AutoFilter">AutoFilter</a> drop down for the table object is displayed.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ITable_ShowHeaders" data-uid="GrapeCity.Spreadsheet.ITable.ShowHeaders">
          <a class="xref" href="GrapeCity.Spreadsheet.ITable.ShowHeaders.html#GrapeCity_Spreadsheet_ITable_ShowHeaders">ShowHeaders</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets a value indicating whether the header row is visible.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ITable_ShowTableStyleColumnStripes" data-uid="GrapeCity.Spreadsheet.ITable.ShowTableStyleColumnStripes">
          <a class="xref" href="GrapeCity.Spreadsheet.ITable.ShowTableStyleColumnStripes.html#GrapeCity_Spreadsheet_ITable_ShowTableStyleColumnStripes">ShowTableStyleColumnStripes</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets a value indicating whether the Column Stripes table style is used for the specified table object.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ITable_ShowTableStyleFirstColumn" data-uid="GrapeCity.Spreadsheet.ITable.ShowTableStyleFirstColumn">
          <a class="xref" href="GrapeCity.Spreadsheet.ITable.ShowTableStyleFirstColumn.html#GrapeCity_Spreadsheet_ITable_ShowTableStyleFirstColumn">ShowTableStyleFirstColumn</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets a value indicating whether the first column is formatted for the specified table object.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ITable_ShowTableStyleLastColumn" data-uid="GrapeCity.Spreadsheet.ITable.ShowTableStyleLastColumn">
          <a class="xref" href="GrapeCity.Spreadsheet.ITable.ShowTableStyleLastColumn.html#GrapeCity_Spreadsheet_ITable_ShowTableStyleLastColumn">ShowTableStyleLastColumn</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets a value indicating whether the last column is displayed for the specified table object.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ITable_ShowTableStyleRowStripes" data-uid="GrapeCity.Spreadsheet.ITable.ShowTableStyleRowStripes">
          <a class="xref" href="GrapeCity.Spreadsheet.ITable.ShowTableStyleRowStripes.html#GrapeCity_Spreadsheet_ITable_ShowTableStyleRowStripes">ShowTableStyleRowStripes</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets a value indicating whether the Row Stripes table style is used for the specified table object.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ITable_ShowTotals" data-uid="GrapeCity.Spreadsheet.ITable.ShowTotals">
          <a class="xref" href="GrapeCity.Spreadsheet.ITable.ShowTotals.html#GrapeCity_Spreadsheet_ITable_ShowTotals">ShowTotals</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets a value indicating whether the total row is visible.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ITable_Slicers" data-uid="GrapeCity.Spreadsheet.ITable.Slicers">
          <a class="xref" href="GrapeCity.Spreadsheet.ITable.Slicers.html#GrapeCity_Spreadsheet_ITable_Slicers">Slicers</a>
        </td>
        <td class="markdown level1 summary"><p>Gets a list of the table slicers associated with an <a class="xref" href="GrapeCity.Spreadsheet.ITable.html">ITable</a>.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ITable_Sort" data-uid="GrapeCity.Spreadsheet.ITable.Sort">
          <a class="xref" href="GrapeCity.Spreadsheet.ITable.Sort.html#GrapeCity_Spreadsheet_ITable_Sort">Sort</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the sort object.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ITable_TableColumns" data-uid="GrapeCity.Spreadsheet.ITable.TableColumns">
          <a class="xref" href="GrapeCity.Spreadsheet.ITable.TableColumns.html#GrapeCity_Spreadsheet_ITable_TableColumns">TableColumns</a>
        </td>
        <td class="markdown level1 summary"><p>Gets a <a class="xref" href="GrapeCity.Spreadsheet.ITableColumns.html">ITableColumns</a> collection that represents all the columns in a <a class="xref" href="GrapeCity.Spreadsheet.ITable.html">ITable</a> object.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ITable_TableRows" data-uid="GrapeCity.Spreadsheet.ITable.TableRows">
          <a class="xref" href="GrapeCity.Spreadsheet.ITable.TableRows.html#GrapeCity_Spreadsheet_ITable_TableRows">TableRows</a>
        </td>
        <td class="markdown level1 summary"><p>Gets a <a class="xref" href="GrapeCity.Spreadsheet.ITableRows.html">ITableRows</a> collection that represents all the rows in a <a class="xref" href="GrapeCity.Spreadsheet.ITable.html">ITable</a> object.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ITable_TableStyle" data-uid="GrapeCity.Spreadsheet.ITable.TableStyle">
          <a class="xref" href="GrapeCity.Spreadsheet.ITable.TableStyle.html#GrapeCity_Spreadsheet_ITable_TableStyle">TableStyle</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the <a class="xref" href="GrapeCity.Spreadsheet.ITable.TableStyle.html#GrapeCity_Spreadsheet_ITable_TableStyle">TableStyle</a> indicates which style will be applied to this <a class="xref" href="GrapeCity.Spreadsheet.ITable.html">ITable</a>.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ITable_TableStyleName" data-uid="GrapeCity.Spreadsheet.ITable.TableStyleName">
          <a class="xref" href="GrapeCity.Spreadsheet.ITable.TableStyleName.html#GrapeCity_Spreadsheet_ITable_TableStyleName">TableStyleName</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the string value indicates which style will be applied to this <a class="xref" href="GrapeCity.Spreadsheet.ITable.html">ITable</a>.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ITable_TotalsRowRange" data-uid="GrapeCity.Spreadsheet.ITable.TotalsRowRange">
          <a class="xref" href="GrapeCity.Spreadsheet.ITable.TotalsRowRange.html#GrapeCity_Spreadsheet_ITable_TotalsRowRange">TotalsRowRange</a>
        </td>
        <td class="markdown level1 summary"><p>Gets an <a class="xref" href="GrapeCity.Spreadsheet.IRange.html">IRange</a> object representing the Total row, if any, from a specified table object.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ITable_Worksheet" data-uid="GrapeCity.Spreadsheet.ITable.Worksheet">
          <a class="xref" href="GrapeCity.Spreadsheet.ITable.Worksheet.html#GrapeCity_Spreadsheet_ITable_Worksheet">Worksheet</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the worksheet object for the specified table.</p>
</td>
      </tr>
    </tbody>
  </table>
  <h3 id="methods">Methods
</h3>
  <table class="table table-bordered table-condensed">
    <thead>
      <tr>
        <th>Name</th>
        <th>Description</th>
      </tr>
    </thead>
    <tbody>
      <tr>
        <td id="GrapeCity_Spreadsheet_ITable_Delete_System_Boolean_" data-uid="GrapeCity.Spreadsheet.ITable.Delete(System.Boolean)">
          <a class="xref" href="GrapeCity.Spreadsheet.ITable.Delete.html#GrapeCity_Spreadsheet_ITable_Delete_System_Boolean_">Delete(bool)</a>
        </td>
        <td class="markdown level1 summary"><p>Deletes this <a class="xref" href="GrapeCity.Spreadsheet.ITable.html">ITable</a> from the worksheet.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ITable_Resize_GrapeCity_Spreadsheet_IRange_" data-uid="GrapeCity.Spreadsheet.ITable.Resize(GrapeCity.Spreadsheet.IRange)">
          <a class="xref" href="GrapeCity.Spreadsheet.ITable.Resize.html#GrapeCity_Spreadsheet_ITable_Resize_GrapeCity_Spreadsheet_IRange_">Resize(IRange)</a>
        </td>
        <td class="markdown level1 summary"><p>Resizes the boundary of this table over a new range. No cells are inserted or moved.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ITable_Resize_System_Int32_System_Int32_System_Int32_" data-uid="GrapeCity.Spreadsheet.ITable.Resize(System.Int32,System.Int32,System.Int32)">
          <a class="xref" href="GrapeCity.Spreadsheet.ITable.Resize.html#GrapeCity_Spreadsheet_ITable_Resize_System_Int32_System_Int32_System_Int32_">Resize(int, int, int)</a>
        </td>
        <td class="markdown level1 summary"><p>Resizes the boundary of this table over a new range. No cells are inserted or moved.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ITable_Resize_System_String_" data-uid="GrapeCity.Spreadsheet.ITable.Resize(System.String)">
          <a class="xref" href="GrapeCity.Spreadsheet.ITable.Resize.html#GrapeCity_Spreadsheet_ITable_Resize_System_String_">Resize(string)</a>
        </td>
        <td class="markdown level1 summary"><p>Resizes the boundary of this table over a new range. No cells are inserted or moved.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_ITable_Unlist" data-uid="GrapeCity.Spreadsheet.ITable.Unlist">
          <a class="xref" href="GrapeCity.Spreadsheet.ITable.Unlist.html#GrapeCity_Spreadsheet_ITable_Unlist">Unlist()</a>
        </td>
        <td class="markdown level1 summary"><p>Convert data of this <a class="xref" href="GrapeCity.Spreadsheet.ITable.html">ITable</a> into normal cells and deletes it from the worksheet.</p>
</td>
      </tr>
    </tbody>
  </table>

</div>