Excel.Interfaces.QueryLoadOptions interface

Represents a Power Query query.

Remarks

[ API set: ExcelApi 1.14 ]

Properties

$all

Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as 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 load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as 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 ]