Excel.Interfaces.QueryData interface
An interface describing the data returned by calling query.toJSON()
.
Properties
error | Gets the query error message from when the query was last refreshed. |
loaded |
Gets the query loaded to object type. |
loaded |
Specifies if the query loaded to the data model. |
name | Gets the name of the query. Query names cannot contain periods or quotation marks. |
refresh |
Gets the date and time when the query was last refreshed. |
rows |
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
error
Gets the query error message from when the query was last refreshed.
error?: Excel.QueryError | "Unknown" | "None" | "FailedLoadToWorksheet" | "FailedLoadToDataModel" | "FailedDownload" | "FailedToCompleteDownload";
Property Value
Excel.QueryError | "Unknown" | "None" | "FailedLoadToWorksheet" | "FailedLoadToDataModel" | "FailedDownload" | "FailedToCompleteDownload"
Remarks
loadedTo
Gets the query loaded to object type.
loadedTo?: Excel.LoadToType | "ConnectionOnly" | "Table" | "PivotTable" | "PivotChart";
Property Value
Excel.LoadToType | "ConnectionOnly" | "Table" | "PivotTable" | "PivotChart"
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?: string;
Property Value
string
Remarks
refreshDate
Gets the date and time when the query was last refreshed.
refreshDate?: Date;
Property Value
Date
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?: number;
Property Value
number
Remarks
Office Add-ins