Advertisement
Guest User

Untitled

a guest
Jul 21st, 2019
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.72 KB | None | 0 0
  1. function main(){
  2. const target = 'ID:';
  3. const before = 3;
  4. const after = 1;
  5. append(target, before, after);
  6. }
  7.  
  8. function append(target, before, after){
  9. const sheet = SpreadsheetApp.getActiveSheet();
  10. const data = sheet.getDataRange().getValues();
  11. const idxs = data
  12. .map(function(r, i){ return [r, i]; })
  13. .filter(function(rr){ return rr[0][0].indexOf(target) != -1; })
  14. .map(function(rr){ return rr[1]; });
  15. // 行追加するとずれるので必ず後ろから処理する
  16. const rs = [].concat(idxs).reverse();
  17. rs.forEach(function(i){
  18. const no = i + 1; // 0オリジンなインデックスから1オリジンな行番号に
  19. sheet.insertRows(no + 1, after);
  20. sheet.insertRows(no, before);
  21. });
  22. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement