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.
