office-scripts-docs
office-scripts-docs copied to clipboard
The API you are trying to use cannot be found error returned when any of the Query class methods are called on getQueries
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: