Spreadsheet?f?[?^?̑I???A?}???A?폜?A?R?s?[?A?ړ??A?\?[?g????????Ƃ??????????̃R?c?FExcel VBA?v???O???}?[?̂??߂?Google Apps Script????i7?j?i1/3 ?y?[?W?j

?@?{?A?ځuExcel VBA?v???O???}?[?̂??߂?Google Apps Script?????v?ł́AGoogle???񋟂???uGoogle Apps Script?v?iGAS?j?̃v???O???~???O?ŁA?uGoogle Apps?v?𑀍삷????@???uGoogle Sheets?v?i?X?v???b?h?V?[?g?j?𒆐S?ɉ?????Ă????B

?@?????GAS?̃f?[?^?????????C???ɉ?????Ă????B?f?[?^??}????????A?폜??????A?\?[?g??????A?f?[?^??ʂȃZ???ɃR?s?[??????A?ړ??????肷?鏈???????????B?????̏????́A????̋Ɩ??ɂ????ẮA??ɕK?v?Ƃ???A????ōs???Ă????ƂȂ̂ŁA?????ɖ𗧂‚??낤?B

?@?܂??A??ʂ̃f?[?^???????ƂȂ?ƁA?R?[?h?̎??s???x???Ȃ??Ă??܂????????B????????????邿????Ƃ????R?c???Љ??B

?@????́A?}1?̂悤?Ƀf?[?^????͂????V?[?g???g???B

?}1?@?u?????v?u?Z???v?u?d?b?ԍ??v?u???ʁv?????͂??ꂽ?f?[?^

?@?܂??A?u?c?[???v???u?X?N???v?g?G?f?B?^?v?ƑI?????āA?X?N???v?g?G?f?B?^???J???Ă??????B?u?R?[?h.gs?v?t?@?C???̓??e???\??????Ă???B???́u?R?[?h.gs?v???ɁA?ȍ~?̃R?[?h???????Ď??s???Ă????B

?Z???͈͂?I??????setActiveRange???\?b?h

?@?܂??́A?Z???͈͂?I????????@?ɂ‚??Č??Ă??????B???X?g1?̃R?[?h???g???B

function mySetActiveRangeFunction() {
  var sheet=SpreadsheetApp.getActiveSheet();
  var selectRange=sheet.getRange("A3:D10");
  SpreadsheetApp.setActiveRange(selectRange);
}

?@getRange???\?b?h?ŁA?I??????͈͂??w?肵?āA?ϐ?selectRange?Ɋi?[????i3?s?ځj?B?I???????͈͂??A?usetActiveRange?v???\?b?h?ŃA?N?e?B?u?ɂ???i4?s?ځj?B

?@????ŁA?w?肵???͈͂??I???ł???B???s????Ɛ}2?̂悤?ɂȂ?B

?}2?@?C?ӂ̃Z????I??????

?@Excel VBA?ł́A???܂??܂ȕ??@?Ŕ͈͂??w?肵??Select???\?b?h???g?????ƂŁu?I???v???ł???B

?f?[?^?̑}??

?@???́A?f?[?^?̑}???ɂ‚??Ă??B???L?̃??\?b?h?̂????ꂩ???g???A??̍s????𑝂₵????A???₵?????ɒl????͂???B

?@?Ȃ??A?uinsertRows?v?uinsertColumns?v?Ło???₷?s???p??o???₷?񐔁p???ȗ?????ƁA1?‚????????邱?ƂɂȂ?B

?@?????ł́AinsertRowAfter?????X?g2?̃R?[?h?̂悤?Ɏg?????Ƃɂ???B

function myInsertRowFunction() {
  var sheet=SpreadsheetApp.getActiveSheet();
  sheet.insertRowAfter(5);
  sheet.getRange(6,1).setValue("???B?ˑ?");
  sheet.getRange(6,2).setValue("???Q?????R?s?ɗ\?S?u????");
  sheet.getRange(6,3).setValue("089-956-1234");
  sheet.getRange(6,4).setValue("?j??");
}

?@insertRowAfter???\?b?h??5?s?ڂ̌??A?‚܂?6?s?ڂɃf?[?^??}?????邱?Ƃ?錾????i3?s?ځj?BgetRange?ŁA?l????͂???u?s?v?Ɓu??v???w?肵?āAsetValue???\?b?h??6?s?ڂ?1?`4??ڂɂ??ꂼ??u?????v?u?Z???v?u?d?b?ԍ??v?u???ʁv????͂???i4?`7?s?ځj?B

?@?}1?ɑ΂??āA???X?g2?????s???????ʂ͐}3?̂悤?ɂȂ?B

?}3?@?C?ӂ̍s?Ƀf?[?^??}??????

?f?[?^??z??ɂ??āAsetValues???\?b?h?ň?C?ɓ??͂??邱?Ƃō?????

?@?Ȃ??A???X?g3?̂悤??values?Ƃ????z??ɒl???Z?b?g???Ă????AgetRange??6?s?ڂ?1?`4??ڂ???C?Ɏw?肵?āAsetValues???\?b?h???g???z??Ńf?[?^????͂??邱?Ƃ??”\???B

?@???̂悤?ɁA?Ăяo?????\?b?h?̐??????炷???ƂŁA?R?[?h?̍s???????炵?A???s???x???グ?邱?Ƃ??ł???B??{?I?Ƀ??[?J??PC?Ŏg??VBA?ɔ?ׂāAGAS?ł͓??ɒʐM?ʂ⑬?x?A?񐔂????????x?ɉe??????̂ŁA???s???郁?\?b?h?̐??????炷???Ƃ??d?v???B

function myFunction() {
  var sheet=SpreadsheetApp.getActiveSheet();
  var values = [
   [ "???B?ˑ?","???Q?????R?s?ɗ\?S?u????","089-956-1234","?j??" ]
  ];
  sheet.insertRowAfter(5);
  sheet.getRange(6,1,1,4).setValues(values);
}

Excel VBA?Ƃ̈Ⴂ

?@?f?[?^?̑}???́AExcel VBA?ɂ????Ă?Insert???\?b?h???g???B

?@?}??????????́AVBA?ł͈????Ŏw?肷?邪?AGAS???ƃ??\?b?h???Ŏw?肷??Ƃ????Ⴂ??????B

?@?܂?VBA?ł́ARange?^Rows?^Columns?I?u?W?F?N?g?ŕ????s?^??͈̔͂??w?肷?邱?ƂŁA?}??????ʒu?ƍs?^?񐔂????܂邪?AGAS?ł̓??\?b?h?̈????ő}??????ʒu?ƍs?^?񐔂????܂?Ƃ????Ⴂ??????B

?@?????VBA?ł́A?????i?????ł́A?Z???̐F??t?H???g?ȂǕ\???`???j???R?s?[???邱?Ƃ??A?uCopyOrigin?v?Ƃ????????ōs???Ă??܂??BGAS?ŏ??????R?s?[????ɂ́A?A?ڑ?3??ŏЉ???悤?ȃ??\?b?h?ŁA???????w?肷??R?[?h??ʓr?lj?????K?v?????邾?낤?B

?@?g?????͓??????????Ȃ????AVBA?̕?????肫?ߍׂ??????????s????B