{"id":3523,"date":"2022-06-26T21:43:19","date_gmt":"2022-06-26T16:13:19","guid":{"rendered":"https:\/\/sheetstips.com\/?p=3523"},"modified":"2022-06-26T21:43:19","modified_gmt":"2022-06-26T16:13:19","slug":"how-to-export-a-dataframe-to-excel-file-in-r","status":"publish","type":"post","link":"https:\/\/sheetstips.com\/how-to-export-a-dataframe-to-excel-file-in-r\/","title":{"rendered":"How to Export a DataFrame to Excel File in R ?"},"content":{"rendered":"<p>It is a common requirement to save our dataframe for portability after working on it on the computer system&#8217;s auxiliary memory using the R Programming Language.<br \/>\nIn this tutorial, we will export our dataframe to Excel using the writexl package.<\/p>\n<p><strong> writexl Package:<\/strong><\/p>\n<p>You can export your DataFrame to Excel by using the writexl package in R.<\/p>\n<p><strong>Installation<\/strong><\/p>\n<p>Type the below command in your R console to install the writexl package.<\/p>\n<pre>install.packages(\"writexl\")<\/pre>\n<p><strong>Output:<\/strong><\/p>\n<pre>Installing package into \u2018C:\/Users\/cirus\/AppData\/Local\/R\/win-library\/4.2\u2019\r\n(as \u2018lib\u2019 is unspecified)\r\ntrying URL 'https:\/\/cloud.r-project.org\/bin\/windows\/contrib\/4.2\/writexl_1.4.0.zip'\r\nContent type 'application\/zip' length 190332 bytes (185 KB)\r\ndownloaded 185 KB\r\n\r\npackage \u2018writexl\u2019 successfully unpacked and MD5 sums checked\r\n\r\nThe downloaded binary packages are in\r\nC:\\Users\\cirus\\AppData\\Local\\Temp\\RtmpOwpVEv\\downloaded_packages<\/pre>\n<p><strong>write_xlsx() Function:<\/strong><\/p>\n<p>The write_xlsx() function from the writexl package is the simplest way to export a data frame to an Excel file in R.<\/p>\n<p>It is used to write a dataframe to an Excel (.xlsx) file.<\/p>\n<p><strong>Syntax:<\/strong><\/p>\n<pre>write_xlsx(x, path)<\/pre>\n<p><strong>Parameters<\/strong><\/p>\n<ul>\n<li><strong>x:<\/strong> It is the data frame name to export<\/li>\n<li><strong style=\"font-size: inherit;\">path:<\/strong><span style=\"font-size: inherit;\"> It is the path of the file <\/span><span style=\"font-size: inherit;\">to write to.<\/span><\/li>\n<\/ul>\n<h2>Exporting a DataFrame to Excel File in R<\/h2>\n<ul>\n<li><a href=\"#Using_EmailFilter\">Using EmailFilter<\/a><\/li>\n<li><a href=\"#Exporting_the_Dataframe_to_a_CSV_File\">Exporting the Dataframe to a CSV File<\/a><\/li>\n<\/ul>\n<h3 id=\"Using_EmailFilter\">Method #1: Exporting the Dataframe to an Excel File<\/h3>\n<p><strong>Example1<\/strong><\/p>\n<p><strong>Approach:<\/strong><\/p>\n<ul>\n<li>Import writexl package using the library() function.<\/li>\n<li>Create the dataFrame that you want to export to Excel file.<\/li>\n<li>Display the above created dataframe.<\/li>\n<li>Save the above dataframe in an Excel File by passing the dataframe and excel file path as arguments to the write_xlsx() function.<\/li>\n<li>The Exit of the Program.<\/li>\n<\/ul>\n<p><strong>Below is the implementation:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"r\"># Import writexl package using the library() function\r\nlibrary(writexl)\r\n\r\n# Create the dataFrame that you want to export to Excel file\r\ndatafrme &lt;- data.frame(Fruits = c(\"Apple\", \"Mango\", \"Orange\", \"Grapes\"),\r\n                CostPerKG = c(120, 100, 50, 70))\r\n# Display the above created dataframe\r\ndatafrme\r\n\r\n# Save the above dataframe in an Excel File by passing the \r\n# dataframe and excel file path as arguments to the write_xlsx() function\r\nwrite_xlsx(datafrme,\"Output_dataframe.xlsx\")\r\n<\/pre>\n<p><strong>Output:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"raw\">  Fruits CostPerKG\r\n1  Apple       120\r\n2  Mango       100\r\n3 Orange        50\r\n4 Grapes        70<\/pre>\n<p><strong>Explanation:<\/strong><\/p>\n<pre>Here the dataframe is exported to the given directory or path as an Excel file.<\/pre>\n<p><strong>Example2<\/strong><\/p>\n<p>The only difference between this example and the previous ones is the number of arguments supplied.<\/p>\n<p>Here, we have passed two <strong>extra<\/strong> arguments that allow us to have more control over the formatting of the Excel file. They are:<\/p>\n<p><strong>col_names:<\/strong> It is used to write column names at the top of the Excel file (.xlsx)<br \/>\n<strong>_headers:<\/strong> It is used to make the column names(col_names) in the Excel file centered and bold.<\/p>\n<p><strong>Approach:<\/strong><\/p>\n<ul>\n<li>Import writexl package using the library() function<\/li>\n<li>Create the dataFrame that you want to export to Excel file<\/li>\n<li>Display the above created dataframe.<\/li>\n<li>Save the above dataframe in an Excel File by passing the dataframe and excel file path, col_names as TRUE, format_headers as TRUE as arguments to the write_xlsx() function<\/li>\n<li>Here col_name writes column names at the top of the given Excel file.<\/li>\n<li>By passing format_headers = TRUE we can make column names centered and bold.<\/li>\n<li>The Exit of the Program.<\/li>\n<\/ul>\n<p><strong>Below is the implementation:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"r\"># Import writexl package using the library() function\r\nlibrary(writexl)\r\n\r\n# Create the dataFrame that you want to export to Excel file\r\ndatafrme &lt;- data.frame(Fruits = c(\"Apple\", \"Mango\", \"Orange\", \"Grapes\"),\r\n                CostPerKG = c(120, 100, 50, 70))\r\n# Display the above created dataframe\r\ndatafrme\r\n\r\n# Save the above dataframe in an Excel File by passing the \r\n# dataframe and excel file path, col_names as TRUE, format_headers as TRUE \r\n# as arguments to the write_xlsx() function\r\n# Here col_name writes column names at the top of the given Excel file.\r\n# By passing format_headers = TRUE we can make column names centered and bold. \r\nwrite_xlsx(datafrme,\"Output_dataframe.xlsx\",\r\n          \tcol_names = TRUE,\r\n                format_headers = TRUE )\r\n<\/pre>\n<p><strong>Output:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"raw\">  Fruits CostPerKG\r\n1  Apple       120\r\n2  Mango       100\r\n3 Orange        50\r\n4 Grapes        70<\/pre>\n<h3 id=\"Exporting_the_Dataframe_to_a_CSV_File\">Method #2: Exporting the Dataframe to a CSV File<\/h3>\n<p>Because write.csv() is a built-in function in R, we don&#8217;t need to install any other libraries to use it.<\/p>\n<p>It is used to write a dataframe to a CSV file(.csv)<\/p>\n<p><strong>Syntax:<\/strong><\/p>\n<pre>write.csv(dataframe, filepath)<\/pre>\n<p><strong>Parameters<\/strong><\/p>\n<ul>\n<li><strong>dataframe:<\/strong> It is the data frame name to export.<\/li>\n<li><strong style=\"font-size: inherit;\">filepath:<\/strong><span style=\"font-size: inherit;\"> It is the path of the csv file <\/span><span style=\"font-size: inherit;\">to write to. It indicates the location where our CSV file with the given file name will be saved.<\/span><\/li>\n<\/ul>\n<p><strong>Approach:<\/strong><\/p>\n<ul>\n<li>Create the dataFrame that you want to export to csv file and store it in a variable<\/li>\n<li>Display the above created dataframe<\/li>\n<li>Save the above dataframe in a CSV File by passing the dataframe and csv file path as arguments to the write.csv() function.<\/li>\n<li>The Exit of the Program.<\/li>\n<\/ul>\n<p><strong>Below is the implementation:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"r\"># Create the dataFrame that you want to export to csv file\r\n# and store it in a variable\r\ndatafrme &lt;- data.frame(Fruits = c(\"Apple\", \"Mango\", \"Orange\", \"Grapes\"),\r\n                CostPerKG = c(120, 100, 50, 70))\r\n# Display the above created dataframe\r\ndatafrme\r\n\r\n# Save the above dataframe in a CSV File by passing the \r\n# dataframe and csv file path as arguments to the write.csv() function\r\nwrite.csv(datafrme,\"Output_dataframe.csv\")\r\n<\/pre>\n<p><strong>Output:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"raw\">  Fruits CostPerKG\r\n1  Apple       120\r\n2  Mango       100\r\n3 Orange        50\r\n4 Grapes        70<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>It is a common requirement to save our dataframe for portability after working on it on the computer system&#8217;s auxiliary memory using the R Programming Language. In this tutorial, we will export our dataframe to Excel using the writexl package. writexl Package: You can export your DataFrame to Excel by using the writexl package in &#8230; <a title=\"How to Export a DataFrame to Excel File in R ?\" class=\"read-more\" href=\"https:\/\/sheetstips.com\/how-to-export-a-dataframe-to-excel-file-in-r\/\" aria-label=\"More on How to Export a DataFrame to Excel File in R ?\">Read more<\/a><\/p>\n","protected":false},"author":3,"featured_media":3593,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[182],"tags":[],"jetpack_featured_media_url":"https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/06\/How-to-Export-a-DataFrame-to-Excel-File-in-R.jpg","jetpack-related-posts":[{"id":3503,"url":"https:\/\/sheetstips.com\/how-to-convert-excel-content-into-dataframe-in-r\/","url_meta":{"origin":3523,"position":0},"title":"How to Convert Excel Content into DataFrame in R ?","author":"David","date":"June 23, 2022","format":false,"excerpt":"The R Programming Language allows us to read and write data into a variety of files such as CSV, Excel, and XML. In this tutorial, we will look at how to convert Excel data into a DataFrame in R. To read an excel file, use the read. xlsx() function of\u2026","rel":"","context":"In &quot;MS Excel&quot;","block_context":{"text":"MS Excel","link":"https:\/\/sheetstips.com\/category\/ms-excel\/"},"img":{"alt_text":"How to Convert Excel Content into DataFrame in R","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2022\/06\/How-to-Convert-Excel-Content-into-DataFrame-in-R.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":3529,"url":"https:\/\/sheetstips.com\/how-to-read-password-protected-excel-file-in-r\/","url_meta":{"origin":3523,"position":1},"title":"How to Read Password Protected Excel file in R?","author":"David","date":"December 2, 2022","format":false,"excerpt":"This article will show how to read password-protected Excel files in the R programming language. Also Read: C Program to Draw Sine Wave Using C Graphics Let us use the excelFile.xlsx excel file here which is shown below: excelFile.xlsx: Reading Password Protected Excel file in R This can be done\u2026","rel":"","context":"In &quot;MS Excel&quot;","block_context":{"text":"MS Excel","link":"https:\/\/sheetstips.com\/category\/ms-excel\/"},"img":{"alt_text":"How to Read Password Protected Excel file in R","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2022\/06\/How-to-Read-Password-Protected-Excel-file-in-R.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":3481,"url":"https:\/\/sheetstips.com\/write-data-into-excel-using-r\/","url_meta":{"origin":3523,"position":2},"title":"How to Write Data Into Excel Using R Language","author":"David","date":"June 23, 2022","format":false,"excerpt":"This post will go over how to use the R Programming Language to write data into Excel. To write data into Excel, we must use the package xlsx of R. xlsx package: The excel package is a robust Java-based language for reading, writing, and updating data from and to excel\u2026","rel":"","context":"In &quot;MS Excel&quot;","block_context":{"text":"MS Excel","link":"https:\/\/sheetstips.com\/category\/ms-excel\/"},"img":{"alt_text":"How to Write Data Into Excel Using R Language","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2022\/06\/How-to-Write-Data-Into-Excel-Using-R-Language.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":3300,"url":"https:\/\/sheetstips.com\/how-to-export-multiple-dataframes-to-different-excel-worksheets-in-r\/","url_meta":{"origin":3523,"position":3},"title":"How to Export Multiple Dataframes to Different Excel Worksheets Using R?","author":"David","date":"June 8, 2022","format":false,"excerpt":"Let us look at how to export multiple dataframes to different Excel Worksheets using R language. xlsx Module: The xlsx module will be used for this purpose. The xlsx library contains R functions for reading\/writing\/formatting Excel files and formats. Excel files can be controlled programmatically using the xlsx package. The\u2026","rel":"","context":"In &quot;MS Excel&quot;","block_context":{"text":"MS Excel","link":"https:\/\/sheetstips.com\/category\/ms-excel\/"},"img":{"alt_text":"How to Export Multiple Dataframes to Different Excel Worksheets Using R","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2022\/06\/How-to-Export-Multiple-Dataframes-to-Different-Excel-Worksheets-Using-R.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":3547,"url":"https:\/\/sheetstips.com\/how-to-perform-a-vlookup-similar-to-excel-in-r\/","url_meta":{"origin":3523,"position":4},"title":"How to Perform a VLOOKUP (Similar to Excel) in R?","author":"David","date":"June 28, 2022","format":false,"excerpt":"The VLOOKUP function in Excel helps you to look up a value in a table by matching on a column. VLOOKUP is an Excel function that stands for vertical lookup. This function's job is to look for a specific value in a column and return a value from a different\u2026","rel":"","context":"In &quot;MS Excel&quot;","block_context":{"text":"MS Excel","link":"https:\/\/sheetstips.com\/category\/ms-excel\/"},"img":{"alt_text":"How to Perform a VLOOKUP (Similar to Excel) in R","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2022\/06\/How-to-Perform-a-VLOOKUP-Similar-to-Excel-in-R.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":3526,"url":"https:\/\/sheetstips.com\/convert-an-excel-column-into-a-list-of-vectors-in-r\/","url_meta":{"origin":3523,"position":5},"title":"How to Convert an Excel Column into a List of vectors in R?","author":"David","date":"March 7, 2024","format":false,"excerpt":"In this article, we will look at various methods for converting Excel columns to vectors in the R programming language. Read Also: Java Program to Convert Inch to Kilometer and Kilometer to Inch Let us use the below given sampleExcelFile.xlsx Excel File here: \u00a0 Converting an Excel Column into a\u2026","rel":"","context":"In &quot;MS Excel&quot;","block_context":{"text":"MS Excel","link":"https:\/\/sheetstips.com\/category\/ms-excel\/"},"img":{"alt_text":"How to Convert an Excel Column into a List of vectors in R","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2022\/06\/How-to-Convert-an-Excel-Column-into-a-List-of-vectors-in-R.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/3523"}],"collection":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/comments?post=3523"}],"version-history":[{"count":8,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/3523\/revisions"}],"predecessor-version":[{"id":3671,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/3523\/revisions\/3671"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/media\/3593"}],"wp:attachment":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/media?parent=3523"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/categories?post=3523"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/tags?post=3523"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}