API Reference
Class
ExcelPowerQueryMetadataOptions
Safe metadata options for workbook connection and query-table package parts.
Inheritance
- Object
- ExcelPowerQueryMetadataOptions
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 ExcelPowerQueryMetadataOptions() #Inherited Methods
public override Boolean Equals(Object obj) #Returns:
BooleanInherited from Object
Parameters
- obj Object
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 Boolean RefreshOnOpen { get; set; } #Request refresh-on-open metadata on the authored connection.