search for: idx2cref

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...