{"blog_url":"https://potisan-programming-memo.hatenablog.jp/","type":"rich","categories":["R"],"published":"2021-02-14 14:27:15","title":"R openxlsx\u3067xlsx\u30d5\u30a1\u30a4\u30eb\u306e\u540d\u524d\u4ed8\u304d\u7bc4\u56f2\uff08\u30c6\u30fc\u30d6\u30eb\uff09\u3092\u8aad\u307f\u8fbc\u3080","description":"Microsoft Excel\u3084LibreOffice Calc\u3067\u4f7f\u7528\u3055\u308c\u308bxlsx\u30d5\u30a1\u30a4\u30eb\u306e\u540d\u524d\u4ed8\u304d\u7bc4\u56f2\uff08Excel\u3067\u306f\u30c6\u30fc\u30d6\u30eb\u542b\u3080\uff09\u306fopenxlsx\u306eread.xlsx\u95a2\u6570\u3067\u8aad\u307f\u8fbc\u3081\u307e\u3059\u3002 \u30d5\u30a1\u30a4\u30eb\u540dtest.xlsx\u306e\u540d\u524d\u4ed8\u304d\u7bc4\u56f2\u3042\u308b\u3044\u306f\u30c6\u30fc\u30d6\u30ebTable1\u306f\u6b21\u306e\u30b3\u30fc\u30c9\u3067\u8aad\u307f\u8fbc\u3081\u307e\u3059\u3002\u7d50\u679c\u306f\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u3067\u3059\u3002 #install.packages(\"openxlsx\") require(openxlsx) x <- read.xlsx(\"test.xlsx\", namedRegion=\"Table1\") read.xlsx\u304c\u91cd\u8907\u3059\u308b\u5834\u5408\u7b49\u306f\u540d\u524d\u7a7a\u9593\u3092\u660e\u793a\u3067\u304d\u307e\u3059\u3002 x <- openx\u2026","blog_title":"potisan\u306e\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u30e1\u30e2","author_name":"potisan","height":"190","width":"100%","version":"1.0","url":"https://potisan-programming-memo.hatenablog.jp/entry/2021/02/14/142715","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fpotisan-programming-memo.hatenablog.jp%2Fentry%2F2021%2F02%2F14%2F142715\" title=\"R openxlsx\u3067xlsx\u30d5\u30a1\u30a4\u30eb\u306e\u540d\u524d\u4ed8\u304d\u7bc4\u56f2\uff08\u30c6\u30fc\u30d6\u30eb\uff09\u3092\u8aad\u307f\u8fbc\u3080 - potisan\u306e\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u30e1\u30e2\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","provider_url":"https://hatena.blog","provider_name":"Hatena Blog","author_url":"https://blog.hatena.ne.jp/potisan/","image_url":null}