Can the google spreadsheet ‘query’ function be used in google apps script?

by

I do not know whether there is a restriction on that …

function test () {
  var req = query("=QUERY(shopT!B2:E; \"select min(E) where (B=3 or B=4 and D=2) group by C, D\")");

  Logger.log(req);
}

function query(request) { 
  var sheet = sp.insertSheet();
  var r = sheet.getRange(1, 1).setFormula(request);

  var reply = sheet.getDataRange().getValues();
  sp.deleteSheet(sheet);

  return reply;
}

More Related Contents:

  1. Can the google spreadsheet ‘query’ function be used in google apps script?
  2. How to protect the Apps Script code in a Google spreadsheet?
  3. Is there a way to evaluate a formula that is stored in a cell?
  4. Automatic timestamp when a cell is filled out
  5. Apps Script: how to get hyperlink from a cell where there is no formula
  6. How to auto select range from a filter without having to manually enter it?
  7. Script to Change Row Color when a cell changes text
  8. Sheet.getRange(1,1,1,12) what does the numbers in bracket specify?
  9. You do not have permission to call openById
  10. Google Apps Script, copy one spreadsheet to another spreadsheet with formatting
  11. Single Google Form for multiple Sheets [duplicate]
  12. How do I communicate a page(modal dialog) with its sibling (sidebar)?
  13. How to replace text in Google Spreadsheet using App Scripts?
  14. copy data from one sheet to another in google app script and append a row, one small issue
  15. Google App Scripts cannot be given Authorization or Permission
  16. Refresh data retrieved by a custom function in Google Sheet
  17. How to extract the link from a cell now that links are not reflected as HYPERLINK?
  18. Google Apps Script: Dynamically creating spreadsheet menu items
  19. Increment Cell value by one by clicking
  20. email notification if cell is changed
  21. Apply multiple font colors to the text in a single Google Sheets cell
  22. How to evaluate a spreadsheet formula within a custom function?
  23. Google Sheet use Importxml error could not fetch url [duplicate]
  24. On Edit doesnt work if cell auto updates – Need a workaround Google Sheets
  25. Adding a property to an Html template gives error “Object does not allow properties to be added or changed”
  26. Use script in all spreadsheets
  27. How to pause App Scripts until spreadsheet finishes calculation
  28. Custom Functions and Recalculation
  29. How to create INDIRECT array string of multiple sheet references in Google Sheets?
  30. google script openById : You do not have permission to perform that action

Leave a Comment