{"id":1165,"date":"2016-02-24T17:55:44","date_gmt":"2016-02-24T09:55:44","guid":{"rendered":"http:\/\/potterdreams.com\/clay\/?page_id=1165"},"modified":"2016-02-24T17:55:44","modified_gmt":"2016-02-24T09:55:44","slug":"how-to-write-to-a-column-cell","status":"publish","type":"page","link":"https:\/\/potterdreams.com\/clay\/interest\/programmings\/google-script\/how-to-write-to-a-column-cell\/","title":{"rendered":"How to Write to A Cell of Last Row"},"content":{"rendered":"<pre><code>function fillCols() {\n   \n var lastRow = SpreadsheetApp.getActiveSpreadsheet().getLastRow(); \n SpreadsheetApp.getActiveSheet().getRange('V'+lastRow).setValue('English');\n}<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>function fillCols() { var lastRow = SpreadsheetApp.getActiveSpreadsheet().getLastRow(); SpreadsheetApp.getActiveSheet().getRange(&#8216;V&#8217;+lastRow).setValue(&#8216;English&#8217;); }<\/p>\n","protected":false},"author":3,"featured_media":0,"parent":1161,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"class_list":["post-1165","page","type-page","status-publish","hentry"],"jetpack-related-posts":[],"jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/potterdreams.com\/clay\/wp-json\/wp\/v2\/pages\/1165","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/potterdreams.com\/clay\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/potterdreams.com\/clay\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/potterdreams.com\/clay\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/potterdreams.com\/clay\/wp-json\/wp\/v2\/comments?post=1165"}],"version-history":[{"count":0,"href":"https:\/\/potterdreams.com\/clay\/wp-json\/wp\/v2\/pages\/1165\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/potterdreams.com\/clay\/wp-json\/wp\/v2\/pages\/1161"}],"wp:attachment":[{"href":"https:\/\/potterdreams.com\/clay\/wp-json\/wp\/v2\/media?parent=1165"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}