Faster way to copy a cell value and send it to another spreadsheet via script (Google Sheets)

user_11462274 0
Viewed 54

I wonder if there is a more simplified and faster model to send the value of a cell to another spreadsheet.

My actual script:

  var sss = SpreadsheetApp.openById('AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA');
  var ss = sss.getSheetByName('Valores por Vantagem');
  var range = ss.getRange('F1');
  var data = range.getValues();
  var tss = SpreadsheetApp.openById('BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB');
  var ts = tss.getSheetByName('Gerais');
  if(ts.getMaxRows() <= data.length) ts.insertRows(2, data.length);
  ts.getRange(268, 1, data.length, data[0].length).setValues(data);
google-apps-script google-sheets
1 Answers

A more simplified solution would be the following.

  • Since you want to copy the value of a single cell, use SetValue instead of SetValues and change the range at the end:

    var data = range.getValues() => var data = range.getValue().

  • Also, replace:

    ts.getRange(268, 1, data.length, data[0].length).setValues(data)

    with: ts.getRange(268, 1).setValue(data).

    since data now is a single element.

  • Finally, you can get rid of if(ts.getMaxRows() <= data.length) ts.insertRows(2, data.length).

Solution:

function myFunction(){

var sss = SpreadsheetApp.openById('AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA');
  var ss = sss.getSheetByName('Valores por Vantagem');
  var range = ss.getRange('F1');
  var data = range.getValue();
  var tss = SpreadsheetApp.openById('BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB');
  var ts = tss.getSheetByName('Gerais');      
  ts.getRange(268, 1).setValue(data);
}
user_112252910
Related