{"id":2944,"date":"2014-06-03T08:16:29","date_gmt":"2014-06-03T07:16:29","guid":{"rendered":"https:\/\/abcdr.guyader.pro\/?p=2944"},"modified":"2018-04-08T00:01:14","modified_gmt":"2018-04-07T23:01:14","slug":"importer-un-classeur-a-plusieurs-feuilles","status":"publish","type":"post","link":"https:\/\/thinkr.fr\/abcdr\/importer-un-classeur-a-plusieurs-feuilles\/","title":{"rendered":"Comment importer fichier .xlsx dans R ? : readWorksheetFromFile"},"content":{"rendered":"<p>L&rsquo;import de fichier Excel dans R a toujours \u00e9t\u00e9 un peu laborieuse, plusieurs fa\u00e7ons de faire plus ou moins compliqu\u00e9es. Une fonction sort du lot readWorksheetFromFile du package XLconnect<\/p>\n<p><\/p>\n<pre><code><br \/>\nlibrary(XLConnect)<br \/>\ndataset&lt;-readWorksheetFromFile(file=&quot;http:\/\/www.euklems.net\/data\/nace2\/fra_output_12i.xlsx &quot;, sheet=3)<br \/>\nhead(dataset)\n<br \/><br \/><\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>L&rsquo;import de fichier Excel dans R a toujours \u00e9t\u00e9 un peu laborieuse, plusieurs fa\u00e7ons de faire plus ou moins compliqu\u00e9es. Une fonction sort du lot readWorksheetFromFile du package XLconnect library(XLConnect) dataset&lt;-readWorksheetFromFile(file=&quot;http:\/\/www.euklems.net\/data\/nace2\/fra_output_12i.xlsx &quot;, sheet=3) head(dataset)<a class=\"more-link\" href=\"https:\/\/thinkr.fr\/abcdr\/importer-un-classeur-a-plusieurs-feuilles\/\">Read More &rarr;<\/a><\/p>\n","protected":false},"author":12,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","rop_custom_images_group":[],"rop_custom_messages_group":[],"rop_publish_now":"initial","rop_publish_now_accounts":{"twitter_399453572_399453572":""},"rop_publish_now_history":[],"rop_publish_now_status":"pending","jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[10],"tags":[],"class_list":{"0":"entry","1":"post","2":"publish","3":"author-julie","4":"post-2944","6":"format-standard","7":"category-importation-de-donnees"},"acf":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p9O7Sx-Lu","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/thinkr.fr\/abcdr\/wp-json\/wp\/v2\/posts\/2944","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/thinkr.fr\/abcdr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/thinkr.fr\/abcdr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/thinkr.fr\/abcdr\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/thinkr.fr\/abcdr\/wp-json\/wp\/v2\/comments?post=2944"}],"version-history":[{"count":2,"href":"https:\/\/thinkr.fr\/abcdr\/wp-json\/wp\/v2\/posts\/2944\/revisions"}],"predecessor-version":[{"id":4243,"href":"https:\/\/thinkr.fr\/abcdr\/wp-json\/wp\/v2\/posts\/2944\/revisions\/4243"}],"wp:attachment":[{"href":"https:\/\/thinkr.fr\/abcdr\/wp-json\/wp\/v2\/media?parent=2944"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/thinkr.fr\/abcdr\/wp-json\/wp\/v2\/categories?post=2944"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/thinkr.fr\/abcdr\/wp-json\/wp\/v2\/tags?post=2944"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}