Sri krishna Devarayalu Balanagu
2012-Aug-01 09:48 UTC
[R] 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 for the use of the designated recipient. This message is privileged and
confidential. and the property of GVK BIO or its affiliates and subsidiaries. If
the reader of this message is not the intended recipient or an agent responsible
for delivering it to the intended recipient, you are hereby notified that you
have received this message in error and that any review, dissemination,
distribution, or copying of this message is strictly prohibited. If you have
received this communication in error, please notify us immediately by telephone
+91-40-66929999<tel:%2B91-40-66929999> and destroy any and all copies of
this message in your possession (whether hard copies or electronically stored
copies).
Jeff Newmiller
2012-Aug-01 12:52 UTC
[R] Why the error is coming while extracting the data from sheet?
We cannot help you if you don't give us enough information to do so. Please
use the dput function to give us a copy of your "cdb_frame" as others
have already requested.
You may also find the str function helpful in diagnosing your own problems.
---------------------------------------------------------------------------
Jeff Newmiller The ..... ..... Go Live...
DCN:<jdnewmil at dcn.davis.ca.us> Basics: ##.#. ##.#. Live
Go...
Live: OO#.. Dead: OO#.. Playing
Research Engineer (Solar/Batteries O.O#. #.O#. with
/Software/Embedded Controllers) .OO#. .OO#. rocks...1k
---------------------------------------------------------------------------
Sent from my phone. Please excuse my brevity.
Sri krishna Devarayalu Balanagu <balanagudevarayulu at gvkbio.com> wrote:
>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 for the use of the designated recipient. This message is
>privileged and confidential. and the property of GVK BIO or its
>affiliates and subsidiaries. If the reader of this message is not the
>intended recipient or an agent responsible for delivering it to the
>intended recipient, you are hereby notified that you have received this
>message in error and that any review, dissemination, distribution, or
>copying of this message is strictly prohibited. If you have received
>this communication in error, please notify us immediately by telephone
>+91-40-66929999<tel:%2B91-40-66929999> and destroy any and all copies
>of this message in your possession (whether hard copies or
>electronically stored copies).
>______________________________________________
>R-help at r-project.org mailing list
>https://stat.ethz.ch/mailman/listinfo/r-help
>PLEASE do read the posting guide
>http://www.R-project.org/posting-guide.html
>and provide commented, minimal, self-contained, reproducible code.