CODEWITHSUNDEEP
google-chromegoogle-apps-scriptgoogle-chrome-extensiongoogle-sheets
TechNerdXp
TechNerdXp

Reputation: 417

Google Apps script to navigate to given row of google sheet

I'm developing a Chrome extension that has access to Google Sheets using a standalone Google Apps Script. I need help to be able to navigate and highlight given variable row from my extension. either using Apps Script or some other way.

I've tried this code in google apps script.

function navigateToRow(parameters) {
  var ss = SpreadsheetApp.openByUrl(parameters.url)
  var sheet = ss.getSheets()[0]
  var range = sheet.getRange('A1:D10'); // will get range from parameters in future
  range.activate();
}

There is another solution that could solve the problem, but it refreshes the page: using url parameters, e.g. https://docs.google.com/spreadsheets/d/<spreadsheet id>/edit#gid=<sheet id>&range=<a1 notation>.

Upvotes: 0

Views: 1266

Answers (2)

TechNerdXp
TechNerdXp

Reputation: 417

Solved using these lines of code inside the content-script.

hash = window.location.hash.split('&range=')[0]
hash += `&range=${currentRowInput.value}:${currentRowInput.value}#`;
window.location.hash = hash

Upvotes: 0

Umair Mohammad
Umair Mohammad

Reputation: 4635

Try something like :

var range = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getRange(1, 1);
SpreadsheetApp.setActiveRange(range);

Reference : https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app#setactiverangerange

Upvotes: 1

Related Questions