[R-sig-teaching] Read *.xlsx data file into R

Hadley Wickham h.wickham at gmail.com
Wed Sep 23 19:27:57 CEST 2015


Note that gdata::read.xls requires perl, which can be a hassle to install.
Hadley

On Wed, Sep 23, 2015 at 9:22 AM, Tim Bates <timothy.c.bates at gmail.com> wrote:
> your question is vague.
>
> For those who need to read xlsx files, I’ve been having great results with the “gdata” package, and it’s cross platform.
>
> # simple at its easiest
> df <- gdata::read.xls(xls = “~/Desktop/194.xlsx”)
>
> # and powerful options also:
>
> df <- gdata::read.xls(xls = ,sheet=,pattern=,na.strings=,method=,perl=)
>
> tim
>
>> David
>>
>>> On Sep 23, 2015, at 10:02 AM, Steven Stoline <sstoline at gmail.com> wrote:
>>> Dear All:
>>> I am having trouble reading an  *.xlsx data file into R.
>>> I tried to install the packages XLSX and readx1, but still did not work.
>>> Any helps will be appreciated.
>
> _______________________________________________
> R-sig-teaching at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-sig-teaching



-- 
http://had.co.nz/



More information about the R-sig-teaching mailing list