Note
Access to this page requires authorization. You can try signing in or .
Access to this page requires authorization. You can try .
Excel.Interfaces.QueryLoadOptions interface
- Package:
- excel
Represents a Power Query query.
Properties
| $all | Specifying |
| 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
loadedTo
Gets the query loaded to object type.
loadedTo?: boolean;Property Value
boolean
Remarks
loadedToDataModel
Specifies if the query loaded to the data model.
loadedToDataModel?: boolean;Property Value
boolean
Remarks
name
Gets the name of the query. Query names cannot contain periods or quotation marks.
name?: boolean;Property Value
boolean
Remarks
refreshDate
Gets the date and time when the query was last refreshed.
refreshDate?: boolean;Property Value
boolean
Remarks
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
Office Add-ins
Feedback
Was this page helpful?