This code opens a CSV file from the working directory set by wd. I copy
2 or more columns in the spreadsheet and then close it. What I need
help with is setting the first row as the column names in
clipboardTextAsDF. There is probably a simple or better way to do this
but I have been away from R for awhile now. I just be over-thinking this.
I tried read.DIF to read the clipboard but that didn't work as I had hoped.
writeClipboard(rownames(state.x77), format=1)
#A paste, Ctrl+V in any Application should now list United States State
names.
statex77 <- cbind(State=rownames(state.x77), state.x77)
wd <- "b:/Chapter11/"
setwd(wd) #Note use of "/" rather than "\"
write.csv(statex77, file="StateX77.csv", row.names=FALSE)
getwd()
StateX77CSV <- paste(wd,"StateX77.csv",sep="")
shell(StateX77CSV) #Might open Excel rather than QP
#data.entry(statex77) #Show statex77 in an interactive spreadhseet manner
clipboardText <- strsplit(readClipboard(format=1), "\t")
clipboardTextAsDF <- t(data.frame(clipboardText))
data.entry(clipboardTextAsDF)
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
