Displaying 4 results from an estimated 4 matches for "hoja1".
Did you mean:
hoja
2005 Apr 26
2
writing a data frame in excel format
...g the
RODBC library, but I don't know how write a R data frame in excel
format. I don't understand the instructions from RODBC user manual.
To read an excel file I use.
library(RODBC);
conex<-odbcConnectExcel("fis_quim.xls");
sqlTables(conex);
data<-sqlFetch(conex,"hoja1");
Suppose I modify data and I want to save it as an excel file, How do
I do that?
Thanks for your help
Mario Alfonso Morales Rivera
Profesor Auxiliar.
Departamento de Matem??ticas y Estadistica.
Universidad de C??rdoba.
2004 Apr 03
1
Re: R-help Digest, Vol 14, Issue 3
...)but i don't
>understand 2 mistake
>1) Don't read the last row of the table excell
>2) Don' t take the hours
See below
>My excell file call prueba4.xls and have the following rows:
>where prueba4.xls was make in excell (office xp) and have one spreadsheet
>call "Hoja1", you see each rows of she:
>D??a Hora col1 col2 col3 col4 col5 col6 col7 col8
>15/12/2003 12:14:59 217 2760 8,2 35 79,6 86,4
>15/12/2003 12:15:00 217 2764 8,2 35 79,6 86,4
>15/12/2003 12...
2004 Apr 02
1
convert excell file to text with RODBC package
...l to list in R with package RODBC ()but i don't
understand 2 mistake
1) Don't read the last row of the table excell
2) Don' t take the hours
My excell file call prueba4.xls and have the following rows:
where prueba4.xls was make in excell (office xp) and have one spreadsheet
call "Hoja1", you see each rows of she:
D??a Hora col1 col2 col3 col4 col5 col6 col7 col8
15/12/2003 12:14:59 217 2760 8,2 35 79,6 86,4
15/12/2003 12:15:00 217 2764 8,2 35 79,6 86,4
15/12/2003 12:15:01 217 2758 8,3 35 79,6 86,4
15/12/2003 12:15:02 217 2760 8,3 35 79,6 86,4
15/12/2003 12:15:03 217 2755 8,3...
2010 Aug 20
0
Resumen de R-help-es, Vol 18, Envío 8
...;>
>> Te sugiero usar RODBC a traves de la siguiente funcion, donde "yourfile" es
>> el nombre del archivo de Excel, incluyendo la ruta., e.g. "C:/datos/aa.xls"
>> y "worksheet" corresponde a la hoja donde tienes la informacion, e.g.
>> "Hoja1".
>>
>> # From Excel
>> FromExcel <- function(yourfile,worksheet){
>> require(RODBC)
>> channel <- odbcConnectExcel(yourfile)
>> mydata <- sqlFetch(channel, worksheet)
>> odbcClose(channel)
>> attach(mydata)
>> mydata
>>...