does your quoted filename have "smart" quotes? are you using WORD to create your scripts?
Sent from my iPad On May 9, 2012, at 18:38, Mike Hilt <mikehil...@gmail.com> wrote: > 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. ______________________________________________ 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.
