All of the Query class methods do not work with the workbook.getQueries() method; however, these methods all seem to work on an individual Query object returned by workbook.getQuery("name")
To reproduce:
function main(workbook: ExcelScript.Workbook) {
const queries = workbook.getQueries();
queries.forEach((query: ExcelScript.Query) => {
console.log(query.getName()); //replace with any Query class method
});
}
Errors returned in console:
Working methods when called on `getQuery()`:
function main(workbook: ExcelScript.Workbook) {
const query = workbook.getQuery("MASTERFORECAST");
console.log(query.getLoadedToDataModel());
}
Output:
All of the
Queryclass methods do not work with theworkbook.getQueries()method; however, these methods all seem to work on an individual Query object returned byworkbook.getQuery("name")To reproduce:
Errors returned in console:
Working methods when called on `getQuery()`:
Output:
