Document Solutions for Excel, .NET Edition | Document Solutions
GrapeCity.Documents.Excel Namespace / ITable Interface
Properties Methods

In This Topic
    ITable Interface Members
    In This Topic

    The following tables list the members exposed by ITable.

    Public Properties
     NameDescription
    PropertyAutoFilterFilters a list using the IAutoFilter (read-only).  
    PropertyAutoGenerateColumns Gets or sets whether to generate columns automatically while binding data.  
    PropertyBindingPath Gets or sets binding path of current table.  
    PropertyColumnsReturns an ITableColumns collection that represents all the columns in the ITable object.  
    PropertyComment Gets or sets the comment associated with the table object.  
    PropertyDataRangeReturns the IRange object that represents the range that contains the data area in the table between the header row and the insert row.  
    PropertyDisplayNameGets or sets the display name for the specified ITable.  
    PropertyExpandBoundRows Gets or sets whether to add/delete entire rows on data binding.  
    PropertyHeaderRangeReturns the IRange object that represents the range of the header row for a table.  
    PropertyNameGets or sets the name of the ITable object.  
    PropertyRangeReturns the IRange object that represents the range to which the specified table object applies.  
    PropertyRowsReturns the ITableRows that represents all the rows of data in the ITable object.  
    PropertyShowAutoFilter Gets or sets whether the AutoFilter is displayed.  
    PropertyShowAutoFilterDropDown Gets or sets whether the table filter button is visible.  
    PropertyShowHeadersGets or sets whether the header information should be displayed for the specified ITable object (read or write).  
    PropertyShowTableStyleColumnStripesGets or sets if the column stripes table style is used for the specified ITable object (read or write).  
    PropertyShowTableStyleFirstColumnGets or sets if the first column is formatted for the specified ITable object (read or write).  
    PropertyShowTableStyleLastColumnGets or sets if the last column is displayed for the specified ITable object (read or write).  
    PropertyShowTableStyleRowStripesGets or sets if the row stripes table style is used for the specified ITable object (read or write).  
    PropertyShowTotals Gets or sets whether the total row is visible.  
    PropertySortGets the sort column or columns, and sort order for the ITable collection.  
    PropertyTableStyleGets or sets the table style for the specified ITable object (read or write).  
    PropertyTotalsRangeReturns the IRange object that represents the Total row, if any, from a specified ITable object.  
    Top
    Public Methods
     NameDescription
    MethodConvertToRange Convert the range of cells that made up the table to a regular range of data.  
    MethodDeleteDeletes the ITable object and clears the cell data from the worksheet.  
    MethodFromJson Generate table from Json string.  
    MethodResizeThe Resize method allows the ITable object to be resized over a new range. No cells are inserted or moved. NOTE: The headers must remain in the same row, and the resulting table range must overlap the original table range.  
    MethodToJson Generate json string from table.  
    Top
    See Also

    Reference

    ITable Interface
    GrapeCity.Documents.Excel Namespace