Displaying 1 result from an estimated 1 matches for "idx2cref".
2011 May 30
0
Question of the XLConnect package
...a.xlsx", create = TRUE) # create a workbook
testdata=expand.grid(letters[1:10], 1:10) # create some data
createSheet(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...