Displaying 20 results from an estimated 5000 matches similar to: "Excel *.xls files, RODBC"
2003 Oct 22
2
Excel to R
I have Excel files containing data that I would like to move to R.
They are in the standard form of a one row header followed by
rows of data, one record per row EXCEPT that there are a few
rows of comments before the header. The number of rows of comments
varies. For Excel files of this form without comments I have had
success with:
require(RODBC)
z <-
2007 Mar 06
2
Package RODBC
I have some questions about the RODBC package.
library(RODBC) # required for those who want to repeat these lines
1st, I noticed that the following sequence does not work:
channel <- odbcConnextExcel("test.xls")
tables <- sqlTables(channel)
name1 <- tables[1, "TABLE_NAME"] # this should be the name
plan1 <- sqlFetch(channel, name1) # bang!
2014 Aug 15
5
leer ficheros excel en R en Ubuntu
Hola,
@javier, me gustaría no tener que hacer nada de forma manual, ni por fuera
de r, rstudio. Es decir, el típico comando de linux que me convierta de xls
a csv prefiero no usarlo. Me gustaría hacerlo todo desde R.
@jorge ->
Con RODBC me salta ->
Error: could not find function "odbcConnectExcel"
Lo que creo que es inevitable en Ubuntu
2014 Aug 14
3
leer ficheros excel en R en Ubuntu
Hola,
Pensé que esto iba a ser trivial en R, pero me estoy encontrado muchos con
mi problema en internet, y que las soluciones ofrecidas no terminan de
funcionar.
Estoy intentando leer un fichero .xls en ubuntu con los siguientes paquetes
y nada:
require(RODBC)
conn = odbcConnectExcel("madrid.xls") # open a connection to the Excel file
sqlTables(conn)$TABLE_NAME # show all sheets
df =
2010 Feb 23
1
RODBC to import/export xls files
Dear R users,
I've learned today about RODBC package in order to import xls file to
dataframes and export the dataframes to xls files.
However I have some problems. Please excuse me if these are basic but as
I said, I've just begun with this package.
Also this email is quite long, but everything is related, so I don't
think it would be better to split it. Moreover, there's a
2012 May 20
4
write.xls
Hello, All:
The "writeFindFn2xls" function in the "sos" package tries to
write an Excel file with 3 sheets ('PackageSum2', 'findFn', 'call').
Unfortunately, it is often unable to do this because of configuration
problems that are not easy to fix. I've found 3 contributed packages
that provide facilities to write Excel files with
2009 Apr 07
4
Re ading Excel 5.0 files with RODBC?
Hi,
i'm trying to read some data from excel files but it seems that neither
xlsReadWrite nor sqlFetch (RODBC) doesn't like the format (Excel 5.0).
When i open the file in Excel and save it in a new format Excel 97 -2003
everything works fine.
Is it possible to use ODBC connection to open old format files, or i guess i
will have to open and save every file in Excel in new format, which
2006 Dec 07
2
How to use read.xls in R
Hello there,
In gdata package, read.xls is to be used for reading excel data (from
windows).
The following is my code:('C:/session/sampledata.xls' is where the file
is stored)
data1<-read.xls('C:/session/sampledata.xls',sheet=1)
and I got the following error message:
Error in system(cmd, intern = !verbose) : perl not found
Could you please tell me what I have done wrong and
2014 Aug 15
2
leer ficheros excel en R en Ubuntu
Gracias Jorge por contestar tan rápido.
Con gdata hago eso del path, y directamente con el fichero, lo vi en una
web, y he intentado todas las opcioens que he visto.
En vez de install.packages('rJava', type = 'source')
he hecho install.packages('rJava')
Ahora probaré, y lo mismo con scan y readLines.
He visto en stackoverflow que mi problema puede ser actualizar java,
2003 Mar 13
2
RODBC and Excel in Widows
Hello, I have some problems with RODBC and Excel in Win98
I am using R 1.6.2 and just upgraded RODBC to the last version on CRAN.
I have an Excel file with columns Number, Name, Sex, Age, FEV1 on Sheet
1 and Number, Age, FEV1, Name, Sex on Sheet 2.
Now I open the channel to the file
> chan1 <- odbcConnectExcel("c:/testOdbc.xls")
> tables(chan1)
and the list appears with the 2
2007 May 24
1
"[RODBC] ERROR: Could not SQLExecDirect"
Hi, everyone,
I try to run as follows:
Z>library("RODBC")
Z>cnct<-odbcConnectExcel("Forbes2000.xls")
Z>cnct
RODB Connection 1
Details:
case=nochange
DBQ=C:\Program Files\R\R-2.5.0\Forbes2000.xls
DefaultDir=C:\Program Files\R\R-2.5.0
Driver={Microsoft Excel Driver (*.xls)}
DriverId=790
MaxBufferSize=2048
PageTimeout=5
Z>sqlQuery(cnct, "select
2014 Aug 15
2
leer ficheros excel en R en Ubuntu
offline? te lo envío a tu email, pq no creo que a toda la lista sea buena
idea.
El 15 de agosto de 2014, 9:47, Jorge I Velez <jorgeivanvelez en gmail.com>
escribió:
> De nada, Miguel. Es posible que me envies el archivo offline? --JIV
>
>
>
> 2014-08-15 17:45 GMT+10:00 Miguel Fiandor Gutiérrez <
> miguel.fiandor.gutierrez en gmail.com>:
>
> Gracias
2009 Nov 16
3
Error on reading an excel file
Hello everybody, here is the code I use to read an excel file containing two
rows, one of date, the other of prices:
library(RODBC)
z <- odbcConnectExcel("SPX_HistoricalData.xls")
datas <- sqlFetch(z,"Sheet1")
close(z)
It works pretty well but the only thing is that the datas stop at row 7530
and I don?t know why datas is a data frame that contains 7531 rows with the
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,
2005 Nov 02
2
RODBC and Excel: Wrong Data Type Assumed on Import
The first column in my Excel sheet has mostly numbers but I need to treat it
as character data:
> library(RODBC)
> channel <- odbcConnectExcel("U:/efg/lab/R/Plasmid/construct list.xls")
> plasmid <- sqlFetch(channel,"Sheet1", as.is=TRUE)
> odbcClose(channel)
> names(plasmid)
[1] "Plasmid Number" "Plasmid"
2006 Feb 23
4
read file of EXCEL format
Hello sir:
How can I read data file of EXCEL format from disk("d:\\data.XLS" for example)?
I can only read data file of .txt format
read.delim("d:\\data.txt",header=T,as.is=T),but only EXCEL format is available at present.
Thanks a lot
2005 Dec 31
1
r: RODBC QUESTION
hello all
i have a quick question. i have been using the RODBC library (trying to
read Excel data
into R but i am doing this by using Rexcel. this is probably not the
correct forum -
sorry for this).
my code is shown below:
Sub A()
'start the connection to R
Call RInterface.StartRServer
RInterface.RRun "library(RODBC)"
RInterface.RRun "A =
2006 Jul 12
1
RODBC, missing values, and Excel
Hi, all,
I'm trying to use RODBC to read data from Excel. However, I'm having
trouble converting missing values to NA and rather perplexed by the
output. Below illustrates my problem:
## DATA - copy to Excel and save as "tmp.xls"
## tmp.xls!Sheet1
x
0.11
0.11
na
na
na
0.11
## tmp.xls!Sheet2
x
0.11
0.11
na
na
na
na
0.11
## R Code
read.xls <- function(file, sheet =
2013 Jul 16
2
Importing data by odbcConnectExcel in 64 bit
I have 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
2009 Jan 18
6
read a xls file
Hello,
i have a xls file. I will read it in r, what library-command i use for
this??
any ideas??
Thanks
Michele
[[alternative HTML version deleted]]