similar to: Last

According to the docs: getSheets() returns a list of java object references each pointing to an worksheet. ...and the Examples section of the help page shows you how to work with that. Can't tell whether the methods cover what you need though. B. On Apr 17, 2016, at 5:36 PM, Val <valkremk at gmail.com> wrote: > Thank you very much Boris. > Worked fine. My aim is to read

Hi experts, I want to read data from an excel data like this: for the fifth column, from first row until 140 but only 1,3,5,7,.....139 (only 70 values), How can I do it in R? thanks [[alternative HTML version deleted]]

Hello, >From an Excel file imported into R where each cell contains characters, I would like to convert some characters to numeric. However, my code doesn?t work. When I write data to worksheets in an Excel file, some numbers in the cells are stored as text (instead of numeric). Here is my code (the Excel file is attached): rm(list=ls(all=TRUE)) library(XLConnect) tab <-

Dear R Discussion List, I would like to save my data as a xlsx file. But at first I need to split it and then save each series into a Excel column. Please take a look at the following code: dados <- data.frame(matrix(c("2012-01-01","2012-02-01", "2012-03-01","2012-04-01","2012-05-01","2012-06-01",

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 =

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

Hey All, I'm trying to use the xlsx package to read a series of excel spreadsheets into R, but my code is failing at the first step. I setwd into my the directory with the spreadsheets, and, as a test ask for the first one: read.xlsx(file = "Argentina Final.xls", sheetIndex = 1) I promptly get an error message: Error in .jcall(row[[ir]],

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

> On Aug 30, 2017, at 12:24 PM, Nelly Reduan <nell.redu at hotmail.fr> wrote: > > Hello, > > From an Excel file imported into R where each cell contains characters, I would like to convert some characters to numeric. However, my code doesn?t work. When I write data to worksheets in an Excel file, some numbers in the cells are stored as text (instead of numeric). Here is my

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,

Buenos días a todos! Estoy trabajando con una base de datos que directamente he descargado de internet y después de prepararla un poco necesito exportarla a Excel he intentando con las dos opciones que mencionaré al final pero ninguna funciona, de qué otra manera puedo exportar esos datos a Excel... muchas gracias por su ayuda y pronta respuesta! 1) library(xlsx) library(rJava)

Hola. En mi caso, no he podido resolver los problemas con el Java para usar XLConnect, que en los papeles me parece el mejor. Supongo que algo de la arquitectura del sistema o bien de la relación entre el Java, el R y el RStudio. Así que utilizo library(openxlsx) write.xlsx(datos, file = "EDA1.xlsx") #donde datos es el objeto que quiero guardar. Requiere instalar el RTools, según tipo y

> > > Hola chic en s, > > sigo intentando crear un archivo de Excel pero no hay manera. Sigo los pasos del documento de ayuda siguiente: > > http://altons.github.io/r/2015/02/13/quick-intro-to-xlconnect/#load > > los pasos que hago son: > > install.packages("XLConnect") > require(XLConnect) > wb <-

I have spent hours on R in Windows 7. Just installed 2 days ago so the R package should be current. Currently I am using the RGui (64-bit) for Windows. I can not read an Excel file into R from my computer. Have hours on this. Completely crazy!! I have the XLConnect package loaded. I think it is loaded because when I enter: > loadedNamespaces() [1] "base"

The Excel file can be found from this link: https://1drv.ms/x/s!Apkg2VlgfYyDgQ_mcJ8F4CaXV_Nh [https://r1.res.office365.com/owa/prem/images/dc-xlsx_40.png]<https://1drv.ms/x/s!Apkg2VlgfYyDgQ_mcJ8F4CaXV_Nh> File.xlsx<https://1drv.ms/x/s!Apkg2VlgfYyDgQ_mcJ8F4CaXV_Nh> Partag? via OneDrive Thanks very much for your help. Nell ________________________________ De : David Winsemius

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

Hi, i have a very huge number of data with the size 2375ko, i want to import them for R to xlsx but the size of excel is limited How can i resolve this problem? And please how can i define the frame Note that i have a table rows times c(1.....100) columns WLc(200...1000) and inside S c(15,.........) the table it is full values -- View this message in context:

Hola amigos, buenos días Esto sigue avanzando. Estoy ahora tratando de establecer la conectividad de R con Excel y he seguido dos viídeos en YouTube de una profesora llamada Bebilda que se explica muy bien. Con ambos tengo el mismo problema así que planteo uno de ellos, éste es: https://youtu.be/_pSJQO_9I4k?list=PL7DA3FDA21A1A6310 Pero os lo explico brevemente: Cargo el paquete RODBC >

Hi Adrian, dat=data.frame(matrix(0,3,3)) write.xlsx(dat,"z:/dat.xlsx",sheetName="sheet1",append=F) write.xlsx(dat,"z:/dat.xlsx",sheetName="sheet2",append=F) The above code works and creates new worksheets. But if I want to append to an existing worksheet I seem to get an error.

I have a data frame consisting of three columns(name of compund,ppm and frequency).Name contains string values .ppm and frequency contains numeric values with decimal points upto four digits. I have an excel sheet which is like a library.The first column contains the name of compounds and remaining column contains the ppm values of the compound which satisfy certain rules.The number of ppm values