Class
ExcelPowerQueryMetadataOptions
OfficeIMO.Excel
Safe metadata options for workbook connection and query-table package parts.
Inheritance
- object
- ExcelPowerQueryMetadataOptions
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 ExcelPowerQueryMetadataOptions() #Inherited Methods
Properties
public string Name { get; set; } #Connection name shown by Excel-compatible applications.
public string? WorksheetName { get; set; } #Optional worksheet name that should own query-table metadata.
public string? QueryTableName { get; set; } #Optional query-table name. Defaults to the connection name with "Table" suffix.
public string? Description { get; set; } #Connection description stored in package metadata.
public string? CommandText { get; set; } #Power Query M expression stored as metadata for Excel to own and execute.
public bool RefreshOnOpen { get; set; } #Request refresh-on-open metadata on the authored connection.