Tutorials
Courses

Similar Topics

Web Technologies37.4K+ articles

DSA22.8K+ articles

Python21.3K+ articles

Experiences16.6K+ articles

Interview Experiences14.2K+ articles

JavaScript12.2K+ articles

School Learning11.5K+ articles

Java10.8K+ articles

Misc8.8K+ articles

Mathematical7.8K+ articles

R-Excel

20 posts

Convert an Excel column into a list of vectors in R

Last Updated: 17 April 2021

In this article, we will be discussing the different approaches to convert the Excel columns to vector in the R Programming language.File in use:Method 1: Using $-Operator...read more

article_image

How to export a DataFrame to Excel File in R ?

Last Updated: 21 April 2021

It is a frequent requirement to save our dataframe for portability after working on it on the auxiliary memory of the computer system using R Programming Language. In this...read more

article_image

Machine Learning

How to import an Excel File into R ?

Last Updated: 22 February 2023

In this article, we will discuss how to import an excel file in the R Programming Language. There two different types of approaches to import the excel file into the R pro...read more

article_image

How to read Excel file and select specific rows and columns in R?

Last Updated: 20 May 2021

In this article, we will discuss how to read an Excel file and select specific rows and columns from it using R Programming Language.File Used:To read an Excel file into R...read more

article_image

Import multiple excel sheets into in R

Last Updated: 17 June 2021

In this article, we are going to see how to import multiple Excel sheets into the R language. Excel provides us with multiple worksheets. For example, in the below Excel w...read more

article_image

How to Export Multiple Dataframes to Different Excel Worksheets in R

Last Updated: 17 June 2021

In this article, we are going to see how to export multiple dataframe to different Excel Worksheets in R Programming Language.We will be using the xlsx module. The xlsx li...read more

article_image

How to read a XLSX file with multiple Sheets in R?

Last Updated: 06 June 2021

In this article, we are going to see how to read an XLSX file with multiple Sheets in R Language. There are various external packages in R used to read XLSX files with mul...read more

Combine Multiple Excel Worksheets into Single Dataframe in R

Last Updated: 17 June 2021

In this article, we will discuss how to combine multiple excel worksheets into a single dataframe in R Programming Language.The below XLSX file "gfg.xlsx" has been used fo...read more

article_image

How to read multiple Excel files in R

Last Updated: 18 July 2021

In this article, we will discuss how to merge multiple Excel files in the R programming language.Modules Used:dplyr: The dplyr package in R is a structure of data manipula...read more

article_image

How to read password protected excel file in R ?

Last Updated: 18 July 2021

In this article, we are going to see how to read password-protected Excel files in R programming language.File in use: fileMethod 1: Using excel.link Package.Here we will...read more

Specify Row Names when Reading Excel File in R

Last Updated: 31 August 2021

In this article, we are going to specify the row names when reading Excel file in the R Programming language.Specifying row names when reading a file using row.names argum...read more

How to Perform a VLOOKUP (Similar to Excel) in R?

Last Updated: 21 February 2022

VLOOKUP is a function in excel and it is an acronym for vertical lookup. The task of this function is to search for a particular value in a column to return a value from a...read more

article_image

Write Data Into Excel Using R

Last Updated: 13 June 2022

In this article, we will discuss how to write data into excel using R Programming Language. To write data into excel, we must leverage a package called xlsx in R. The exc...read more

article_image

How To Use Readxl Package To Read Data In R

Last Updated: 20 December 2023

In this article let's discuss how to use the Readxl Package to read data in the R Programming Language.Readxl Package in RThe readxl package in R is used to read data fro...read more

Reading and Writing Excel Files With R Using readxl and writexl

Last Updated: 27 June 2022

In this article let's discuss reading and writing excel files using readxl and writexl packages of the R programming language.read_excel() method in readxl Package:The Rea...read more