Displaying 2 results from an estimated 2 matches for "excelcohortdata_men_reference".
2010 May 04
1
strange behavior of RODBC and/or ssconvert
...sing the RODB package, the
data is now complete.
Any idea what to do about that? My main problem is to get the
spreadsheetML into R so I tried other file formats to which ssconvert
can convert to, but only excel supports multisheets.
Best,
Stefan
Example code:
system(paste('ssconvert "excelcohortdata_men_reference scenario.xml"
"excelcohortdata_men_reference scenario22.xls"'))
channel1<-odbcConnectExcel("excelcohortdata_men_reference scenario10.xls")
odbcGetInfo(channel1)
sqlTables(channel1)
sqlQuery(channel1, "select * from \"age 9in 2010$\"" )
sqlFetch(ch...
2010 May 05
0
R-help Digest, Vol 87, Issue 5
...sing the RODB package, the
data is now complete.
Any idea what to do about that? My main problem is to get the
spreadsheetML into R so I tried other file formats to which ssconvert
can convert to, but only excel supports multisheets.
Best,
Stefan
Example code:
system(paste('ssconvert "excelcohortdata_men_reference scenario.xml"
"excelcohortdata_men_reference scenario22.xls"'))
channel1<-odbcConnectExcel("excelcohortdata_men_reference scenario10.xls")
odbcGetInfo(channel1)
sqlTables(channel1)
sqlQuery(channel1, "select * from \"age 9in 2010$\"" )
sqlFetch(ch...