[Docs]스프레드시트

Extending Google Sheets

by Progress posted Feb 10, 2015
?

단축키

Prev이전 문서

Next다음 문서

ESC닫기

크게 작게 위로 아래로 댓글로 가기 인쇄


Extending Google Sheets


출처 : https://developers.google.com/apps-script/guides/sheets


Writing data

To store data, such as a new product name and number to the spreadsheet, add the following code to the end of the script.

function addProduct() {
 
var sheet = SpreadsheetApp.getActiveSheet();
  sheet
.appendRow(['Cotton Sweatshirt XL', 'css004']);
}

The above code appends a new row at the bottom of the spreadsheet, with the values specified. If you run this function, you'll see a new row added to the spreadsheet.




Articles