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

5 votes449 views2 answers
R load packages
R
0 vote164 views1 answer
Utils vs readr and fread
R
2 votes167 views1 answer
Create a table from dataframe in r
R
0 vote147 views3 answers
Del row matrix r
R
0 vote163 views1 answer
R make column of rownames
R
0 vote150 views1 answer
Kable thousand mark
R
1 vote149 views2 answers
Figure caption in r markdown
R
0 vote92 views1 answer
Switch variable position in r dplyr
R
0 vote146 views1 answer
Digits in format and formatc in r
R
0 vote218 views1 answer
Switch to another line in string r
R