Displaying 2 results from an estimated 2 matches for "hoja2".
Did you mean:
hoja
2004 Apr 02
1
convert excell file to text with RODBC package
...he following:
library(RODBC)
> canal<-odbcConnectExcel("c:/prueba4.xls")
> tablas<-sqlTables(canal)
> tablas
TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS
1 c:\\prueba4 <NA> Hoja1$ SYSTEM TABLE <NA>
2 c:\\prueba4 <NA> Hoja2$ SYSTEM TABLE <NA>
3 c:\\prueba4 <NA> Hoja3$ SYSTEM TABLE <NA>
> tbl<-sqlFetch(canal,substr(tablas[1,3],1,nchar(tablas[1,3])-1))
> tbl[1]
D??a
1 2003-12-15 00:00:00
2 2003-12-15 00:00:00
3 2003-12-15 00:00:00
4 2003-12-15 00:00:00
5 2003...
2004 Apr 03
1
Re: R-help Digest, Vol 14, Issue 3
...C)
> > canal<-odbcConnectExcel("c:/prueba4.xls")
> > tablas<-sqlTables(canal)
> > tablas
> TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS
>1 c:\\prueba4 <NA> Hoja1$ SYSTEM TABLE <NA>
>2 c:\\prueba4 <NA> Hoja2$ SYSTEM TABLE <NA>
>3 c:\\prueba4 <NA> Hoja3$ SYSTEM TABLE <NA>
> > tbl<-sqlFetch(canal,substr(tablas[1,3],1,nchar(tablas[1,3])-1))
> > tbl[1]
> D??a
>1 2003-12-15 00:00:00
>2 2003-12-15 00:00:00
>3 2003-12-15 00:00:...