API Reference

Class

ExcelQueryBackedTableOptions

Namespace OfficeIMO.Excel
Assembly OfficeIMO.Excel
Modifiers sealed

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

Inheritance

  • Object
  • ExcelQueryBackedTableOptions

Usage

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

Accepted by parameters

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 Boolean RefreshOnOpen { get; set; } #

Requests refresh-on-open metadata.