Displaying 1 result from an estimated 1 matches for "addres2".
Did you mean:
address
2011 May 30
0
Question of the XLConnect package
...1]],":",col1idx[[2]],sep="")
createName(wb,name="Var1",formula=paste("testdata!",addres1,sep=""))
# repeat for column 2
col2idx=idx2cref(c(2,grep("Var2",names(testdata)), 1+length(testdata$Var2),
grep("Var2",names(testdata))))
addres2=paste(col2idx[[1]],":",col2idx[[2]],sep="")
createName(wb,name="Var2",formula=paste("testdata!",addres2,sep=""))
createSheet(wb,"results") # a place to test if the named regions can be used
within excel
ave="=AVERAGE(Var2)"
s...