Displaying 2 results from an estimated 2 matches for "col2idx".
2011 May 30
0
Question of the XLConnect package
...("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",names(testdata))))
addres2=paste(col2idx[[1]],":",col2idx[[2]],sep="")
createName(wb,name="Var2",formula=paste("testdata!",addres2,sep=""))
create...
2013 Apr 23
1
Questions on function "readNamedRegionFromFile" in XLConnect pacakge
Hi,
I have two questions on the function "readNamedRegionFromFile" in
XLConnect pacakge.
1.
In the documentation,
# multiregion xlsx file from demoFiles subfolder of package XLConnect
demoExcelFile <- system.file("demoFiles/multiregion.xlsx",
package = "XLConnect")
# Load a single named region into a single data.frame.
df