How to read an excel file in R?

0 votes

Hi Guys,

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

Oct 29 in Data Analytics by akhtar
• 32,960 points
18 views

1 answer to this question.

0 votes

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)
answered Oct 29 by MD
• 77,580 points

Related Questions In Data Analytics

0 votes
1 answer

How to convert a text mining termDocumentMatrix into excel or csv in R?

By assuming that all the values are ...READ MORE

answered Apr 5, 2018 in Data Analytics by DeepCoder786
• 1,720 points
497 views
0 votes
3 answers

How to write lines to a text file in R?

sink("outfile.txt") cat("hello") cat("\n" ...READ MORE

answered May 24, 2019 in Data Analytics by anonymous
12,442 views
0 votes
2 answers

How to set working directory to source file location in R?

Hi,  I'm not sure about the command but you ...READ MORE

answered Aug 20, 2019 in Data Analytics by Cherukuri
• 32,490 points
8,858 views
0 votes
1 answer

How can I read a .csv file in R language?

read.csv () function is used to read ...READ MORE

answered Jun 11, 2018 in Data Analytics by zombie
• 3,770 points
149 views
+10 votes
3 answers

Which is a better initiative to learn data science: Python or R?

Well it truly depends on your requirement, If ...READ MORE

answered Aug 8, 2018 in Data Analytics by Abhi
• 3,720 points
223 views
+1 vote
1 answer

Error saying "vector size cannot be NA" when using R with data mining

You can use the removesparseterm function.  Removes sparse ...READ MORE

answered Nov 15, 2018 in Data Analytics by Maverick
• 10,820 points
1,615 views
+1 vote
2 answers
0 votes
1 answer

Trying to find frequent itemsets of a data set using arules package

Try replacing ID <- c("A123","A123","A123","A123","B456","B456","B456") item <- c("bread", "butter", "milk", ...READ MORE

answered Nov 15, 2018 in Data Analytics by Maverick
• 10,820 points
122 views
0 votes
1 answer

How to read a CSV file in R?

Hi@akhtar, You can read your CSV file in ...READ MORE

answered Oct 29 in Data Analytics by MD
• 77,580 points
15 views
0 votes
1 answer