How to read data from an Excel .xlsx file in R

To read directly from a .xlsx in the same directory as your R script:

> data <- read.xlsx(“yourdata.xlsx”)

… or …

To read from a workspace directory containing a .xlsx file:

> wdir = “C:/workspace/yourdirectory”
> data <- read.xlsx(paste(wdir, “yoursubdirectory”, “yourdata.xlsx”, sep=“/”))

… or …

To read from the second sheet of a .xlsx workbook:

> wdir = “C:/workspace/yourdirectory”
> data <- read.xlsx(paste(wdir, “yoursubdirectory”, “yourdata.xlsx”, sep=“/”), sheet = 2)

 
0
Kudos
 
0
Kudos

Now read this

How to display the IPv6 Neighbor Discovery Table in Windows

To display the Neighbor Discovery Table (ND Table) in Windows enter the following into the command prompt: > netsh interface ipv6 show neighbors On your local machine, windows maps IPv6 addresses to physical addresses (MAC addresses)... Continue →