read xlsx in r
require(xlsx)
read.xlsx("myfile.xlsx", sheetName = "Sheet1")
read.xlsx2("myfile.xlsx", sheetName = "Sheet1")
4.33
3
require(gdata)
df = read.xls ("myfile.xlsx"), sheet = 1, header = TRUE)
Thank you!
3
0
4
5
require(xlsx)
coln = function(x) { # A function to see column numbers
y = rbind(seq(1, ncol(x)))
colnames(y) = colnames(x)
rownames(y) = "col.number"
return(y)
}
data = read.xlsx2("myfile.xlsx", 1) # open the file
coln(data) # check the column numbers you want to have as factors
x = 3 # Say you want columns 1-3 as factors, the rest numeric
data = read.xlsx2("myfile.xlsx", 1,
colClasses = c(rep("character", x), rep("numeric", ncol(data)-x+1))
)
Thank you!
5
0
5
3
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
Thank you!
3
0
4.1
10
my_data <- read.table(file = "clipboard",
sep = "\t", header=TRUE)
Thank you!
10
0
4
1
# Loading
library("readxl")
# xls files
my_data <- read_excel("my_file.xls")
# xlsx files
my_data <- read_excel("my_file.xlsx")
Thank you!
1
0
Are there any code examples left?
New code examples in category R
-
R 2022-03-27 14:00:12 R total line text file
-
R 2022-03-27 13:40:24 reduce ggtitle size
-
R 2022-03-23 02:05:30 r merge inner join
-
R 2022-03-21 19:20:02 combine columns in r
-
R 2022-03-16 11:05:16 ggplot box plot without outliers poins
-
R 2022-03-13 03:05:04 calculated defualt values in R function parameters
-
R 2022-03-12 21:55:01 r rename columns
-
R 2022-03-08 02:25:18 r - transform as factor
-
R 2022-03-06 02:50:06 create a dataframe with column names in r