google-sheets
Google spreadsheet with hyperlinks via JSON
I\'m using json-in-script to put content from a Google Spreadsheet on a web page. The spreadsheet has hyperlinks on some of the text in the cells. JSON doesn\'t seem to be getting anything other than[详细]
2023-03-16 19:29 分类:问答Upload script to google scripts gallery
Do anyone knows how to upload a script to google scripts gllery, so tha开发者_开发百科t i can install the script in the google spreadhseets and use that script in google docs(spreadsheets)As fas as I[详细]
2023-03-16 01:05 分类:问答Force download link on a google docs spreadsheet
Is there a way to force a download link instead of the browser trying to ope开发者_如何转开发n the file? In this case I have a docs spreadsheet and a some links to mp3 files. I want the users to downl[详细]
2023-03-06 20:03 分类:问答xpath in =importXML() for extracting meta descriptions
I\'m trying to use Xpath to pull in the meta descriptions from web pages, using Google Sheets. I have this working to pull in the titles:=importXml(www.example.com; \"//title\")[详细]
2023-03-06 17:51 分类:问答Adding a new sheet to a Google Spreadsheet via the Google Docs or Spreadsheet API
I\'m working on a project where I\'m pulling a bunch of information out of a Drupal MySQL database and put开发者_JS百科ting it in a Google Spreadsheet. My problem is that its a lot of data, and I\'d p[详细]
2023-03-06 07:02 分类:问答In GoogleApp Spreadsheet, how do I make onEdit event handler react to drag copying?
My onEdit event handler fires just fine when I edit spreadsheet cell manually, or when I paste into it by Ctrl+V, but completely ignores when I do \'drag-copying\'.[详细]
2023-03-05 14:51 分类:问答Insert Script on Google SpreadSheet programmatically
开发者_开发知识库I would like to know if it is possible to insert a Script in a GDocs SpreadSheet using the Google SpreadSheet API.[详细]
2023-03-05 10:43 分类:问答Android App Push Data to Google Spreadsheet
I\'m developing an Android-based scorekeeping application for the card game \"Spades\". Currently I am saving the results of each hand to a \"Hand History\" tab in text format.[详细]
2023-03-03 20:49 分类:问答Simple Google Script not working
I have decided to use Google Scripts when I can when using spreadsheets, just to start increasing knowledge. BUT I am untrained and got stuck quite quickly.[详细]
2023-03-01 12:17 分类:问答Get the range of the last X rows in Google Sheets
Say I have a spreadsheet with 18 rows, and I can hard code the range of the last 7 values in column D and average their values like so:[详细]
2023-03-01 01:58 分类:问答