Displaying 2 results from an estimated 2 matches for "cdb_frame".
2012 Aug 01
2
Why the result is coming as NULL?
Why the result is coming as NULL. Can anyone help. I want to find the outliers for a reference
setwd("D:/AZ")
library("RODBC")
cdb_cnct <- odbcConnectExcel("Book1.xls")
cdb_frame <- sqlFetch(cdb_cnct, "Sheet1")
odbcClose(cdb_cnct)
rm(cdb_cnct)
x<- cdb_frame$Publication >=1990 & cdb_frame$Publication <=2012
invalid <- cdb_frame[!x, c("Reference")]
invalid
________________________________
Notice: The information contained in this elect...
2012 Aug 01
1
Why the error is coming while extracting the data from sheet?
Even though the sheet name Publication exists. The error is coming.
Can anyone help?
library("RODBC")
cdb_cnct <- odbcConnectExcel("Copy of AZIF_DC_GVK_NSCLC_MSALL_287papers_02072012_141450_v1_4.xls")
cdb_frame <- sqlFetch(cdb_cnct, "Publication")
odbcClose(cdb_cnct)
Error in odbcTableExists(channel, sqtable) :
'Publication': table not found on channel
rm(cdb_cnct)
________________________________
Notice: The information contained in this electronic mail message is intended only f...