Displaying 20 results from an estimated 1300 matches similar to: "Writing a data frame in an excel file"
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
2009 Nov 20
2
Problem at adding lines on a graphics with lines() function
Hello, I am trying to plot a graphic with many lines with the following
command:
plot(datas[1:n,1],datas[1:n,2],type="l",main="SP500 Prices and Moving
Averages",xlab="Date",ylab="Prices",col="black")
lines(datas[1:n,1],datas[1:n,3],type="l",col="green",lty="solid")
But I just see the first curve. I have tried it on
2009 Nov 18
1
Creating an excel file and manipulating it from R
Hello everybody, I?ve been looking for a function that would create an excel
file in my working directory where I would write my dataframe but I only
found the functions to write or read in an existing file that you gave me on
my former post or on some websites. I can?t find either functions to
manipulate those datas: for example, I would like some lines to be red or
green according to their
2009 Nov 19
1
Problem with sqlSave
Hello, the sqlSave function is used in order to write a dataframe on excel.
This function creates worksheets using the attribute tablename and writes
the data.frame in it. What I want to do is to create this data.frame but
being able in case this worksheet already exists to delete the former datas
and write the new ones in it. I used the safer and append attributes. When
you set safer to false,
2009 Aug 18
2
(no subject)
Dear all,
I have a problem with the function read.xls from the gdata package, error message see below. Two examples:
First, I try to read my data, which does not work;
Secondly, I tried the example code/data with the Iris data, which worked
Any idea?
Thanks,
Lars
> path<-"I:/subProjects/bh/HPGD/"
>
> setwd(path)
>
> xls <- "Platten_Liste_090421.xls"
2010 Jun 16
2
Reading data from xls..........please help
Can anyone help me how to read xls file into R. I have tried following
library(gdata)
xlsfile <- file.path(.path.package('gdata'),'xls','iris.xls')
read.xls(xlsfile)
I got following error:
Converting xls file to csv file... Error in system(cmd, intern = !verbose) :
perl not found
Error in file.exists(tfn) : invalid 'file' argument
Question *1) What is the way
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
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 =
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
2010 Jul 22
1
64 bit use of odbcConnectExcel
Hi All,
I'm using R 2.11.1 on 64 bit windows XP. The little function I wrote below
I use often to import the first 1001 lines in an excel sheet to R. This
works fine on the 32 bit version of R but fails on the 64 bit [both on the
same machine, using the same function, importing the same .xls file]. The
message from 64 bit R is:
Error in sqlTables(channel1) :
first argument is not an
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
2010 Feb 24
1
problem with sqlSave()
Dear R users,
I've already asked this question yesterday, but, though I had answer for
the other ones (and they helped a lot, thanks), for some reason didn't
get an answer for this one (I would also appreciate to know why, so that
I can improve the quality and clarity of my future questions).
Here it is again:
I'm trying to use RODBC to export dataframes to xls files.
When I run
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,
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
2015 Oct 21
3
Crear variable con condiciones
Muchas gracias Javier por tu respuesta.
Si. Para obtener "dataout" se utilizan filas anteriores de acuerdo con la
disponibilidad de la variable TOENDREF para cada valor de la variable REF.
Por ejemplo, las filas 3 y 4 de "datain" son
#REF TIMEREF TOENDREF
#3 999 360 150
#4 1099 30 480
En la fila 3, el valor de TOENDREF es 150. Esto indica que hay 150
2010 Mar 25
4
Convert number to Date
Hello, I have a date value in excel: 1/4/2010 which in number format gives me
40182. When I read this with read.xls from R I get same 40182 so what I do
is that I use the as.Date() function but here is what the as.Date() function
returns me:
> as.Date(40182)
[1] "2080-01-06"
Why don't I get the same thing as in excel?
Thanks!
-----
Anna Lippel
--
View this message in context:
2015 Oct 20
2
Crear variable con condiciones
Buenas tardes a todos,
Quisiera crear una variable de acuerdo a ciertas condiciones. Me gustaria
llegar de "datain" a "dataout".
## entrada
datain <- structure(list(REF = c("999", "999", "999", "1099", "731", "731",
"731", "731", "1442", "1442", "1442",
2009 Nov 13
4
Simple if else statement problem
Hello, I am getting an error with the following code:
if( P2 > P1)
+ {
+ P<-P2
+ }
> else
Erro: unexpected 'else' in "else"
> {
+ P<-P1
+ }
I checked the syntax so I don?t understand, I have other if else statements
with the same syntax working. Thanks in advance
--
View this message in context:
2010 Mar 03
5
filtering signals per day
Hello R lovers,
I have a vector of dates and signals. I want to filter the signals per day
in a way that only the first signal of the day remains like this:
Dates Signals Filtered Signal
2006-11-02 0 0
2006-11-02 1 1
2006-11-02 0 0
2006-11-02 1 0
2006-11-02 1
2009 Nov 13
4
Change working directory
Hello, I am using setwd() to change the working directory but I have to enter
it everytime I open R, is there a way to set this permanently as a working
directory? Thanx =^D
--
View this message in context: http://old.nabble.com/Change-working-directory-tp26337486p26337486.html
Sent from the R help mailing list archive at Nabble.com.