Google apps script select specific columns when copying to another sheet

Asked Feb 07 '22 at 16:56

Active Feb 07 '22 at 17:31

Viewed 1,434 times

I'm new to google scripts and I'm trying to copy specific range of columns to another sheet. This is the code

function helpFunction() {
  
 const sss = SpreadsheetApp.getActiveSpreadsheet();
  const ts = sss.getSheetByName('this');
  const ss = sss.getSheetByName('source');

  const rawData = ss.getRange("A:F").getValues(); // HERE - i just need columns B,C,E,F instead of all from a to f

  const frawData=rawData.filter(row=>row[0]>0);
  ts.getRange(ts.getLastRow()+1, 1, frawData.length, frawData[0].length).setValues(frawData);

}

If there's someone who could help me I will be more than glad.

asked Feb 07 '22 at 16:56

Nicola

You mean like this: `const rawData = ss.getRange("B:F").getValues();`? – Dmitry Kostyuk Feb 07 '22 at 17:00
kind of, except the D column – Nicola Feb 07 '22 at 17:01
4

Then just filter it out like so `const rawData = ss.getRange("B:F").getValues().map(row => [ row[0], row[1], row[3], row[4] ]);` – Dmitry Kostyuk Feb 07 '22 at 17:03
Let me know if this gets the job done :) – Dmitry Kostyuk Feb 07 '22 at 17:07
exactly like this ! thank you a lot. – Nicola Feb 07 '22 at 17:16

Google apps script select specific columns when copying to another sheet

0 Answers0