问脚本-复制4:8行并粘贴到工作表的最后一行

EN

function copyrows() {
  const ss = SpreadsheetApp.getActive();
  const sh = ss.getActiveSheet();
  const rg = sh.getRange("4:8");//select line 4 through 8
  const drg = sh.getRange(sh.getLastRow() + 2 , 1);//Select destination range. You only have to specify the upper left corner of the range
  rg.copyTo(drg);
}

function copyrows() {
  const ss = SpreadsheetApp.getActive();
  const sh = ss.getActiveSheet();
  const rg = sh.getRange("4:8");//select line 4 through 8
  let hA = [...Array.from(new Array(rg.getHeight()).keys(),x => sh.getRowHeight(x + 4))]
  let lr = sh.getLastRow();
  const drg = sh.getRange(lr + 2 , 1);//Select destination range. You only have to specify the upper left corner of the range
  rg.copyTo(drg);
  hA.forEach((h,i) => sh.setRowHeight(lr + 1 + i, h ));
}

function copyrow_4_8(){
        const ss = SpreadsheetApp.getActive().getActiveSheet();
        //replace the columns number with your acutal needed columns 
        const range = ss.getRange(4,1,5,4);
        const range_value = range.getValues();
        const dest_range = ss.getRange(ss.getLastRow()+1,1,range_value.length,range_value[0].length);
        //get grid id for the dest range
        const dest_range_Gid = dest_range.getGridId();
        //copy format to the dest range
        range.copyFormatToRange(dest_range_Gid,1,4,ss.getLastRow()+1,ss.getLastRow()+range_value.length+1);
        //set the values to dest range.
        dest_range.setValues(range_value);
    }