Excel.Interfaces.QueryLoadOptions interface

Package:

excel

Represents a Power Query query.

Remarks

[ API set: ExcelApi 1.14 ]

Properties

$all	Specifying $all for the LoadOptions loads all the scalar properties (e.g.: Range.address) but not the navigational properties (e.g.: Range.format.fill.color).
error	Gets the query error message from when the query was last refreshed.
loadedTo	Gets the query loaded to object type.
loadedToDataModel	Specifies if the query loaded to the data model.
name	Gets the name of the query. Query names cannot contain periods or quotation marks.
refreshDate	Gets the date and time when the query was last refreshed.
rowsLoadedCount	Gets the number of rows that were loaded when the query was last refreshed. If last refresh has errors the value will be -1.

Property Details

$all

Specifying $all for the LoadOptions loads all the scalar properties (e.g.: Range.address) but not the navigational properties (e.g.: Range.format.fill.color).

$all?: boolean;

Property Value

boolean

error

Gets the query error message from when the query was last refreshed.

error?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.14 ]

loadedTo

Gets the query loaded to object type.

loadedTo?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.14 ]

loadedToDataModel

Specifies if the query loaded to the data model.

loadedToDataModel?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.14 ]

name

Gets the name of the query. Query names cannot contain periods or quotation marks.

name?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.14 ]

refreshDate

Gets the date and time when the query was last refreshed.

refreshDate?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.14 ]

rowsLoadedCount

Gets the number of rows that were loaded when the query was last refreshed. If last refresh has errors the value will be -1.

rowsLoadedCount?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.14 ]