Search This Blog

GAS Reference Book

Get the value of a cell in a sheet

Get link
Facebook
X
Pinterest
Email
Other Apps

January 29, 2018

var varSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("NameOfSheet");
var theVal = varSheet.getRange("A3").getValue();

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Create a submenu under Add ons

January 28, 2018

function onOpen() { SpreadsheetApp.getUi().createAddonMenu().addItem("Show side bar", "functionToShowSideBar").addToUi(); } You use DocumentApp.getUi() if using google docs. Use SpreadsheetApp.getUi() if using google sheets.

Create a button in google sheets

January 27, 2018

Select a cell in google sheet. Insert->Drawing. Insert a textbox. Add text to it and give it an outline. Save and close. Go to Tools->Script Editor. Create a new function, for instance: function hello() { } Click on the 3 dots at the top right hand corner of the textbox you have created. Click on assign script. Assign it the name of the function - hello.