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 vote378 views1 answer
Null count in r
R
0 vote400 views1 answer
Pass argument to group_by (2)
R
1 vote385 views1 answer
Add a vertical line in ggplot
R
0 vote391 views1 answer
Ggplot glm
R
0 vote389 views3 answers
Turn row names into column in r
R
0 vote350 views1 answer
Number of days in a data set in r
R
0 vote395 views1 answer
Calculating RMSE, MAE, MSE, Rsquared manually in R
R
1 vote404 views1 answer
How to transform days in years R
R
0 vote373 views1 answer
Regex last word in string r
R
3 votes395 views4 answers
How to read csv file in r
R