{"id":53687,"date":"2024-06-16T13:06:03","date_gmt":"2024-06-16T05:06:03","guid":{"rendered":"http:\/\/www.biocloudservice.com\/wordpress\/?p=53687"},"modified":"2024-06-16T13:06:03","modified_gmt":"2024-06-16T05:06:03","slug":"%e4%b8%80%e9%81%8d%e5%b0%b1%e4%bc%9a%e5%b8%88%e5%a6%b9%e6%95%99%e4%bd%a0%e7%94%a8r%e5%a4%84%e7%90%86excel%e6%96%87%e4%bb%b6%e4%b8%ad%e7%9a%84%e7%94%9f%e4%bf%a1%e6%95%b0%e6%8d%ae","status":"publish","type":"post","link":"http:\/\/www.biocloudservice.com\/wordpress\/?p=53687","title":{"rendered":"\u4e00\u904d\u5c31\u4f1a\u5e08\u59b9\u6559\u4f60\u7528R\u5904\u7406Excel\u6587\u4ef6\u4e2d\u7684\u751f\u4fe1\u6570\u636e"},"content":{"rendered":"


\n
\n<\/title><br \/>\n<meta charset=\"utf-8\"><br \/>\n<meta name=\"viewport\" content=\"width=device-width,initial-scale=1.0,maximum-scale=1.0,user-scalable=0,viewport-fit=cover\"><\/p>\n<style>\n*{margin:0;padding:0}html{-ms-text-size-adjust:100%;-webkit-text-size-adjust:100%;line-height:1.6}img{z-index:999;position:relative;max-width:100%;margin:10px 0;}body{letter-spacing:.034em}h1,h2,h3,h4,h5,h6{font-weight:400;font-size:16px}a{color:#576b95;text-decoration:none;-webkit-tap-highlight-color:rgba(0,0,0,0)}td,th{word-wrap:break-word;padding:5px 10px;border:1px solid #DDD;}table{margin-bottom:10px;border-collapse:collapse;display:table;width:100%!important;}.appmsg_skin_default .rich_media_area_primary{background-color:#fff}.appmsg_skin_default .rich_media_area_primary .weui-loadmore_line .weui-loadmore__tips{background-color:#fff}.rich_media_area_primary{padding:20px 16px 12px;background-color:#fafafa}@media (max-width:375px){.rich_media_area_primary{padding:20px 60px 15px 60px}.rich_media_area_extra{padding:0 60px 21px 60px}}@media (min-width:1024px){.rich_media_area_primary_inner,.rich_media_area_extra_inner,body{max-width:677px;margin-left:auto;margin-right:auto}.rich_media_area_primary{padding-top:32px}}.rich_media{padding:20px;overflow:hidden;}.appmsg_skin_default .rich_media_area_primary{background-color:#fff}.appmsg_skin_default .rich_media_area_primary .weui-loadmore_line .weui-loadmore__tips{background-color:#fff}@media screen and (min-width:1024px){.rich_media_area_primary_inner,.rich_media_area_extra_inner{max-width:677px;margin-left:auto;margin-right:auto}.rich_media_area_primary{padding-top:32px}}.rich_media_content{overflow:hidden;color:#333;font-size:17px;word-wrap:break-word;-webkit-hyphens:auto;-ms-hyphens:auto;hyphens:auto;text-align:justify;position:relative;z-index:0}.rich_media_content *{max-width:100%!important;box-sizing:border-box!important;-webkit-box-sizing:border-box!important;word-wrap:break-word!important}.rich_media_content p{clear:both;min-height:1em}.rich_media_content em{font-style:italic}.rich_media_content fieldset{min-width:0}.rich_media_content .list-paddingleft-1,.rich_media_content .list-paddingleft-2,.rich_media_content .list-paddingleft-3{padding-left:2.2em}.rich_media_content .list-paddingleft-1 .list-paddingleft-2,.rich_media_content .list-paddingleft-2 .list-paddingleft-2,.rich_media_content .list-paddingleft-3 .list-paddingleft-2{padding-left:30px}.rich_media_content .list-paddingleft-1{padding-left:1.2em}.rich_media_content .list-paddingleft-3{padding-left:3.2em}.rich_media_content .code-snippet,.rich_media_content .code-snippet__fix{max-width:1000%!important}.rich_media_content .code-snippet *,.rich_media_content .code-snippet__fix *{max-width:1000%!important}.rich_media_title{font-size:22px;line-height:1.4;margin-bottom:13px;padding-bottom:13px;border-bottom:1px solid #e7e7eb;}@supports(-webkit-overflow-scrolling:touch){.rich_media_title{font-weight:700}}.rich_media_meta{display:inline-block;vertical-align:middle;padding:0 0 10px 0;font-size:15px;-webkit-tap-highlight-color:rgba(0,0,0,0)}.rich_media_meta.icon_appmsg_tag{margin-right:0px}.rich_media_meta.meta_tag_text{margin-right:0}.rich_media_meta_list em{font-style:normal}.rich_media_meta_text{color:#a5a5a5;}p{margin:0;}.msgBox{margin-top:20px;padding-top:20px;padding-left:50px;overflow:hidden;border-top:2px dashed #09a2ff;}.msg{padding-top:7px;clear:both;}.msgBody{float:right;width:100%;margin-left:55px;padding-bottom:15px;border-bottom:1px dashed #e0e0e0;}.userHeadImg{float:left;margin-left:-50px;}.userHeadImg img{width:40px;height:40px;margin-right:10px;border-radius:3px;}.userName{color:#888888;line-height:24px;font-size:14px;margin:5px 0 5px 0;height:24px;}.replyBody,.autherBody{color:#565656;font-size:15px;}.replyIcon{border-left:4px solid #33ab01;margin-right:5px;}.ad{text-decoration:none;color:#d6d4d4;font-size:12px;}.msgBodyReply{padding-top:5px;}.userName span{float:right;color:#afafaf;font-size:14px;}code{text-align:left;font-size:14px;display:block;white-space:pre;display:-webkit-box;display:-webkit-flex;display:flex;position:relative;}.code-snippet__fix{font-size:14px;margin:10px 0;display:block;color:#333;position:relative;background-color:rgba(0,0,0,0.03);border:1px solid #f0f0f0;border-radius:2px;display:-webkit-box;display:-webkit-flex;display:flex;padding-left:25px;line-height:26px}.code-snippet__fix code{text-align:left;font-size:14px;display:block;white-space:pre;display:-webkit-box;display:-webkit-flex;display:flex;position:relative;font-family:Consolas,\"Liberation Mono\",Menlo,Courier,monospace}.code-snippet__comment,.code-snippet__quote{color:#afafaf;font-style:italic}.code-snippet__keyword,.code-snippet__selector-tag,.code-snippet__subst{color:#ca7d37}.code-snippet__number,.code-snippet__literal,.code-snippet__variable,.code-snippet__template-variable,.code-snippet__tag .code-snippet__attr{color:#0e9ce5}.code-snippet__string,.code-snippet__doctag{color:#d14}.code-snippet__title,.code-snippet__section,.code-snippet__selector-id{color:#d14}.code-snippet__subst{font-weight:normal}.code-snippet__type,.code-snippet__class .code-snippet__title{color:#0e9ce5}.code-snippet__tag,.code-snippet__name,.code-snippet__attribute{color:#0e9ce5;font-weight:normal}.code-snippet__regexp,.code-snippet__link{color:#ca7d37}.code-snippet__symbol,.code-snippet__bullet{color:#d14}.code-snippet__built_in,.code-snippet__builtin-name{color:#ca7d37}.code-snippet__meta{color:#afafaf}.code-snippet__deletion{background:#fdd}.code-snippet__addition{background:#dfd}.code-snippet__emphasis{font-style:italic}.code-snippet__strong{font-weight:bold}.account_avatar{width:40px;height:40px;padding:0;}.account_info{display:-webkit-box;display:-webkit-flex;display:flex;-webkit-box-align:center;-webkit-align-items:center;padding:20px 0;align-items:center}.flex_bd{padding-left:14px;}.account_nickname{display:inline-block;vertical-align:middle;line-height:1.2;color:#576b95;font-size:14px}.account_desc{overflow:hidden;text-overflow:ellipsis;display:-webkit-box;-webkit-box-orient:vertical;-webkit-line-clamp:1;color:rgba(0,0,0,0.3);font-size:14px;line-height:1.2;padding-top:.4em}.msg_source_url{text-align:left;word-break:break-all;margin-top:20px;}.msg_source_url a{padding-right:10px;}.msg_source_url .url_text{color:#a8a8a8;}.video-desc{font-size:14px;margin-top:15px;color:#6c6c6c;}.msg_source_url{text-align:left;}.original_primary_card_tips{color:rgba(0,0,0,0.3);line-height:1.4;font-size:15px;}.weui-flex__item{margin-bottom:20px;padding:20px 16px;margin-top:16px;line-height:1.4;align-items:center;background-color:#f7f7f7;border-radius:8px;position:relative;}.original_primary_desc{color:rgba(0,0,0,0.5);font-size:14px;padding-top:4px;width:auto;overflow:hidden;text-overflow:ellipsis;}.msgBodyReplyList{border-top:1px solid #e1e1e1;margin-top:10px;}.msgBodyReplyListTop{border-top:0;}.reply_like_num{float:right;font-size:14px;color:#c7c7c7;}.msgData{margin-top:20px;color:#626262;}.msgData span{font-size:14px;padding-right:15px;}.msgData .likes{float:right;padding-right:0;}.js_text_content p{font-size:18px;}.rich_media_meta_link{font-size:15px;}blockquote {padding-left: 10px;border-left: 3px solid #dbdbdb;color: rgba(0,0,0,0.5);font-size: 15px;padding-top: 4px;margin: 1em 0;}.video_iframe{width:500px;height:400px;}.blockquote_info{color:#b5b5b5;margin-top:10px;}#copyright_logo{color:#bdbdbd;}.rich_media_meta_list{margin-bottom:10px;}.reprint{background:#efefef;border-radius:5px;padding:8px;color:#1f1f1f;}.reprint a{word-break:break-all;}.topic{color:#8e8e8e;background:#f7f7f7;border-radius:5px;padding:10px 8px;}.topic a{padding-right:5px;}.topic p{margin-bottom:5px;}\n<\/style>\n<link href=\"https:\/\/www.juyifx.cn\/config\/css\/wxArticle.css\" rel=\"stylesheet\"\/>\n<\/head><script>\nvar data={\"mp\":\"\u751f\u4fe1\u679c\",\"title\":\"\u4e00\u904d\u5c31\u4f1a\u5e08\u59b9\u6559\u4f60\u7528R\u5904\u7406Excel\u6587\u4ef6\u4e2d\u7684\u751f\u4fe1\u6570\u636e\",\"time\":\"2023-06-20 19:00:03\",\"timeStamp\":\"1687258803\"};\n<\/script><br \/>\n<body><\/p>\n<div class=\"rich_media\">\n<h1 class=\"rich_media_title\" id=\"activity-name\"><a href=\"http:\/\/mp.weixin.qq.com\/s?__biz=Mzg3OTg3MjQyNg==&mid=2247488610&idx=2&sn=bf91f3f513b9781e58cada77d1fb3042&chksm=cf7c84a7f80b0db1ae45c7a328acf37f7f2ec9083faa9a3c19708f835e1bbc7f664b138e277e#rd\" target=\"_blank\" rel=\"noopener\">\u4e00\u904d\u5c31\u4f1a\u5e08\u59b9\u6559\u4f60\u7528R\u5904\u7406Excel\u6587\u4ef6\u4e2d\u7684\u751f\u4fe1\u6570\u636e<\/a><\/h1>\n<div id=\"meta_content\" class=\"rich_media_meta_list\"><span class=\"rich_media_meta rich_media_meta_text\">\u5c0f\u5e08\u59b9  <\/span><span class=\"rich_media_meta rich_media_meta_nickname\" id=\"profileBt\"><a href=\"javascript:void(0);\" class=\"wx_tap_link js_wx_tap_highlight weui-wa-hotarea\" id=\"js_name\">\u751f\u4fe1\u679c  <\/a><\/span><em id=\"publish_time\" class=\"rich_media_meta rich_media_meta_text\">2023-06-20 19:00:03<\/em><\/div>\n<p><content><\/p>\n<div class=\"reprint\">\n<p>\u8f6c\u81ea\u516c\u4f17\u53f7\uff1aR\u8bed\u8a00\u5b66\u5f92<br \/><a href=\"http:\/\/mp.weixin.qq.com\/s?__biz=Mzg5MDk3Mzg4OA==&mid=2247483993&idx=1&sn=e6def91f5d644d4c28232ebc1ef64bec\" target=\"_blank\" title=\"\u9605\u8bfb\u539f\u6587\" rel=\"noopener\">http:\/\/mp.weixin.qq.com\/s?__biz=Mzg5MDk3Mzg4OA==&mid=2247483993&idx=1&sn=e6def91f5d644d4c28232ebc1ef64bec<\/a><\/p>\n<\/div>\n<section style=\"font-size: 16px;margin-bottom: 24px;\">\n<section style=\"text-align: left;justify-content: flex-start;display: flex;flex-flow: row nowrap;margin-top: 20px;margin-bottom: 25px;\" powered-by=\"xiumi.us\">\n<section style=\"display: inline-block;width: auto;vertical-align: top;align-self: flex-start;flex: 0 0 auto;min-width: 5%;height: auto;background-color: rgb(249, 172, 172);box-shadow: rgb(249, 172, 172) 0px 0px 5px 3px;\">\n<section style=\"text-align: center;transform: translate3d(2px, 0px, 0px);margin-top: -14px;margin-bottom: -14px;\" powered-by=\"xiumi.us\">\n<p>{ \u70b9\u51fb\u84dd\u5b57\uff0c\u5173\u6ce8\u6211\u4eec }<\/p>\n<\/section>\n<\/section>\n<\/section>\n<section powered-by=\"xiumi.us\">\n<p style=\"text-indent: 0em;text-wrap: wrap;\">\u5728\u6211\u4eec\u5f97\u5230\u7684\u751f\u4fe1\u6570\u636e\u4e2d\uff0c\u6709\u5f88\u591aMicrosoft Office Excel \u5de5\u4f5c\u8868\u7684\u683c\u5f0f\u3002\u6211\u4eec\u8be5\u5982\u4f55\u7528R\u5904\u7406\u4ed6\u4eec\u5462\uff0c\u636e\u5c0f\u5e08\u59b9\u4e86\u89e3R\u4e2d\u6709\u8bb8\u591a\u7528\u4e8e\u8bfb\u53d6 Excel \u6587\u4ef6\u7684\u5305\uff0c\u5982 gdata\uff0cxlsx\uff0c xlsReadWrite\uff0creadxl\u3002\u4eca\u5929\u5c0f\u5e08\u59b9\u7ed9\u5927\u5bb6\u7740\u91cd\u4ecb\u7ecd\u4e00\u4e0breadxl\u5305\u3002<\/p>\n<p style=\"text-indent: 0em;text-wrap: wrap;\">readxl\u5305\u662f\u4e00\u4e2aR\u8bed\u8a00\u4e2d\u7684\u6570\u636e\u8bfb\u53d6\u5305\uff0c\u53ef\u4ee5\u8bfb\u53d6Excel\u6587\u4ef6\u4e2d\u7684\u6570\u636e\u3002\u8be5\u5305\u53ef\u4ee5\u8bfb\u53d6.xlsx\u548c.xls\u683c\u5f0f\u7684\u6587\u4ef6\uff0c\u4f7f\u7528\u7b80\u5355\u65b9\u4fbf\uff0c\u4e0d\u9700\u8981\u5b89\u88c5Microsoft Excel\u6216\u5176\u4ed6\u8f6f\u4ef6\uff0c\u652f\u6301\u8bfb\u53d6.xlsx\u548c.xls\u683c\u5f0f\u7684\u6587\u4ef6\uff0c\u901f\u5ea6\u5feb\uff0c\u53ef\u4ee5\u5feb\u901f\u8bfb\u53d6\u5927\u578bExcel\u6587\u4ef6\uff0c\u652f\u6301\u8bfb\u53d6\u591a\u4e2a\u5de5\u4f5c\u8868\uff0c\u652f\u6301\u8bfb\u53d6\u65e5\u671f\u3001\u65f6\u95f4\u548c\u6570\u503c\u7b49\u591a\u79cd\u6570\u636e\u7c7b\u578b\uff0c\u4f7f\u7528readxl\u5305\u53ef\u4ee5\u65b9\u4fbf\u5730\u5c06Excel\u6587\u4ef6\u4e2d\u7684\u6570\u636e\u5bfc\u5165\u5230R\u8bed\u8a00\u4e2d\u8fdb\u884c\u5206\u6790\u548c\u5904\u7406\uff0c\u9002\u7528\u4e8e\u6570\u636e\u5206\u6790\u3001\u7edf\u8ba1\u5b66\u4e60\u7b49\u9886\u57df\u3002\u90a3\u4e48\u63a5\u4e0b\u6765\u5c31\u7531\u5c0f\u5e08\u59b9\u6765\u7ed9\u5927\u5bb6\u4ecb\u7ecd\u4e00\u4e0b\u8fd9\u4e2a\u795e\u5947\u7684R\u5305\u5427\u3002<\/p>\n<\/section>\n<section style=\"text-align: left;justify-content: flex-start;display: flex;flex-flow: row nowrap;margin-top: 10px;margin-bottom: 10px;\" powered-by=\"xiumi.us\">\n<section style=\"display: inline-block;vertical-align: top;width: auto;align-self: flex-start;flex: 0 0 auto;min-width: 5%;height: auto;\">\n<section style=\"justify-content: flex-start;display: flex;flex-flow: row nowrap;\" powered-by=\"xiumi.us\">\n<section style=\"display: inline-block;width: auto;vertical-align: top;align-self: flex-start;flex: 0 0 auto;background-color: rgb(189, 216, 245);min-width: 5%;height: auto;padding: 6px 15px;\">\n<section style=\"color: rgb(255, 255, 255);text-align: justify;\" powered-by=\"xiumi.us\">\n<p><strong>\u4e00<\/strong><\/p>\n<\/section>\n<\/section>\n<\/section>\n<section style=\"margin-bottom: -6px;transform: scale(0.66);transform-origin: left top;\" powered-by=\"xiumi.us\">\n<section style=\"line-height: 1;transform: translate3d(12px, 0px, 0px);\">\n<section style=\"width: 0px;display: inline-block;border-top: 0.6em solid rgb(247, 221, 223);border-left: 0.6em solid rgb(247, 221, 223);border-bottom: 0.6em solid transparent !important;border-right: 0.6em solid transparent !important;\"><svg viewbox=\"0 0 1 1\" style=\"float:left;line-height:0;width:0;vertical-align:top;\"><\/svg><\/section>\n<\/section>\n<\/section>\n<\/section>\n<section style=\"display: inline-block;vertical-align: top;width: auto;flex: 100 100 0%;height: auto;align-self: flex-start;background-color: rgb(255, 229, 231);padding: 6px 6px 6px 14px;\">\n<section style=\"text-align: justify;\" powered-by=\"xiumi.us\">\n<p><strong>\u5b89\u88c5\u548c\u8f7d\u5165<\/strong><\/p>\n<\/section>\n<\/section>\n<\/section>\n<section class=\"code-snippet__fix code-snippet__js\">\n<ul class=\"code-snippet__line-index code-snippet__js\">\n<li><\/li>\n<li><\/li>\n<\/ul>\n<pre class=\"code-snippet__js\" data-lang=\"r\"><code><span class=\"code-snippet_outer\">\u5b89\u88c5\uff1ainstall.packages(<span class=\"code-snippet__string\">\"readxl\"<\/span>)<\/span><\/code><code><span class=\"code-snippet_outer\">\u8f7d\u5165\uff1alibrary(readxl)<\/span><\/code><\/pre>\n<\/section>\n<p powered-by=\"xiumi.us\"><br \/><\/p>\n<section style=\"text-align: left;justify-content: flex-start;display: flex;flex-flow: row nowrap;margin-top: 10px;margin-bottom: 10px;\" powered-by=\"xiumi.us\">\n<section style=\"display: inline-block;vertical-align: top;width: auto;align-self: flex-start;flex: 0 0 auto;min-width: 5%;height: auto;\">\n<section style=\"justify-content: flex-start;display: flex;flex-flow: row nowrap;\" powered-by=\"xiumi.us\">\n<section style=\"display: inline-block;width: auto;vertical-align: top;align-self: flex-start;flex: 0 0 auto;background-color: rgb(189, 216, 245);min-width: 5%;height: auto;padding: 6px 15px;\">\n<section style=\"color: rgb(255, 255, 255);text-align: justify;\" powered-by=\"xiumi.us\">\n<p><strong>\u4e8c<\/strong><\/p>\n<\/section>\n<\/section>\n<\/section>\n<section style=\"margin-bottom: -6px;transform: scale(0.66);transform-origin: left top;\" powered-by=\"xiumi.us\">\n<section style=\"line-height: 1;transform: translate3d(12px, 0px, 0px);\">\n<section style=\"width: 0px;display: inline-block;border-top: 0.6em solid rgb(247, 221, 223);border-left: 0.6em solid rgb(247, 221, 223);border-bottom: 0.6em solid transparent !important;border-right: 0.6em solid transparent !important;\"><svg viewbox=\"0 0 1 1\" style=\"float:left;line-height:0;width:0;vertical-align:top;\"><\/svg><\/section>\n<\/section>\n<\/section>\n<\/section>\n<section style=\"display: inline-block;vertical-align: top;width: auto;flex: 100 100 0%;height: auto;align-self: flex-start;background-color: rgb(255, 229, 231);padding: 6px 6px 6px 14px;\">\n<section style=\"text-align: justify;\" powered-by=\"xiumi.us\">\n<p><strong>\u76f8\u5173\u64cd\u4f5c<\/strong><\/p>\n<\/section>\n<\/section>\n<\/section>\n<p powered-by=\"xiumi.us\"><strong>1. \u8bfb\u53d6\u8868\u683c<\/strong><\/p>\n<p style=\"text-indent: 0em;text-wrap: wrap;\" powered-by=\"xiumi.us\">\u5728\u5c0f\u5e08\u59b9\u8fdb\u884c\u8bb2\u89e3\u524d\u6211\u4eec\u9700\u8981\u51c6\u5907\u51e0\u7ec4\u6570\u636e\uff0creadxl \u4e2d\u5305\u542b\u4e00\u4e9b\u793a\u4f8b\u6587\u4ef6\uff0c\u5c0f\u4f19\u4f34\u4eec\u53ef\u4ee5\u4f7f\u7528\u4e0d\u5e26\u53c2\u6570\u7684 readxl_example() \u6765\u5217\u51fa\u5b83\u4eec\uff0c\u5982\u4e0b\u6240\u793a\u6211\u4eec\u53ef\u4ee5\u770b\u5230\u4ee5\u4e0b\u6587\u4ef6\u3002<\/p>\n<section class=\"code-snippet__fix code-snippet__js\">\n<ul class=\"code-snippet__line-index code-snippet__js\">\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<\/ul>\n<pre class=\"code-snippet__js\" data-lang=\"r\"><code><span class=\"code-snippet_outer\">> readxl_example()<\/span><\/code><code><span class=\"code-snippet_outer\">[<span class=\"code-snippet__number\">1<\/span>] <span class=\"code-snippet__string\">\"clippy.xls\"<\/span>    <span class=\"code-snippet__string\">\"clippy.xlsx\"<\/span>   <span class=\"code-snippet__string\">\"datasets.xls\"<\/span>  <span class=\"code-snippet__string\">\"datasets.xlsx\"<\/span> <span class=\"code-snippet__string\">\"deaths.xls\"<\/span><\/span><\/code><code><span class=\"code-snippet_outer\">[<span class=\"code-snippet__number\">6<\/span>] <span class=\"code-snippet__string\">\"deaths.xlsx\"<\/span>   <span class=\"code-snippet__string\">\"geometry.xls\"<\/span>  <span class=\"code-snippet__string\">\"geometry.xlsx\"<\/span> <span class=\"code-snippet__string\">\"type-me.xls\"<\/span>   <span class=\"code-snippet__string\">\"type-me.xlsx\"<\/span><\/span><\/code><\/pre>\n<\/section>\n<p powered-by=\"xiumi.us\"><br \/><\/p>\n<p style=\"text-indent: 0em;text-wrap: wrap;\" powered-by=\"xiumi.us\">\u6211\u4eec\u8fd8\u53ef\u4ee5\u5728 readxl_example() \u4e2d\u4f20\u5165\u6587\u4ef6\u540d\u6765\u83b7\u53d6\u6587\u4ef6\u7684\u8def\u5f84\uff0c\u5c0f\u5e08\u59b9\u4f20\u5165\u4e00\u4e2a\u793a\u4f8b\u6587\u4ef6\u5982\u4e0b\u6240\u793a\u3002<\/p>\n<section class=\"code-snippet__fix code-snippet__js\">\n<ul class=\"code-snippet__line-index code-snippet__js\">\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<\/ul>\n<pre class=\"code-snippet__js\" data-lang=\"r\"><code><span class=\"code-snippet_outer\">> readxl_example(<span class=\"code-snippet__string\">\"type-me.xls\"<\/span>)<\/span><\/code><code><span class=\"code-snippet_outer\">library(ggplot2)<\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__string\">\"C:\/Users\/24741\/AppData\/Local\/R\/win-library\/4.3\/readxl\/extdata\/type-me.xls\"<\/span><\/span><\/code><\/pre>\n<\/section>\n<p powered-by=\"xiumi.us\"><br \/><\/p>\n<p powered-by=\"xiumi.us\"><span style=\"text-indent: 0em;\">\u7136\u540ereadxl_example() \u914d\u5408read_excel() \u8bfb\u53d6 xls \u548c xlsx \u6587\u4ef6\uff0c\u5c0f\u5e08\u59b9\u6765\u53e5\u4e24\u4e2a\u4f8b\u5b50\uff1a<\/span><br \/><\/p>\n<p powered-by=\"xiumi.us\">\uff081\uff09\u8bfb\u53d6 xls \u6587\u4ef6<\/p>\n<section class=\"code-snippet__fix code-snippet__js\">\n<ul class=\"code-snippet__line-index code-snippet__js\">\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<\/ul>\n<pre class=\"code-snippet__js\" data-lang=\"r\"><code><span class=\"code-snippet_outer\">> readxl_example(<span class=\"code-snippet__string\">\"datasets.xls\"<\/span>) %>% read_excel()<\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__comment\"># A tibble: 150 \u00d7 5<\/span><\/span><\/code><code><span class=\"code-snippet_outer\">Sepal.Length Sepal.Width Petal.Length Petal.Width Species<\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">1<\/span>          <span class=\"code-snippet__number\">5.1<\/span>         <span class=\"code-snippet__number\">3.5<\/span>          <span class=\"code-snippet__number\">1.4<\/span>         <span class=\"code-snippet__number\">0.2<\/span> setosa<\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">2<\/span>          <span class=\"code-snippet__number\">4.9<\/span>         <span class=\"code-snippet__number\">3<\/span>            <span class=\"code-snippet__number\">1.4<\/span>         <span class=\"code-snippet__number\">0.2<\/span> setosa<\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">3<\/span>          <span class=\"code-snippet__number\">4.7<\/span>         <span class=\"code-snippet__number\">3.2<\/span>          <span class=\"code-snippet__number\">1.3<\/span>         <span class=\"code-snippet__number\">0.2<\/span> setosa<\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">4<\/span>          <span class=\"code-snippet__number\">4.6<\/span>         <span class=\"code-snippet__number\">3.1<\/span>          <span class=\"code-snippet__number\">1.5<\/span>         <span class=\"code-snippet__number\">0.2<\/span> setosa<\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">5<\/span>          <span class=\"code-snippet__number\">5<\/span>           <span class=\"code-snippet__number\">3.6<\/span>          <span class=\"code-snippet__number\">1.4<\/span>         <span class=\"code-snippet__number\">0.2<\/span> setosa<\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">6<\/span>          <span class=\"code-snippet__number\">5.4<\/span>         <span class=\"code-snippet__number\">3.9<\/span>          <span class=\"code-snippet__number\">1.7<\/span>         <span class=\"code-snippet__number\">0.4<\/span> setosa<\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">7<\/span>          <span class=\"code-snippet__number\">4.6<\/span>         <span class=\"code-snippet__number\">3.4<\/span>          <span class=\"code-snippet__number\">1.4<\/span>         <span class=\"code-snippet__number\">0.3<\/span> setosa<\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">8<\/span>          <span class=\"code-snippet__number\">5<\/span>           <span class=\"code-snippet__number\">3.4<\/span>          <span class=\"code-snippet__number\">1.5<\/span>         <span class=\"code-snippet__number\">0.2<\/span> setosa<\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">9<\/span>          <span class=\"code-snippet__number\">4.4<\/span>         <span class=\"code-snippet__number\">2.9<\/span>          <span class=\"code-snippet__number\">1.4<\/span>         <span class=\"code-snippet__number\">0.2<\/span> setosa<\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">10<\/span>          <span class=\"code-snippet__number\">4.9<\/span>         <span class=\"code-snippet__number\">3.1<\/span>          <span class=\"code-snippet__number\">1.5<\/span>         <span class=\"code-snippet__number\">0.1<\/span> setosa<\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__comment\"># \u2139 140 more rows<\/span><\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__comment\"># \u2139 Use `print(n = ...)` to see more rows<\/span><\/span><\/code><\/pre>\n<\/section>\n<p powered-by=\"xiumi.us\"><br \/><\/p>\n<p powered-by=\"xiumi.us\">\uff082\uff09\u8bfb\u53d6 xlsx \u6587\u4ef6<\/p>\n<section class=\"code-snippet__fix code-snippet__js\">\n<ul class=\"code-snippet__line-index code-snippet__js\">\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<\/ul>\n<pre class=\"code-snippet__js\" data-lang=\"r\"><code><span class=\"code-snippet_outer\">> readxl_example(<span class=\"code-snippet__string\">\"datasets.xlsx\"<\/span>) %>% read_excel()<\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__comment\"># A tibble: 150 \u00d7 5<\/span><\/span><\/code><code><span class=\"code-snippet_outer\">Sepal.Length Sepal.Width Petal.Length Petal.Width Species<\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">1<\/span> <span class=\"code-snippet__number\">5.1<\/span> <span class=\"code-snippet__number\">3.5<\/span> <span class=\"code-snippet__number\">1.4<\/span> <span class=\"code-snippet__number\">0.2<\/span> setosa<\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">2<\/span> <span class=\"code-snippet__number\">4.9<\/span> <span class=\"code-snippet__number\">3<\/span> <span class=\"code-snippet__number\">1.4<\/span> <span class=\"code-snippet__number\">0.2<\/span> setosa<\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">3<\/span> <span class=\"code-snippet__number\">4.7<\/span> <span class=\"code-snippet__number\">3.2<\/span> <span class=\"code-snippet__number\">1.3<\/span> <span class=\"code-snippet__number\">0.2<\/span> setosa<\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">4<\/span> <span class=\"code-snippet__number\">4.6<\/span> <span class=\"code-snippet__number\">3.1<\/span> <span class=\"code-snippet__number\">1.5<\/span> <span class=\"code-snippet__number\">0.2<\/span> setosa<\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">5<\/span> <span class=\"code-snippet__number\">5<\/span> <span class=\"code-snippet__number\">3.6<\/span> <span class=\"code-snippet__number\">1.4<\/span> <span class=\"code-snippet__number\">0.2<\/span> setosa<\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">6<\/span> <span class=\"code-snippet__number\">5.4<\/span> <span class=\"code-snippet__number\">3.9<\/span> <span class=\"code-snippet__number\">1.7<\/span> <span class=\"code-snippet__number\">0.4<\/span> setosa<\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">7<\/span> <span class=\"code-snippet__number\">4.6<\/span> <span class=\"code-snippet__number\">3.4<\/span> <span class=\"code-snippet__number\">1.4<\/span> <span class=\"code-snippet__number\">0.3<\/span> setosa<\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">8<\/span> <span class=\"code-snippet__number\">5<\/span> <span class=\"code-snippet__number\">3.4<\/span> <span class=\"code-snippet__number\">1.5<\/span> <span class=\"code-snippet__number\">0.2<\/span> setosa<\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">9<\/span> <span class=\"code-snippet__number\">4.4<\/span> <span class=\"code-snippet__number\">2.9<\/span> <span class=\"code-snippet__number\">1.4<\/span> <span class=\"code-snippet__number\">0.2<\/span> setosa<\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">10<\/span> <span class=\"code-snippet__number\">4.9<\/span> <span class=\"code-snippet__number\">3.1<\/span> <span class=\"code-snippet__number\">1.5<\/span> <span class=\"code-snippet__number\">0.1<\/span> setosa<\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__comment\"># \u2139 140 more rows<\/span><\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__comment\"># \u2139 Use `print(n = ...)` to see more rows<\/span><\/span><\/code><\/pre>\n<\/section>\n<p powered-by=\"xiumi.us\"><br \/><\/p>\n<section powered-by=\"xiumi.us\">\n<p style=\"text-indent: 0em;text-wrap: wrap;\">\u5728\u6211\u4eec\u5904\u7406\u751f\u4fe1\u6570\u636e\u7684\u8868\u683c\u65f6\uff0c\u5c0f\u4f19\u4f34\u4eec\u80af\u5b9a\u9047\u5230\u8fc7\u4e00\u4e2a Excel \u6587\u4ef6\u5305\u542b\u591a\u4e2a\u8868\u8fd9\u6837\u7684\u60c5\u51b5\uff0c\u5c0f\u5e08\u59b9\u63a5\u4e0b\u6765\u5c31\u8bb2\u89e3\u4e00\u4e0b\u6211\u4eec\u8be5\u5982\u4f55\u53d6\u5f97\u6211\u4eec\u60f3\u8981\u7684\u8868\u683c\u5e76\u8fdb\u884c\u4e00\u7cfb\u5217\u64cd\u4f5c\u3002<\/p>\n<p style=\"text-indent: 0em;text-wrap: wrap;\">\u9996\u5148\u6211\u4eec\u53ef\u4ee5\u901a\u8fc7\u8bbe\u7f6e sheet \u53c2\u6570\u6765\u6307\u5b9a\u9700\u8981\u4ece Excel \u6587\u4ef6\u4e2d\u8bfb\u53d6\u7684\u8868\u3002\u5c0f\u5e08\u59b9\u62ff\u4e0a\u9762\u7684\u4f8bdatasets.xlsx \u6587\u4ef6\u6765\u4e3e\u4f8b\uff0c\u5728\u8be5\u6587\u4ef6\u4e2d\u6709\u4e00\u4e2a\u540d\u4e3a mtcars \u7684\u8868\u3002<\/p>\n<\/section>\n<section class=\"code-snippet__fix code-snippet__js\">\n<ul class=\"code-snippet__line-index code-snippet__js\">\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<\/ul>\n<pre class=\"code-snippet__js\" data-lang=\"r\"><code><span class=\"code-snippet_outer\">> readxl_example(<span class=\"code-snippet__string\">\"datasets.xlsx\"<\/span>) %>% read_excel(sheet = <span class=\"code-snippet__string\">'mtcars'<\/span>)<\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__comment\"># A tibble: 32 \u00d7 11<\/span><\/span><\/code><code><span class=\"code-snippet_outer\">     mpg   cyl  disp    hp  drat    wt  qsec    vs    am  gear  carb<\/span><\/code><code><span class=\"code-snippet_outer\">   <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">1<\/span>  <span class=\"code-snippet__number\">21<\/span>       <span class=\"code-snippet__number\">6<\/span>  <span class=\"code-snippet__number\">160<\/span>    <span class=\"code-snippet__number\">110<\/span>  <span class=\"code-snippet__number\">3.9<\/span>   <span class=\"code-snippet__number\">2.62<\/span>  <span class=\"code-snippet__number\">16.5<\/span>     <span class=\"code-snippet__number\">0<\/span>     <span class=\"code-snippet__number\">1<\/span>     <span class=\"code-snippet__number\">4<\/span>     <span class=\"code-snippet__number\">4<\/span> <\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">2<\/span>  <span class=\"code-snippet__number\">21<\/span>       <span class=\"code-snippet__number\">6<\/span>  <span class=\"code-snippet__number\">160<\/span>    <span class=\"code-snippet__number\">110<\/span>  <span class=\"code-snippet__number\">3.9<\/span>   <span class=\"code-snippet__number\">2.88<\/span>  <span class=\"code-snippet__number\">17.0<\/span>     <span class=\"code-snippet__number\">0<\/span>     <span class=\"code-snippet__number\">1<\/span>     <span class=\"code-snippet__number\">4<\/span>     <span class=\"code-snippet__number\">4<\/span> <\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">3<\/span>  <span class=\"code-snippet__number\">22.8<\/span>     <span class=\"code-snippet__number\">4<\/span>  <span class=\"code-snippet__number\">108<\/span>     <span class=\"code-snippet__number\">93<\/span>  <span class=\"code-snippet__number\">3.85<\/span>  <span class=\"code-snippet__number\">2.32<\/span>  <span class=\"code-snippet__number\">18.6<\/span>     <span class=\"code-snippet__number\">1<\/span>     <span class=\"code-snippet__number\">1<\/span>     <span class=\"code-snippet__number\">4<\/span>     <span class=\"code-snippet__number\">1<\/span> <\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">4<\/span>  <span class=\"code-snippet__number\">21.4<\/span>     <span class=\"code-snippet__number\">6<\/span>  <span class=\"code-snippet__number\">258<\/span>    <span class=\"code-snippet__number\">110<\/span>  <span class=\"code-snippet__number\">3.08<\/span>  <span class=\"code-snippet__number\">3.22<\/span>  <span class=\"code-snippet__number\">19.4<\/span>     <span class=\"code-snippet__number\">1<\/span>     <span class=\"code-snippet__number\">0<\/span>     <span class=\"code-snippet__number\">3<\/span>     <span class=\"code-snippet__number\">1<\/span> <\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">5<\/span>  <span class=\"code-snippet__number\">18.7<\/span>     <span class=\"code-snippet__number\">8<\/span>  <span class=\"code-snippet__number\">360<\/span>    <span class=\"code-snippet__number\">175<\/span>  <span class=\"code-snippet__number\">3.15<\/span>  <span class=\"code-snippet__number\">3.44<\/span>  <span class=\"code-snippet__number\">17.0<\/span>     <span class=\"code-snippet__number\">0<\/span>     <span class=\"code-snippet__number\">0<\/span>     <span class=\"code-snippet__number\">3<\/span>     <span class=\"code-snippet__number\">2<\/span> <\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">6<\/span>  <span class=\"code-snippet__number\">18.1<\/span>     <span class=\"code-snippet__number\">6<\/span>  <span class=\"code-snippet__number\">225<\/span>    <span class=\"code-snippet__number\">105<\/span>  <span class=\"code-snippet__number\">2.76<\/span>  <span class=\"code-snippet__number\">3.46<\/span>  <span class=\"code-snippet__number\">20.2<\/span>     <span class=\"code-snippet__number\">1<\/span>     <span class=\"code-snippet__number\">0<\/span>     <span class=\"code-snippet__number\">3<\/span>     <span class=\"code-snippet__number\">1<\/span> <\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">7<\/span>  <span class=\"code-snippet__number\">14.3<\/span>     <span class=\"code-snippet__number\">8<\/span>  <span class=\"code-snippet__number\">360<\/span>    <span class=\"code-snippet__number\">245<\/span>  <span class=\"code-snippet__number\">3.21<\/span>  <span class=\"code-snippet__number\">3.57<\/span>  <span class=\"code-snippet__number\">15.8<\/span>     <span class=\"code-snippet__number\">0<\/span>     <span class=\"code-snippet__number\">0<\/span>     <span class=\"code-snippet__number\">3<\/span>     <span class=\"code-snippet__number\">4<\/span> <\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">8<\/span>  <span class=\"code-snippet__number\">24.4<\/span>     <span class=\"code-snippet__number\">4<\/span>  <span class=\"code-snippet__number\">147.<\/span>    <span class=\"code-snippet__number\">62<\/span>  <span class=\"code-snippet__number\">3.69<\/span>  <span class=\"code-snippet__number\">3.19<\/span>  <span class=\"code-snippet__number\">20<\/span>       <span class=\"code-snippet__number\">1<\/span>     <span class=\"code-snippet__number\">0<\/span>     <span class=\"code-snippet__number\">4<\/span>     <span class=\"code-snippet__number\">2<\/span> <\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">9<\/span>  <span class=\"code-snippet__number\">22.8<\/span>     <span class=\"code-snippet__number\">4<\/span>  <span class=\"code-snippet__number\">141.<\/span>    <span class=\"code-snippet__number\">95<\/span>  <span class=\"code-snippet__number\">3.92<\/span>  <span class=\"code-snippet__number\">3.15<\/span>  <span class=\"code-snippet__number\">22.9<\/span>     <span class=\"code-snippet__number\">1<\/span>     <span class=\"code-snippet__number\">0<\/span>     <span class=\"code-snippet__number\">4<\/span>     <span class=\"code-snippet__number\">2<\/span><\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">10<\/span>  <span class=\"code-snippet__number\">19.2<\/span>     <span class=\"code-snippet__number\">6<\/span>  <span class=\"code-snippet__number\">168.<\/span>   <span class=\"code-snippet__number\">123<\/span>  <span class=\"code-snippet__number\">3.92<\/span>  <span class=\"code-snippet__number\">3.44<\/span>  <span class=\"code-snippet__number\">18.3<\/span>     <span class=\"code-snippet__number\">1<\/span>     <span class=\"code-snippet__number\">0<\/span>     <span class=\"code-snippet__number\">4<\/span>     <span class=\"code-snippet__number\">4<\/span><\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__comment\"># \u2139 22 more rows<\/span><\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__comment\"># \u2139 Use `print(n = ...)` to see more rows<\/span><\/span><\/code><\/pre>\n<\/section>\n<p powered-by=\"xiumi.us\"><br \/><\/p>\n<p style=\"text-indent: 0em;text-wrap: wrap;\" powered-by=\"xiumi.us\">\u5176\u6b21\u6211\u4eec\u8fd8\u53ef\u4ee5\u83b7\u53d6\u6240\u6709\u7684\u8868\u683c\u7684\u8868\u540d\uff0c\u8fd9\u65f6\u6211\u4eec\u5c31\u7528\u5230\u4e86excel_sheets() \u51fd\u6570\uff0c\u6548\u679c\u5982\u4e0b\uff1a<\/p>\n<section class=\"code-snippet__fix code-snippet__js\">\n<ul class=\"code-snippet__line-index code-snippet__js\">\n<li><\/li>\n<\/ul>\n<pre class=\"code-snippet__js\" data-lang=\"r\"><code><span class=\"code-snippet_outer\">> readxl_example(<span class=\"code-snippet__string\">\"datasets.xlsx\"<\/span>) %>% excel_sheets()[<span class=\"code-snippet__number\">1<\/span>] <span class=\"code-snippet__string\">\"iris\"<\/span> <span class=\"code-snippet__string\">\"mtcars\"<\/span> <span class=\"code-snippet__string\">\"chickwts\"<\/span> <span class=\"code-snippet__string\">\"quakes\"<\/span><\/span><\/code><\/pre>\n<\/section>\n<p powered-by=\"xiumi.us\"><br \/><\/p>\n<p style=\"text-indent: 0em;text-wrap: wrap;\" powered-by=\"xiumi.us\">\u6700\u540e\u6211\u4eec\u8fd8\u53ef\u4ee5\u901a\u8fc7\u4f20\u5165\u8868\u540d\u7684\u7d22\u5f15\u6765\u83b7\u53d6\u5bf9\u5e94\u8868\u7684\u6570\u636e\uff0c\u5c0f\u5e08\u59b9\u4e3e\u4e2a\u7b80\u5355\u7684\u4f8b\u5b50\uff1a<\/p>\n<section class=\"code-snippet__fix code-snippet__js\">\n<ul class=\"code-snippet__line-index code-snippet__js\">\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<\/ul>\n<pre class=\"code-snippet__js\" data-lang=\"r\"><code><span class=\"code-snippet_outer\">> readxl_example(<span class=\"code-snippet__string\">\"datasets.xlsx\"<\/span>) %>% read_excel(sheet = <span class=\"code-snippet__number\">2<\/span>)<\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__comment\"># A tibble: 32 \u00d7 11<\/span><\/span><\/code><code><span class=\"code-snippet_outer\">     mpg   cyl  disp    hp  drat    wt  qsec    vs    am  gear  carb<\/span><\/code><code><span class=\"code-snippet_outer\">   <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">1<\/span>  <span class=\"code-snippet__number\">21<\/span>       <span class=\"code-snippet__number\">6<\/span>  <span class=\"code-snippet__number\">160<\/span>    <span class=\"code-snippet__number\">110<\/span>  <span class=\"code-snippet__number\">3.9<\/span>   <span class=\"code-snippet__number\">2.62<\/span>  <span class=\"code-snippet__number\">16.5<\/span>     <span class=\"code-snippet__number\">0<\/span>     <span class=\"code-snippet__number\">1<\/span>     <span class=\"code-snippet__number\">4<\/span>     <span class=\"code-snippet__number\">4<\/span> <\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">2<\/span>  <span class=\"code-snippet__number\">21<\/span>       <span class=\"code-snippet__number\">6<\/span>  <span class=\"code-snippet__number\">160<\/span>    <span class=\"code-snippet__number\">110<\/span>  <span class=\"code-snippet__number\">3.9<\/span>   <span class=\"code-snippet__number\">2.88<\/span>  <span class=\"code-snippet__number\">17.0<\/span>     <span class=\"code-snippet__number\">0<\/span>     <span class=\"code-snippet__number\">1<\/span>     <span class=\"code-snippet__number\">4<\/span>     <span class=\"code-snippet__number\">4<\/span> <\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">3<\/span>  <span class=\"code-snippet__number\">22.8<\/span>     <span class=\"code-snippet__number\">4<\/span>  <span class=\"code-snippet__number\">108<\/span>     <span class=\"code-snippet__number\">93<\/span>  <span class=\"code-snippet__number\">3.85<\/span>  <span class=\"code-snippet__number\">2.32<\/span>  <span class=\"code-snippet__number\">18.6<\/span>     <span class=\"code-snippet__number\">1<\/span>     <span class=\"code-snippet__number\">1<\/span>     <span class=\"code-snippet__number\">4<\/span>     <span class=\"code-snippet__number\">1<\/span> <\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">4<\/span>  <span class=\"code-snippet__number\">21.4<\/span>     <span class=\"code-snippet__number\">6<\/span>  <span class=\"code-snippet__number\">258<\/span>    <span class=\"code-snippet__number\">110<\/span>  <span class=\"code-snippet__number\">3.08<\/span>  <span class=\"code-snippet__number\">3.22<\/span>  <span class=\"code-snippet__number\">19.4<\/span>     <span class=\"code-snippet__number\">1<\/span>     <span class=\"code-snippet__number\">0<\/span>     <span class=\"code-snippet__number\">3<\/span>     <span class=\"code-snippet__number\">1<\/span> <\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">5<\/span>  <span class=\"code-snippet__number\">18.7<\/span>     <span class=\"code-snippet__number\">8<\/span>  <span class=\"code-snippet__number\">360<\/span>    <span class=\"code-snippet__number\">175<\/span>  <span class=\"code-snippet__number\">3.15<\/span>  <span class=\"code-snippet__number\">3.44<\/span>  <span class=\"code-snippet__number\">17.0<\/span>     <span class=\"code-snippet__number\">0<\/span>     <span class=\"code-snippet__number\">0<\/span>     <span class=\"code-snippet__number\">3<\/span>     <span class=\"code-snippet__number\">2<\/span> <\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">6<\/span>  <span class=\"code-snippet__number\">18.1<\/span>     <span class=\"code-snippet__number\">6<\/span>  <span class=\"code-snippet__number\">225<\/span>    <span class=\"code-snippet__number\">105<\/span>  <span class=\"code-snippet__number\">2.76<\/span>  <span class=\"code-snippet__number\">3.46<\/span>  <span class=\"code-snippet__number\">20.2<\/span>     <span class=\"code-snippet__number\">1<\/span>     <span class=\"code-snippet__number\">0<\/span>     <span class=\"code-snippet__number\">3<\/span>     <span class=\"code-snippet__number\">1<\/span> <\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">7<\/span>  <span class=\"code-snippet__number\">14.3<\/span>     <span class=\"code-snippet__number\">8<\/span>  <span class=\"code-snippet__number\">360<\/span>    <span class=\"code-snippet__number\">245<\/span>  <span class=\"code-snippet__number\">3.21<\/span>  <span class=\"code-snippet__number\">3.57<\/span>  <span class=\"code-snippet__number\">15.8<\/span>     <span class=\"code-snippet__number\">0<\/span>     <span class=\"code-snippet__number\">0<\/span>     <span class=\"code-snippet__number\">3<\/span>     <span class=\"code-snippet__number\">4<\/span> <\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">8<\/span>  <span class=\"code-snippet__number\">24.4<\/span>     <span class=\"code-snippet__number\">4<\/span>  <span class=\"code-snippet__number\">147.<\/span>    <span class=\"code-snippet__number\">62<\/span>  <span class=\"code-snippet__number\">3.69<\/span>  <span class=\"code-snippet__number\">3.19<\/span>  <span class=\"code-snippet__number\">20<\/span>       <span class=\"code-snippet__number\">1<\/span>     <span class=\"code-snippet__number\">0<\/span>     <span class=\"code-snippet__number\">4<\/span>     <span class=\"code-snippet__number\">2<\/span> <\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">9<\/span>  <span class=\"code-snippet__number\">22.8<\/span>     <span class=\"code-snippet__number\">4<\/span>  <span class=\"code-snippet__number\">141.<\/span>    <span class=\"code-snippet__number\">95<\/span>  <span class=\"code-snippet__number\">3.92<\/span>  <span class=\"code-snippet__number\">3.15<\/span>  <span class=\"code-snippet__number\">22.9<\/span>     <span class=\"code-snippet__number\">1<\/span>     <span class=\"code-snippet__number\">0<\/span>     <span class=\"code-snippet__number\">4<\/span>     <span class=\"code-snippet__number\">2<\/span><\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">10<\/span>  <span class=\"code-snippet__number\">19.2<\/span>     <span class=\"code-snippet__number\">6<\/span>  <span class=\"code-snippet__number\">168.<\/span>   <span class=\"code-snippet__number\">123<\/span>  <span class=\"code-snippet__number\">3.92<\/span>  <span class=\"code-snippet__number\">3.44<\/span>  <span class=\"code-snippet__number\">18.3<\/span>     <span class=\"code-snippet__number\">1<\/span>     <span class=\"code-snippet__number\">0<\/span>     <span class=\"code-snippet__number\">4<\/span>     <span class=\"code-snippet__number\">4<\/span><\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__comment\"># \u2139 22 more rows<\/span><\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__comment\"># \u2139 Use `print(n = ...)` to see more rows<\/span><\/span><\/code><\/pre>\n<\/section>\n<p powered-by=\"xiumi.us\"><br \/><\/p>\n<p powered-by=\"xiumi.us\"><strong>2.\u8bbe\u7f6e\u8303\u56f4\u53d6\u6570\u636e<\/strong><br \/><\/p>\n<p style=\"text-indent: 0em;text-wrap: wrap;\" powered-by=\"xiumi.us\">\u5728\u5f88\u591a\u65f6\u5019\u6211\u4eec\u5f97\u5230\u7684\u8868\u683c\u91cc\u7684\u751f\u4fe1\u6570\u636e\u4e0d\u5168\u662f\u6211\u4eec\u60f3\u8981\u7684\uff0c\u90a3\u5982\u4f55\u53d6\u5f97\u6211\u4eec\u60f3\u8981\u7684\u548c\u6709\u7528\u7684\u6570\u636e\u8fd9\u4e5f\u6210\u4e3a\u4e86\u4e00\u4e2a\u5173\u952e\u3002\u63a5\u4e0b\u6765\u5c0f\u5e08\u59b9\u5c31\u4ecb\u7ecd\u5e76\u4e3e\u4f8b\u5982\u4f55\u7528readxl\u6765\u53d6\u5f97\u6211\u4eec\u60f3\u8981\u7684\u6570\u636e\u3002<\/p>\n<p powered-by=\"xiumi.us\">\uff081\uff09\u7528 n_max \u53c2\u6570\u8bbe\u7f6e\u8bfb\u53d6\u7684\u884c\u6570<\/p>\n<section class=\"code-snippet__fix code-snippet__js\">\n<ul class=\"code-snippet__line-index code-snippet__js\">\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<\/ul>\n<pre class=\"code-snippet__js\" data-lang=\"r\"><code><span class=\"code-snippet_outer\">> readxl_example(<span class=\"code-snippet__string\">\"datasets.xls\"<\/span>) %>% read_excel(n_max = <span class=\"code-snippet__number\">2<\/span>)<\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__comment\"># A tibble: 2 \u00d7 5<\/span><\/span><\/code><code><span class=\"code-snippet_outer\">  Sepal.Length Sepal.Width Petal.Length Petal.Width Species<\/span><\/code><code><span class=\"code-snippet_outer\">         <dbl>       <dbl>        <dbl>       <dbl> <chr>  <\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">1<\/span>          <span class=\"code-snippet__number\">5.1<\/span>         <span class=\"code-snippet__number\">3.5<\/span>          <span class=\"code-snippet__number\">1.4<\/span>         <span class=\"code-snippet__number\">0.2<\/span> setosa <\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">2<\/span>          <span class=\"code-snippet__number\">4.9<\/span>         <span class=\"code-snippet__number\">3<\/span>            <span class=\"code-snippet__number\">1.4<\/span>         <span class=\"code-snippet__number\">0.2<\/span> setosa<\/span><\/code><\/pre>\n<\/section>\n<p powered-by=\"xiumi.us\">\uff082\uff09\u7528 range \u53c2\u6570\u8bbe\u7f6e\u77e9\u5f62\u7684\u8303\u56f4<\/p>\n<section class=\"code-snippet__fix code-snippet__js\">\n<ul class=\"code-snippet__line-index code-snippet__js\">\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<\/ul>\n<pre class=\"code-snippet__js\" data-lang=\"r\"><code><span class=\"code-snippet_outer\">> readxl_example(<span class=\"code-snippet__string\">\"datasets.xls\"<\/span>) %>% read_excel(<span class=\"code-snippet__built_in\">range<\/span> = <span class=\"code-snippet__string\">\"C1:F3\"<\/span>)<\/span><\/code><code><span class=\"code-snippet_outer\">New <span class=\"code-snippet__built_in\">names<\/span>:\u2022 `` -> `...4`<\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__comment\"># A tibble: 2 \u00d7 4<\/span><\/span><\/code><code><span class=\"code-snippet_outer\">  Petal.Length Petal.Width Species ...4 <\/span><\/code><code><span class=\"code-snippet_outer\">         <dbl>       <dbl> <chr>   <lgl><\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">1<\/span>          <span class=\"code-snippet__number\">1.4<\/span>         <span class=\"code-snippet__number\">0.2<\/span> setosa  <span class=\"code-snippet__literal\">NA<\/span>   <\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">2<\/span>          <span class=\"code-snippet__number\">1.4<\/span>         <span class=\"code-snippet__number\">0.2<\/span> setosa  <span class=\"code-snippet__literal\">NA<\/span>  <\/span><\/code><\/pre>\n<\/section>\n<p powered-by=\"xiumi.us\">\uff083\uff09range \u6307\u5b9a\u884c\u6216\u5217\u7684\u8bfb\u53d6\u8303\u56f4<\/p>\n<section class=\"code-snippet__fix code-snippet__js\">\n<ul class=\"code-snippet__line-index code-snippet__js\">\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<\/ul>\n<pre class=\"code-snippet__js\" data-lang=\"r\"><code><span class=\"code-snippet_outer\">> readxl_example(<span class=\"code-snippet__string\">\"datasets.xls\"<\/span>) %>% read_excel(<span class=\"code-snippet__built_in\">range<\/span> = cell_rows(<span class=\"code-snippet__number\">1<\/span>:<span class=\"code-snippet__number\">3<\/span>))<\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__comment\"># A tibble: 2 \u00d7 5<\/span><\/span><\/code><code><span class=\"code-snippet_outer\">  Sepal.Length Sepal.Width Petal.Length Petal.Width Species<\/span><\/code><code><span class=\"code-snippet_outer\">         <dbl>       <dbl>        <dbl>       <dbl> <chr>  <\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">1<\/span>          <span class=\"code-snippet__number\">5.1<\/span>         <span class=\"code-snippet__number\">3.5<\/span>          <span class=\"code-snippet__number\">1.4<\/span>         <span class=\"code-snippet__number\">0.2<\/span> setosa <\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">2<\/span>          <span class=\"code-snippet__number\">4.9<\/span>         <span class=\"code-snippet__number\">3<\/span>            <span class=\"code-snippet__number\">1.4<\/span>         <span class=\"code-snippet__number\">0.2<\/span> setosa<\/span><\/code><\/pre>\n<\/section>\n<p powered-by=\"xiumi.us\">\uff084\uff09 range \u6307\u5b9a\u8868\u683c\u4ee5\u53ca\u8303\u56f4<\/p>\n<section class=\"code-snippet__fix code-snippet__js\">\n<ul class=\"code-snippet__line-index code-snippet__js\">\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<\/ul>\n<pre class=\"code-snippet__js\" data-lang=\"r\"><code><span class=\"code-snippet_outer\">> readxl_example(<span class=\"code-snippet__string\">\"datasets.xls\"<\/span>) %>% read_excel(<span class=\"code-snippet__built_in\">range<\/span> = <span class=\"code-snippet__string\">\"mtcars!A1:E4\"<\/span>)<\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__comment\"># A tibble: 3 \u00d7 5<\/span><\/span><\/code><code><span class=\"code-snippet_outer\">    mpg   cyl  disp    hp  drat<\/span><\/code><code><span class=\"code-snippet_outer\">  <dbl> <dbl> <dbl> <dbl> <dbl><\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">1<\/span>  <span class=\"code-snippet__number\">21<\/span>       <span class=\"code-snippet__number\">6<\/span>   <span class=\"code-snippet__number\">160<\/span>   <span class=\"code-snippet__number\">110<\/span>  <span class=\"code-snippet__number\">3.9<\/span> <\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">2<\/span>  <span class=\"code-snippet__number\">21<\/span>       <span class=\"code-snippet__number\">6<\/span>   <span class=\"code-snippet__number\">160<\/span>   <span class=\"code-snippet__number\">110<\/span>  <span class=\"code-snippet__number\">3.9<\/span> <\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__number\">3<\/span>  <span class=\"code-snippet__number\">22.8<\/span>     <span class=\"code-snippet__number\">4<\/span>   <span class=\"code-snippet__number\">108<\/span>    <span class=\"code-snippet__number\">93<\/span>  <span class=\"code-snippet__number\">3.85<\/span><\/span><\/code><\/pre>\n<\/section>\n<p powered-by=\"xiumi.us\">\uff085\uff09\u8fd8\u53ef\u4ee5\u7528 skip \u53c2\u6570\u8bbe\u7f6e\u5728\u8bfb\u53d6\u4e4b\u524d\u9700\u8981\u8df3\u8fc7\u7684\u884c\u6570\uff0c\u5f53\u7136\u5982\u679c\u8bbe\u7f6e\u4e86 range\uff0c\u5219\u4e0d\u4f1a\u53d1\u6325\u4f5c\u7528<\/p>\n<section class=\"code-snippet__fix code-snippet__js\">\n<ul class=\"code-snippet__line-index code-snippet__js\">\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<li><\/li>\n<\/ul>\n<pre class=\"code-snippet__js\" data-lang=\"r\"><code><span class=\"code-snippet_outer\">> readxl_example(<span class=\"code-snippet__string\">\"datasets.xls\"<\/span>) %>% read_excel(skip = <span class=\"code-snippet__number\">1<\/span>, sheet = <span class=\"code-snippet__string\">\"chickwts\"<\/span>) %>% head(<span class=\"code-snippet__number\">5<\/span>)<\/span><\/code><code><span class=\"code-snippet_outer\"><span class=\"code-snippet__comment\"># A tibble: 5 \u00d7 2<\/span><\/span><\/code><code><span class=\"code-snippet_outer\">  `<span class=\"code-snippet__number\">179<\/span>` horsebean<\/span><\/code><code><span class=\"code-snippet_outer\">  <dbl> <chr>    <\/span><\/code><code><span class=\"code-snippet_outer\">1   160 horsebean<\/span><\/code><code><span class=\"code-snippet_outer\">2   136 horsebean<\/span><\/code><code><span class=\"code-snippet_outer\">3   227 horsebean<\/span><\/code><code><span class=\"code-snippet_outer\">4   217 horsebean<\/span><\/code><code><span class=\"code-snippet_outer\">5   168 horsebean<\/span><\/code><\/pre>\n<\/section>\n<p style=\"text-indent: 0em;text-wrap: wrap;\" powered-by=\"xiumi.us\">\u597d\u4e86\u7ecf\u8fc7\u5c0f\u5e08\u59b9\u7684\u8be6\u7ec6\u8bb2\u89e3\uff0c\u5c0f\u4f19\u4f34\u4eec\u5bf9\u751f\u4fe1\u6570\u636e\u7684 Excel \u6587\u4ef6\u5904\u7406\u662f\u4e0d\u662f\u66f4\u52a0\u5f97\u5fc3\u5e94\u624b\u4e86\u5462\uff0c\u5927\u5bb6\u8bb0\u5f97\u52a8\u624b\u64cd\u4f5c\u54e6\u3002\u90a3\u4eca\u5929\u5c0f\u5e08\u59b9\u7684\u5206\u4eab\u5c31\u5230\u8fd9\u91cc\u5566\uff0c\u5c0f\u4f19\u4f34\u4eec\u518d\u4f1a\u3002<\/p>\n<p style=\"text-indent: 0em;text-wrap: wrap;\" powered-by=\"xiumi.us\"><br \/><\/p>\n<p powered-by=\"xiumi.us\"><img decoding=\"async\" class=\"rich_pages wxw-img\" data-galleryid=\"\" data-ratio=\"0.5555555555555556\" data-s=\"300,640\" src=\"https:\/\/i0.wp.com\/www.biocloudservice.com\/wordpress\/wp-content\/uploads\/2024\/06\/1_FR3wic4MfRmIDKtUUHZdHrGxiaj1ow-9.jpg?w=640\" onerror=\"this.src='https:\/\/mmbiz.qpic.cn\/sz_mmbiz_jpg\/oCSOtP61aEWjRWAeR9wicY9JyrK13cNBaaEibns0HMqkENpTUga2VEOTxwbRFR3wic4MfRmIDKtUUHZdHrGxiaj1ow\/640?wx_fmt=jpeg'\" data-type=\"jpeg\" data-w=\"900\" style=\"font-size: 16px;letter-spacing: 0.578px;text-align: center;text-wrap: wrap;\" data-recalc-dims=\"1\" \/><\/p>\n<\/section>\n<p style=\"display: none;margin-bottom: 24px;\"><mp-style-type data-value=\"3\"><\/mp-style-type><\/p>\n<p><\/content>\n<\/div>\n<p><\/body><br \/>\n<\/html><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4e00\u904d\u5c31\u4f1a\u5e08\u59b9\u6559\u4f60\u7528R\u5904\u7406Excel\u6587\u4ef6\u4e2d\u7684\u751f\u4fe1\u6570\u636e \u5c0f\u5e08\u59b9  \u751f\u4fe1\u679c &nbsp […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":""},"categories":[1],"tags":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/www.biocloudservice.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/53687"}],"collection":[{"href":"http:\/\/www.biocloudservice.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.biocloudservice.com\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.biocloudservice.com\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.biocloudservice.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=53687"}],"version-history":[{"count":1,"href":"http:\/\/www.biocloudservice.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/53687\/revisions"}],"predecessor-version":[{"id":53689,"href":"http:\/\/www.biocloudservice.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/53687\/revisions\/53689"}],"wp:attachment":[{"href":"http:\/\/www.biocloudservice.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=53687"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.biocloudservice.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=53687"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.biocloudservice.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=53687"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}