{"id":1187,"date":"2011-10-28T19:46:29","date_gmt":"2011-10-28T10:46:29","guid":{"rendered":"http:\/\/okosama.org\/okusama\/blog\/?p=1187"},"modified":"2011-10-28T19:49:22","modified_gmt":"2011-10-28T10:49:22","slug":"applescript-%e3%81%ae%e5%a4%89%e6%95%b0","status":"publish","type":"post","link":"https:\/\/okosama.org\/okusama\/2011\/10\/28\/applescript-%e3%81%ae%e5%a4%89%e6%95%b0\/","title":{"rendered":"AppleScript \u306e\u5909\u6570"},"content":{"rendered":"<p>\u4ed5\u4e8b\u3067AppleScript\u3068Excel\u306e\u9023\u643a\u306b\u6311\u6226\u4e2d\u3002<\/p>\n<p>\u305d\u306e\u4e2d\u3067\u5099\u5fd8\u9332\u3068\u3057\u3066\u30e1\u30e2\u3057\u305f\u3082\u306e\u3092\u66f8\u304d\u7559\u3081\u307e\u3059\u3002<\/p>\n<p>&nbsp;<\/p>\n<p>\u4eca\u56de\u306f\u300c\u5909\u6570\u300d\u306b\u3064\u3044\u3066\u3002<\/p>\n<p>\u3059\u3063\u3054\u304f\u57fa\u672c\u7684\u306a\u3053\u3068\u306a\u306e\u3060\u3051\u3069\u3001\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u8a00\u8a9e\u304c\u5909\u308f\u308c\u3070\u30eb\u30fc\u30eb\u304c\u5909\u308f\u308a\u307e\u3059\u304b\u3089\u3002<\/p>\n<p>&nbsp;<\/p>\n<p><!--more--><\/p>\n<p>\u25a0\u5909\u6570\u306b\u3064\u3044\u3066<\/p>\n<ul>\n<li><span style=\"color: #ff6600;\"><strong>\u5927\u6587\u5b57\u3068\u5c0f\u6587\u5b57\u3092\u533a\u5225\u3057\u306a\u3044\u3002<\/strong><\/span><br \/>\napple\u3001Apple\u3001APPLE \u306f\u3059\u3079\u3066\u540c\u3058\u3002\u3088\u304f\u3001\u300cMyFile\u300d\u3068\u304b\u5909\u6570\u3067\u4f7f\u7528\u3059\u308b\u3051\u308c\u3069\u3001\u300cmyfile\u300d\u300cMYFILE\u300d\u3068\u66f8\u3044\u3066\u3082\u3044\u3044\u3068\u3044\u3046\u3053\u3068\u3002\u3086\u308b\u30fc\u3044\u611f\u3058\u3002<br \/>\n\u3051\u308c\u3069\u3001\u30b3\u30f3\u30d1\u30a4\u30eb\u3057\u3066\u3082\u3001\u5909\u6570\u306f\u5927\u6587\u5b57\u304c\u5c0f\u6587\u5b57\u306b\u3001\u5c0f\u6587\u5b57\u304c\u5927\u6587\u5b57\u306b\u306a\u308b\u3053\u3068\u306f\u306a\u304f\u3066\u3001\u540c\u3058\u307e\u307e\u3002<\/p>\n<\/li>\n<li><strong><span style=\"color: #ff6600;\">\u4f7f\u3048\u308b\u6587\u5b57\u306f\u300c\u30a2\u30eb\u30d5\u30a1\u30d9\u30c3\u30c8\u300d\u300c\u6570\u5b57\u300d\u300c_\uff08\u30a2\u30f3\u30c0\u30fc\u30b9\u30b3\u30a2\uff09\u300d\u3002<\/span><\/strong><br \/>\n\u307e\u3001\u3053\u308c\u306f\u3069\u306e\u8a00\u8a9e\u3067\u3082\u4f3c\u305f\u3088\u3046\u306a\u611f\u3058\u3067\u3057\u3087\u3046\u304b\u3002<\/li>\n<\/ul>\n<p>\u3053\u3093\u306a\u611f\u3058\u3067\u3001\u3061\u3087\u3063\u3068\u30c8\u30e9\u30a4\u3057\u3066\u307f\u307e\u3057\u305f\u3002<\/p>\n<pre lang=\"AppleScript\" line=\"1\" colla=\"+\">tell application \"Finder\"\r\n\tset FolderPath to (choose folder with prompt \"\u30d5\u30a9\u30eb\u30c0\u3092\u9078\u629e\")\r\n\tset NameList to (list folder FolderPath)\r\n\r\n\topen application \"Microsoft Excel\"\r\n\ttell application \"Microsoft Excel\"\r\n\t\tset n to count NameList\r\n\t\trepeat with i from 1 to n\r\n\t\t\tset value of cell 1 of row i of sheet \"sheet1\" to item i of NameList\r\n\t\tend repeat\r\n\tend tell\r\n\r\nend tell<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u4ed5\u4e8b\u3067AppleScript\u3068Excel\u306e\u9023\u643a\u306b\u6311\u6226\u4e2d\u3002 \u305d\u306e\u4e2d\u3067\u5099\u5fd8\u9332\u3068\u3057\u3066\u30e1\u30e2\u3057\u305f\u3082\u306e\u3092\u66f8\u304d\u7559\u3081\u307e\u3059\u3002 &nbsp; \u4eca\u56de\u306f\u300c\u5909\u6570\u300d\u306b\u3064\u3044\u3066\u3002 \u3059\u3063\u3054\u304f\u57fa\u672c\u7684\u306a\u3053\u3068\u306a\u306e\u3060\u3051\u3069\u3001\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u8a00\u8a9e\u304c\u5909\u308f\u308c\u3070\u30eb\u30fc\u30eb\u304c\u5909\u308f &hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[21,30],"tags":[34],"class_list":["post-1187","post","type-post","status-publish","format-standard","hentry","category-mac","category-it","tag-applescript"],"_links":{"self":[{"href":"https:\/\/okosama.org\/okusama\/wp-json\/wp\/v2\/posts\/1187","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/okosama.org\/okusama\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/okosama.org\/okusama\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/okosama.org\/okusama\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/okosama.org\/okusama\/wp-json\/wp\/v2\/comments?post=1187"}],"version-history":[{"count":4,"href":"https:\/\/okosama.org\/okusama\/wp-json\/wp\/v2\/posts\/1187\/revisions"}],"predecessor-version":[{"id":1191,"href":"https:\/\/okosama.org\/okusama\/wp-json\/wp\/v2\/posts\/1187\/revisions\/1191"}],"wp:attachment":[{"href":"https:\/\/okosama.org\/okusama\/wp-json\/wp\/v2\/media?parent=1187"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/okosama.org\/okusama\/wp-json\/wp\/v2\/categories?post=1187"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/okosama.org\/okusama\/wp-json\/wp\/v2\/tags?post=1187"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}