Displaying 9 results from an estimated 9 matches for "sheet3".
Did you mean:
sheet
2013 Jul 16
2
Importing data by odbcConnectExcel in 64 bit
...probably an old question.
I have R.3.0.1 installed in 64 bit windows 7. The odbcConnectExcel in RODBC
library does not work. Tried odbcConnectExcel2007 still does not work.
Any ideas.
Thanks
Melissa<-sqlFetch(odbcConnectExcel2007("F:\\Cotton2012\\validation.xlsx"),sqtable
= "Sheet3",
+ na.strings = "NA", as.is = TRUE)
Error in sqlFetch(odbcConnectExcel2007("F:\\Cotton2012\\validation.xlsx"),
:
first argument is not an open RODBC channel
In addition: Warning messages:
1: In odbcDriverConnect(con, tabQuote = c("[", "...
2012 Mar 15
2
Importing multiple worksheets from one Excle/ csv file into R
...#39;ReadXls'
----------------
It would be great if anyone can let me know where the code went wrong and
any suggestion on how to load multiple sheets into R please??
If 'read.xls' works, I would think by setting 'sheet=c(1,2,3)' might do the
job, e.g. reading sheet1, sheet2 and sheet3, assuming sheet1, sheet2 and
sheet3 having same data structures, e.g. same number of columns and same
name of each columns. As there is no argument telling 'read.xls' how to
attach the data together if they are from multiple sheets, e.g. 'by row' or
by 'column', I still can...
2009 Sep 24
2
RODBC problem
...geTimeout=5
> tbls <- sqlTables(con)
> tbls
TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS
1 c:\\temp\\test <NA> Sheet1$ SYSTEM TABLE <NA>
2 c:\\temp\\test <NA> Sheet2$ SYSTEM TABLE <NA>
3 c:\\temp\\test <NA> Sheet3$ SYSTEM TABLE <NA>
Everything seems to be fine. Then I did
> qry <- paste("SELECT * FROM", tbls$TABLE_NAME[1], sep = ' ')
> qry
[1] "SELECT * FROM Sheet1$"
> sqlQuery(con, qry)
and got the error message
[1] "42000 -3506 [Microsoft][ODBC...
2003 Jul 21
1
RODBC: problem saving a new table in an "Excel database"
...eve, uses the Microsoft Excel Driver DSN). Then I try and save a new
table to the database(spreadsheet) using SqlSave, but obtain an error
message.
Below is some test code which reproduces the error (assuming that
c:\test.xls is a standard "blank" Excel spreadsheet; i.e. Sheet1,
Sheet2, Sheet3)
> con = odbcConnectExcel("c:\\test.xls")
> df = data.frame(x = rnorm(10), y = rnorm(10), z = letters[1:10])
> sqlSave(con, df)
Error in sqlSave(con, df) : [RODBC] ERROR: Could not SQLExecute
Where am I going wrong?
Thanks,
Dave
2012 Mar 31
1
Not getting correct graphs
...the following programme, as I am getting some Junk graphs in the pdf.
Please find the attached raw data file.
Thank you
Regards
Rayalu
library(ggplot2)
setwd("D:\\General Check list")
library(RODBC)
conn <- odbcConnectExcel ("Book1.xls")
Orange1 <- sqlFetch (conn, "Sheet3")
odbcClose(conn)
rm(conn)
#CDAI Change
unique(Orange1$BSCHSTAT) -> change
pdf("xxx.pdf")
for (j in 1:length(change)){
((Orange1$BASCHGAUT == "8-item scale")&(Orange1$BSCHSTAT == change[j])) -> b
FD <- Orange1[b, ]
unique(FD$REFID) -> refid
for (i in refid)...
2009 May 28
4
Read & name multiple excel sheets using RODBC
...lp or pointers
simeon
# long way
library(RODBC)
filepath <- "C:/Data/workbook.xlsx"
connect <- odbcConnectExcel2007(filepath)
tbls <- sqlTables(connect)
sheet1 <-sqlFetch(channel=connect,sqtable='sheet1')
sheet2 <-sqlFetch(channel=connect,sqtable='sheet2')
sheet3 <-sqlFetch(channel=connect,sqtable='sheet3')
.. etc
close(connect)
[[alternative HTML version deleted]]
2005 Aug 31
0
Reading numeric data in Excel as character data in R using RODBC
...a'
library(RODBC)
channel <-
odbcConnectExcel(paste(prj,"/intermediate/datafile.xls",sep=''))
r <- sqlTables(channel)
ifn.display <- sqlFetch(channel, "SHEET1")
il2.display <- sqlFetch(channel, "SHEET2")
pl.display <- sqlFetch(channel, "SHEET3")
odbcClose(channel)
Background: The current problem is small enough to solve with read.csv
but I expect to get larger problems in the future. My clients generally
give me data in Excel format. Sometimes I get multiple character
indicators for different kinds of non-numeric results. Sometimes...
2007 Mar 23
6
Updating a worksheet in Excel file using RODBC
Hello!
I have no problem reading Excel files (each worksheet in the file is a "table" which can be read - at least in my case).
What I would like to do is to read such a table, change it (just the contents, not the format) and write it back, and this I can not do. I am getting the following error messages (3 slightly different attempts):
> sqlSave(con, x, tablename =
2010 Feb 23
5
export tables to Excel files
Dear R users,
I've just posted a similar question about Illustrator.
This time I would like to export the results of my statistic tables and
my dataframes into Excel files.
Up to now I've used write.csv(), but I have to resave every file in .xls
in Excel.
I would like to know if there is a function or package to export
directly into *.xls.
I have found xlsReadWrite which would be