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

Tim Bates timothy.c.bates at gmail.com
Wed Sep 23 16:22:28 CEST 2015


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.



More information about the R-sig-teaching mailing list