{"id":775,"date":"2015-02-22T17:42:33","date_gmt":"2015-02-23T00:42:33","guid":{"rendered":"http:\/\/homepages.uc.edu\/~yaozo\/wordpress\/?p=775"},"modified":"2015-02-22T17:42:33","modified_gmt":"2015-02-23T00:42:33","slug":"readworksheetfromfile-reading-data-from-worksheets-in-an-excel-file-wrapper-function","status":"publish","type":"post","link":"https:\/\/zhuoyao.net\/index.php\/2015\/02\/22\/readworksheetfromfile-reading-data-from-worksheets-in-an-excel-file-wrapper-function\/","title":{"rendered":"readWorksheetFromFile Reading data from worksheets in an Excel file (wrapper function)"},"content":{"rendered":"<p>Examples #<\/p>\n<p>multiregion xlsx file from demoFiles subfolder of # package XLConnect<\/p>\n<pre class=\"\">demoExcelFile &lt;- system.file(\"demoFiles\/multiregion.xlsx\", package = \"XLConnect\")<\/pre>\n<p># Read single area from first sheet of existing file,<\/p>\n<p># &#8220;B2:C3&#8221; in Excel speak<\/p>\n<pre class=\"\">df.one &lt;- readWorksheetFromFile(demoExcelFile, sheet = 1, header = FALSE, startCol = 2, startRow = 2, endCol = 3, endRow = 3)<\/pre>\n<p># Read three data sets in one from known positions<\/p>\n<pre class=\"\">dflist &lt;- readWorksheetFromFile(demoExcelFile, sheet = c(\"FirstSheet\", \"FirstSheet\", \"SecondSheet\"), header = TRUE, startRow = c(2,2,3), startCol = c(2,5,2), endCol = c(5,8,6), endRow = c(9,15,153))<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Examples # multiregion xlsx file from demoFiles subfolder of # package XLConnect demoExcelFile &lt;- system.file(&#8220;demoFiles\/multiregion.xlsx&#8221;, package = &#8220;XLConnect&#8221;) # Read single area from first sheet&hellip; <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20],"tags":[],"class_list":["post-775","post","type-post","status-publish","format-standard","hentry","category-r"],"_links":{"self":[{"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/posts\/775","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/comments?post=775"}],"version-history":[{"count":0,"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/posts\/775\/revisions"}],"wp:attachment":[{"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/media?parent=775"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/categories?post=775"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/tags?post=775"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}