Advertisement
Guest User

Untitled

a guest
Oct 9th, 2015
115
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.35 KB | None | 0 0
  1. path<-"C:/test/"
  2. files<-list.files(path=path)
  3. j<-1
  4. for (i in files){
  5. name<-strsplit(i,'[.]')[[1]][1]
  6. assign(name,read.xlsx(file=paste(path,i,collapse=NULL,sep=""),sheetIndex=1,header=TRUE,as.data.frame=TRUE))
  7. files[j]<-name
  8. j<-j+1
  9. }
  10.  
  11. result=xts(nasa[,-1],order.by=as.POSIXct(strptime(a[,1],'%y/%d/%m')))
  12.  
  13. colnames(result)=colnames(name)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement