I have spent hours on R in Windows 7. Just installed 2 days ago so the R
package should be current.
Currently I am using the RGui (64-bit) for Windows.
I can not read an Excel file into R from my computer. Have hours on this.
Completely crazy!!
I have the XLConnect package loaded. I think it is loaded because when I
enter:
> loadedNamespaces()
[1] "base" "datasets" "graphics" "grDevices"
[5] "methods" "rJava" "stats" "tools"
[9] "utils" "XLConnect" "XLConnectJars"
XLConnect is listed. Does that mean it is loaded?
> getwd()
[1] "F:/RwkCB3/R OG SBCD 1205v01"
> list.files()
[1] "~$ R OG SBCD 1205 MH1.docx" "~WRL2121.tmp"
[3] "01 R OG SBCD 1205 MH1 BU1.docx" "01 R OG SBCD 1205 MH1.docx"
[5] "01 R OG SBCD 1205v01 BU2" "Dta1.txt"
[7] "Gas Dly YTD1204 v01 BU.xlsm" "Gas Dly YTD1204 v01.xlsm"
[9] "Oil Dly YTD1204 v01 BU.xlsm" "Oil Dly YTD1204 v01.xlsm"
[11] "Oil Dly YTD1204 v01.xlsx" "R OG SBCD 1205v01 sCt.lnk"
[13] "R setwd to C Prog R sCt OtDt.lnk"
So apparently "Oil Dly YTD1204 v01.xlsx" exists in my working directory.
SO WHY DOES THE FOLLOWING BEHAVE THE WAY IT DOES?
> OlPrcFl <- loadWorkbook(Oil Dly YTD1204 v01.xlsx, create = FALSE)
Error: unexpected input in "OlPrcFl <- loadWorkbook("
I can read an xlsx file in when I do:
> OlPrcFl <- loadWorkbook(file.choose())
That is not a real, long-term solution.
Have same problem installing packages -- Can't get R to load a package when
I specify a path. Works when I use file.choose()
I would really appreciate it if you could tell me what is going on.
Thanks,
Mike Hilt
mikehil...@gmail.com
[[alternative HTML version deleted]]
______________________________________________
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.
