API Reference
Class
ExcelTable
Lightweight object model wrapper for an Excel table.
Inheritance
- Object
- ExcelTable
Usage
This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.
Returned or exposed by
- Method ExcelRange.CreateTable
- Method ExcelSheet.Table
- Method ExcelTable.AppendDataTable
- Method ExcelTable.ClearTotals
- Method ExcelTable.SetStyle
- Method ExcelTable.SetTotals
- Method ExcelTable.SortByColumn
Methods
public ExcelTable AppendDataTable(DataTable table) #Returns:
ExcelTableAppends rows from a data table to the Excel table.
Parameters
- table System.Data.DataTable
public ExcelTable SetStyle(TableStyle style, Nullable<Boolean> showFirstColumn = null, Nullable<Boolean> showLastColumn = null, Nullable<Boolean> showRowStripes = null, Nullable<Boolean> showColumnStripes = null) #Returns:
ExcelTableApplies a built-in table style and optional style flags.
Parameters
- style OfficeIMO.Excel.TableStyle
- showFirstColumn System.Nullable{System.Boolean} = null
- showLastColumn System.Nullable{System.Boolean} = null
- showRowStripes System.Nullable{System.Boolean} = null
- showColumnStripes System.Nullable{System.Boolean} = null
public ExcelTable SetTotals(IDictionary<String, TotalsRowFunctionValues> byHeader) #Returns:
ExcelTableApplies totals row functions by header name.
Parameters
- byHeader System.Collections.Generic.IDictionary{System.String,DocumentFormat.OpenXml.Spreadsheet.TotalsRowFunctionValues}
public ExcelTable SortByColumn(Int32 columnOffset, Boolean ascending = true) #Returns:
ExcelTableSorts table rows by a 1-based column offset.
Parameters
- columnOffset System.Int32
- ascending System.Boolean = true
Inherited Methods
public override Boolean Equals(Object obj) #Returns:
BooleanInherited from Object
Parameters
- obj Object