Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function main(){
- const target = 'ID:';
- const before = 3;
- const after = 1;
- append(target, before, after);
- }
- function append(target, before, after){
- const sheet = SpreadsheetApp.getActiveSheet();
- const data = sheet.getDataRange().getValues();
- const idxs = data
- .map(function(r, i){ return [r, i]; })
- .filter(function(rr){ return rr[0][0].indexOf(target) != -1; })
- .map(function(rr){ return rr[1]; });
- // 行追加するとずれるので必ず後ろから処理する
- const rs = [].concat(idxs).reverse();
- rs.forEach(function(i){
- const no = i + 1; // 0オリジンなインデックスから1オリジンな行番号に
- sheet.insertRows(no + 1, after);
- sheet.insertRows(no, before);
- });
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement