[R] Can't read xlsx file into R. Seem, Seem to have XLConnect loaded.

[Jim Holtman]

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 <mikehilt21 at 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
> 
> mikehilt21 at gmail.com
> 
>    [[alternative HTML version deleted]]
> 
> ______________________________________________
> R-help at 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.