Displaying 1 result from an estimated 1 matches for "pathtomyexcelfile".
2008 Oct 26
1
Transferring results from R to MS Word2
Tom:
Supposse your Excel file is named "myExcelFile"
Open myExcelFile and SaveAs "myExcelFile.csv" or "myExcelFile.txt"
Then go to the RConsole and type:
#Option # 1
mydata <- read.csv("PathTomyExcelFile.csv",header=T)
mydata
# You should be able to see your dataset in R
# Option # 2
# If you saved your Excel file as text then you would do:
mydata <- read.table("PathTomyExcelFile.txt",header=T,sep="\t")
mydata
# Option # 3
# If you want to leave your workbook as Excel f...