Skip to main content

Search OfficeIMO

Enter a topic, API type, or PowerShell command.

Documentation Search all OfficeIMO/
Class

ExcelTableInfo

OfficeIMO.Excel

Namespace
OfficeIMO.Excel
Assembly
OfficeIMO.Excel
Source revision
0eef6a5756b9 with working tree changes
Modifiers
sealed

Represents a table defined in an Excel workbook.

Inheritance

  • object
  • ExcelTableInfo

Usage

Explore 2 API references to this type

This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.

Returned or exposed by 2

Constructors

public ExcelTableInfo(string name, string range, string sheetName, int sheetIndex) #

Initializes a new instance of the ExcelTableInfo class.

Parameters

name string required
Table name (or display name).
range string required
Table range in A1 notation.
sheetName string required
Sheet name containing the table.
sheetIndex int required
0-based sheet index; -1 when unknown.

Properties

public string Name { get; } #

Table name (or display name).

public string DisplayName { get; } #

Table display name.

public string Range { get; } #

Table range in A1 notation.

public string SheetName { get; } #

Sheet name containing the table.

public int SheetIndex { get; } #

0-based sheet index; -1 when unknown.

public string? StyleName { get; } #

Table style name, when present.

public bool HasHeaderRow { get; } #

Whether the table has a header row.

public bool TotalsRowShown { get; } #

Whether the table shows a totals row.

public bool HasAutoFilter { get; } #

Whether the table has a table-scoped AutoFilter.

public bool ShowFirstColumn { get; } #

Whether the table style emphasizes the first column.

public bool ShowLastColumn { get; } #

Whether the table style emphasizes the last column.

public bool ShowRowStripes { get; } #

Whether the table style applies alternating row formatting.

public bool ShowColumnStripes { get; } #

Whether the table style applies alternating column formatting.

public IReadOnlyList<ExcelTableColumnInfo> Columns { get; } #

Table columns in display order.