Sarah, it seems your current directory is not where your LTS.xls file is
located.
What I would is the following:
always use the xlsReadWrite functions in the current directory where your
excel file is located
Also, just reaad the ENTIR excel sheet, rather than referencing columns.
This the simplest way and it has ALWAYS worked for me.
e.g. STI<-read.xls('STI_CASES.xls',sheet=1)
And I have my data, now I have to work a bit to get what I want (e.g. cases
for a certain year ect), but that is doable.-- View this message in context: http://r.789695.n4.nabble.com/help-to-import-the-data-from-Excel-tp3893382p4015392.html Sent from the R help mailing list archive at Nabble.com. ______________________________________________ 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.
