{"id":3065,"date":"2023-07-19T09:25:30","date_gmt":"2023-07-19T09:25:30","guid":{"rendered":"https:\/\/statorials.org\/id\/tulis-ulang-xlsx\/"},"modified":"2023-07-19T09:25:30","modified_gmt":"2023-07-19T09:25:30","slug":"tulis-ulang-xlsx","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/tulis-ulang-xlsx\/","title":{"rendered":"Cara menggunakan write.xlsx di r (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan fungsi <strong>write.xlsx<\/strong> di R untuk menulis bingkai data ke buku kerja Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Fungsi ini menggunakan sintaks dasar berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>write.write. <span style=\"color: #3366ff;\">xlsx<\/span> (x, file, sheetName = \" <span style=\"color: #ff0000;\">Sheet1<\/span> \", ...)<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Emas:<\/span><\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>x<\/strong> : Nama bingkai data<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>file<\/strong> : jalur ke file keluaran<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>sheetName<\/strong> : Nama sheet yang akan ditampilkan di buku kerja. Standarnya adalah \u201cLembar 1\u201d<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara menggunakan fungsi <strong>write.xlsx<\/strong> dalam praktiknya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Instal dan muat paket xlsx<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Pertama, kita perlu menginstal dan memuat paket <strong>xlsx<\/strong> untuk menggunakan fungsi <strong>write.xlsx<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>install. <span style=\"color: #3366ff;\">packages<\/span> (' <span style=\"color: #ff0000;\">xlsx<\/span> ')     \n<span style=\"color: #008000;\">library<\/span> (xlsx)<\/strong><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Buat bingkai data<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Selanjutnya, mari buat bingkai data berikut di R:<\/span><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#create data frame\n<\/span>df &lt;- data. <span style=\"color: #3366ff;\">frame<\/span> (team=c('A', 'B', 'C', 'D', 'E'),\n                 points=c(99, 90, 86, 88, 95),\n                 assists=c(33, 28, 31, 39, 34),\n                 rebounds=c(30, 28, 24, 24, 28))\t\n\n<span style=\"color: #008080;\">#view data frame<\/span>\ndf\n\n  team points assists rebounds\n1 A 99 33 30\n2 B 90 28 28\n3 C 86 31 24\n4 D 88 39 24\n5 E 95 34 28\n<\/strong><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Gunakan write.xlsx untuk mengekspor bingkai data ke file Excel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, mari kita gunakan <strong>write.xlsx()<\/strong> untuk menulis blok data ke file bernama <strong>my_data.xlsx<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#write data frame to Excel file<\/span>\nwrite.write. <span style=\"color: #3366ff;\">xlsx<\/span> (df, ' <span style=\"color: #ff0000;\">my_data.xlsx<\/span> ')<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">File secara otomatis akan ditulis ke <a href=\"https:\/\/statorials.org\/id\/setwd-getwd-di-sungai\/\" target=\"_blank\" rel=\"noopener\">direktori kerja<\/a> saat ini.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika saya menavigasi ke direktori kerja saat ini, saya dapat menemukan file Excel ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-26263\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/xlsx1.jpg\" alt=\"fungsi write.xlsx di R\" width=\"487\" height=\"401\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Nilai-nilai dalam buku kerja Excel cocok dengan nilai-nilai dalam bingkai data.<\/span><\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 4 (Opsional): Gunakan write.xlsx dengan argumen khusus<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa Anda juga bisa menggunakan sintaks berikut untuk mengubah nama lembar di buku kerja Excel dan menghapus nama baris:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#write data frame to Excel file<\/span>\nwrite.write. <span style=\"color: #3366ff;\">xlsx<\/span> (df, ' <span style=\"color: #ff0000;\">my_data.xlsx<\/span> ', sheetName = ' <span style=\"color: #ff0000;\">basketball_data<\/span> ', <span style=\"color: #3366ff;\">row.names<\/span> = <span style=\"color: #008000;\">FALSE<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Jika saya menavigasi ke direktori kerja saat ini, saya dapat menemukan file Excel ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26264 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/xlsx2.jpg\" alt=\"\" width=\"502\" height=\"432\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa nama sheet telah berubah dan kolom pertama tidak lagi berisi nomor baris.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara mengekspor jenis file lain di R:<\/span><\/p>\n<p><a href=\"https:\/\/statorials.org\/id\/ekspor-bingkai-data-ke-csv-di-r\/\" target=\"_blank\" rel=\"noopener\">Cara mengekspor kerangka data ke file CSV di R<\/a><br \/> Cara mengekspor bingkai data ke beberapa lembar Excel di R<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan fungsi write.xlsx di R untuk menulis bingkai data ke buku kerja Excel. Fungsi ini menggunakan sintaks dasar berikut: write.write. xlsx (x, file, sheetName = &#8221; Sheet1 &#8220;, &#8230;) Emas: x : Nama bingkai data file : jalur ke file keluaran sheetName : Nama sheet yang akan ditampilkan di buku kerja. Standarnya adalah [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cara menggunakan write.xlsx di R (dengan contoh) \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi write.xlsx di R, dengan beberapa contoh.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/tulis-ulang-xlsx\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menggunakan write.xlsx di R (dengan contoh) \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi write.xlsx di R, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/tulis-ulang-xlsx\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-19T09:25:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/xlsx1.jpg\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/tulis-ulang-xlsx\/\",\"url\":\"https:\/\/statorials.org\/id\/tulis-ulang-xlsx\/\",\"name\":\"Cara menggunakan write.xlsx di R (dengan contoh) \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-19T09:25:30+00:00\",\"dateModified\":\"2023-07-19T09:25:30+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi write.xlsx di R, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/tulis-ulang-xlsx\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/tulis-ulang-xlsx\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/tulis-ulang-xlsx\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggunakan write.xlsx di r (dengan contoh)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara menggunakan write.xlsx di R (dengan contoh) \u2013 Statologi","description":"Tutorial ini menjelaskan cara menggunakan fungsi write.xlsx di R, dengan beberapa contoh.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/statorials.org\/id\/tulis-ulang-xlsx\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menggunakan write.xlsx di R (dengan contoh) \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi write.xlsx di R, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/tulis-ulang-xlsx\/","og_site_name":"Statorials","article_published_time":"2023-07-19T09:25:30+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/xlsx1.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/tulis-ulang-xlsx\/","url":"https:\/\/statorials.org\/id\/tulis-ulang-xlsx\/","name":"Cara menggunakan write.xlsx di R (dengan contoh) \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-19T09:25:30+00:00","dateModified":"2023-07-19T09:25:30+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi write.xlsx di R, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/tulis-ulang-xlsx\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/tulis-ulang-xlsx\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/tulis-ulang-xlsx\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggunakan write.xlsx di r (dengan contoh)"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3065"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=3065"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3065\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3065"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3065"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3065"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}