google sheet-appscript-vba-1分K整理

/** @OnlyCurrentDoc */ function myFunction() {   var spreadsheet = SpreadsheetApp.getActive();   spreadsheet.getRange('F:G').activate();   spreadsheet.getActiveSheet().deleteColumns(spreadsheet.getActiveRange().getColumn(), spreadsheet.getActiveRange().getNumColumns());   spreadsheet.getRange('G:P').activate();   spreadsheet.setCurrentCell(spreadsheet.getRange('I1'));   spreadsheet.getActiveSheet().deleteColumns(spreadsheet.getActiveRange().getColumn(), spreadsheet.getActiveRange().getNumColumns());   spreadsheet.getRange('A1').activate();   spreadsheet.getCurrentCell().setValue('date');   spreadsheet.getRange('B1').activate();   spreadsheet.getCurrentCell().setValue('open');   spreadsheet.getRange('C1').activate();   spreadsheet.getCurrentCell().setValue('high');   spreadsheet.getRange('D1').activate();   spreadsheet.getCurrentCell().setValue('low');   spreadsheet.getRange('E1').activate();   spreadsheet.getCurrentCell().setValue('close');   spreadsheet.getRange('F1').activate();   spreadsheet.getCurrentCell().setValue('volume');   spreadsheet.getRange('F2').activate(); };