How to read an excel file in R

Question

Hi Guys,

I have an excel file in the local system. I want to load the file in RStudio. How can I do that?

Answer 1

Hi@akhtar,

You can read your excel file by using the read.xlsx() function as shown below. The result is stored as a data frame in the R environment.

data <- read.xlsx("input.xlsx", sheetIndex = 1) 
print(data)