Skip to main content

Search OfficeIMO

Enter a topic, API type, or PowerShell command.

Documentation Search all OfficeIMO/
Class

ExcelQueryBackedTableOptions

OfficeIMO.Excel

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

Options for an OfficeIMO-owned query-backed worksheet table.

Inheritance

  • object
  • ExcelQueryBackedTableOptions

Usage

Explore 1 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.

Accepted by parameters 1

Constructors

public ExcelQueryBackedTableOptions() #

Properties

public string ConnectionName { get; set; } #

Connection name stored in the workbook.

public string CommandText { get; set; } #

Opaque command text passed only to the caller-provided execution host.

public string WorksheetName { get; set; } #

Destination worksheet.

public string StartCell { get; set; } #

Top-left destination cell.

public string TableName { get; set; } #

Excel table name.

public IReadOnlyList<string> ColumnNames { get; set; } #

Initial ordered table schema.

public string? Description { get; set; } #

Optional workbook connection description.

public bool RefreshOnOpen { get; set; } #

Requests refresh-on-open metadata.