Read excel in r

#readxl Package
library(readxl)
##Read sheet One by One
read_excel("data.xlsx", sheet = 1,
          col_names = c("x", "y"), #Default col_names = T
          col_types = NULL, #Null means R will guess the type itself, 
           					#it can also take "text", "numeric", "date", "blank"
          skip = 0)

##All
lapply(excel_sheets("data.xlsx"), 
       read_excel,
       path = "data.xlsx")

##Getting Sheets name
excel_sheets("data.xlsx")

#gdata Package
##Default for xls file type only
##Require extra modules to read xlsx files
library(gdata)
read.xls("data.xls", sheet = 2)

### All sheet argument within this document could be also susbstituted with sheets' name

Import excel into R

library("openxlsx")
read.xlsx("Path_to_your_excel_file\\excel_file.xlsx")

Similar codes

1 vote128 views1 answer
R ddply
R
0 vote132 views1 answer
Non-redundant version of expand.grid
R
0 vote126 views1 answer
Plot two variables
R
0 vote120 views1 answer
Moving average in r
R
0 vote128 views1 answer
Generate all possible combinations of a set of characters r
R
1 vote117 views1 answer
Need R code
R
0 vote125 views1 answer
Delete variable from environment r
R
-2 votes122 views2 answers
What percentage of the row will the following column occupy on desktop devices: <div class="col-xs-3 col-sm-4 col-md-6 col-lg-12"></div>
R
1 vote131 views2 answers
R drop columns
R
1 vote110 views1 answer
Principal component analysis in r
R