Read xlsx in r

Open xlsx r

# Loading
library("readxl")
# xls files
my_data <- read_excel("my_file.xls")
# xlsx files
my_data <- read_excel("my_file.xlsx")

Source: sthda.com

Read xlsx in r

 
require(RODBC)
conn = odbcConnectExcel("myfile.xlsx") # open a connection to the Excel file
sqlTables(conn)$TABLE_NAME # show all sheets
df = sqlFetch(conn, "Sheet1") # read a sheet
df = sqlQuery(conn, "select * from [Sheet1 $]") # read a sheet (alternative SQL sintax)
close(conn) # close the connection to the file

Source: milanor.net

Open xlsx with r

my_data <- read.table(file = "clipboard", 
                      sep = "\t", header=TRUE)

Similar codes

0 vote353 views5 answers
Layar names in R worldclim
R
0 vote301 views1 answer
Turn a numeric dataframe to binary in r
R
0 vote335 views1 answer
Extract rse from lm in r
R
5 votes519 views6 answers
Rename column in r
R
0 vote353 views1 answer
Count certain number of alphabets in a string r
R
0 vote345 views1 answer
L in r
R
0 vote371 views1 answer
R total line text file
R
0 vote344 views1 answer
R remove insignificant coefficient in output
R
0 vote330 views1 answer
Import excel into R
R
1 vote369 views1 answer
Remove rows in r based on row number using dplyr
R