Displaying 1 result from an estimated 1 matches for "addres1".
Did you mean:
address
2011 May 30
0
Question of the XLConnect package
...t(wb,"testdata") # create sheet
writeWorksheet(wb,testdata,sheet="testdata") # write data to sheet
# Create named regions named the column names
col1idx=idx2cref(c(2,grep("Var1",names(testdata)), 1+length(testdata$Var1),
grep("Var1",names(testdata)))) #
addres1=paste(col1idx[[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",name...