{"id":3981,"date":"2024-03-30T22:27:51","date_gmt":"2024-03-30T13:27:51","guid":{"rendered":"https:\/\/1bed.allright.life\/?page_id=3981"},"modified":"2024-03-31T00:04:02","modified_gmt":"2024-03-30T15:04:02","slug":"page-3981","status":"publish","type":"page","link":"https:\/\/1bed.allright.life\/?page_id=3981","title":{"rendered":"Office Script \u30e1\u30e2"},"content":{"rendered":"<h2>Excel \u306e\u30c6\u30fc\u30d6\u30eb\u3092\u7a7a\u306b\u3059\u308b<\/h2>\n<pre><code class=\"language-typescript\">function main(workbook: ExcelScript.Workbook) {\n  \/\/ \u30c7\u30fc\u30bf\u7528\u30c6\u30fc\u30d6\u30eb\u3092\u53d6\u5f97\n  let table = workbook.getWorksheet(&quot;&lt;\u30b7\u30fc\u30c8\u540d&gt;&quot;).getTable(&quot;&lt;\u30c6\u30fc\u30d6\u30eb\u540d&gt;&quot;);\n\n  \/\/ \u30c6\u30fc\u30d6\u30eb\u306e\u30c7\u30fc\u30bf\u90e8\u3092\u53d6\u5f97\n  let range = table.getRangeBetweenHeaderAndTotal();\n\n  \/\/ \u30c7\u30fc\u30bf\u90e8\u306b\u30c7\u30fc\u30bf\u304c\u3042\u308b\u3068\u304d\u306b\u30af\u30ea\u30a2\u3059\u308b\n  if (range.getUsedRange()) {\n    range.delete(ExcelScript.DeleteShiftDirection.up);\n  }\n}<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Excel \u306e\u30c6\u30fc\u30d6\u30eb\u3092\u7a7a\u306b\u3059\u308b function main(workbook: ExcelScript.Workbook) { \/\/ \u30c7\u30fc\u30bf\u7528\u30c6\u30fc\u30d6\u30eb\u3092\u53d6\u5f97 let table = workbook.getWorksh [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-3981","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/1bed.allright.life\/index.php?rest_route=\/wp\/v2\/pages\/3981","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/1bed.allright.life\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/1bed.allright.life\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/1bed.allright.life\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/1bed.allright.life\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3981"}],"version-history":[{"count":2,"href":"https:\/\/1bed.allright.life\/index.php?rest_route=\/wp\/v2\/pages\/3981\/revisions"}],"predecessor-version":[{"id":3983,"href":"https:\/\/1bed.allright.life\/index.php?rest_route=\/wp\/v2\/pages\/3981\/revisions\/3983"}],"wp:attachment":[{"href":"https:\/\/1bed.allright.life\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3981"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}