Hi Michele, there are at least two good alternatives. xlsReadWrite (read only xls) RODBC (the one I prefer, read xls and xlsx), odbcConnectExcel (read xls) and odbcConnectExcel2007 (read xlsx). The libraries help files bring to you better details.
Here are some examples of file importing (the setwd() is not an obligation): Library(RODBC) setwd('C:/Documents and Settings/Administrador/Meus documentos/UFPR/Micropaleontologia/Potiguar/Monitoramento/Abril2008/') Data<-odbcConnectExcel('ANOVA-Monit2008.xls',readOnly=T,) AbioRep<-sqlFetch(Data,'AmbienteRep',colnames=F,rownames='Sample') AbioMed<-sqlFetch(Data,'AmbienteMed',colnames=F,rownames='Sample') IndiecesFV<-sqlFetch(Data,'Indices-FV',colnames=F,rownames='Sample') IndiecesFT<-sqlFetch(Data,'Indices-FT',colnames=F,rownames='Sample') odbcClose(Dados) library(xlsReadWrite) setwd('C:/Documents and Settings/Administrador/Meus documentos/Artigos/Disserta/') Abio<-read.xls('AF.xls',sheet=1,rowNames=T) Bio<-read.xls('AF.xls',sheet=2,rowNames=T) SAbio<-decostand(Abio,method='standardize') Hope it helps ___________________________________ MSc. Rodrigo Aluizio Centro de Estudos do Mar/UFPR Laboratório de Micropaleontologia Avenida Beira Mar s/n - CEP 83255-000 Pontal do Paraná - PR - BRASIL Fone: (0**41) 3455-1496 ramal 217 Fax: (0**41) 3455-1105 -----Mensagem original----- De: r-help-boun...@r-project.org [mailto:r-help-boun...@r-project.org] Em nome de Michele Santacatterina Enviada em: domingo, 18 de janeiro de 2009 12:16 Para: R-help@r-project.org Assunto: [R] read a xls file Hello, i have a xls file. I will read it in r, what library-command i use for this?? any ideas?? Thanks Michele [[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.