similar to: Question of the XLConnect package

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, Belén. Podrías indicar qué error te da? En principio el paquete XLConnect funciona correctamente (tanto si lo descargas desde el CRAN como desde GitHub). Puede que no tenga que ver directamente con el paquete... alguna dependencia que no encuentra? Java? ... Un saludo, Miguel. ________________________________ De: R-help-es <r-help-es-bounces en r-project.org> en nombre de

Buenos días Antes con el paquete "XLConnect", podía leer y escribir en un lugar determinado en Excel tal y como indico a continuación in1_wb <- loadWorkbook("aa.xlsx") data1 <- readWorksheet(in1_wb, sheet="Sheet1", header = FALSE, startRow = 1, startCol = 1, endRow = 5, endCol = 8) in2_wb <- loadWorkbook("bb.xlsx") data2 <-

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

Hi, Attached are two datasheet to be read. My raw data "130502temp.xlsx" contains numbers with ' symbols, and they can't be read as numbers. Even if I copy and paste as numbers to form a new file "130502temp_number1.xlsx", they could not be read smoothly. 1. How can I read the datasheet as numbers? 2. How can I treat the notation "-" as (1)

Hello, This is the sort of question that could interess others, so you should have CCed it to the list. As for the question, from the package vignette, section 3.3.6: "writeWorksheetToFile() is a wrapper function, calling loadWorkbook(), createSheet() and saveWorkbook() functions subsequently. It therefore allows for writing data into worksheets of an Excel file in one call." To

Hi, I have two questions on the function "readNamedRegionFromFile" in XLConnect pacakge. 1. In the documentation, # multiregion xlsx file from demoFiles subfolder of package XLConnect demoExcelFile <- system.file("demoFiles/multiregion.xlsx", package = "XLConnect") # Load a single named region into a single data.frame. df

> > > 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 <-

Hi, i want to create xlsx sheet, all things seems to be perfect until this erro message Erreur : OutOfMemoryError (Java): Java heap space i have xp system, (32bit) I tried the following syntax > options(java.parameters = "-Xmx1000m") > options(java.parameters = "-Xms=3670K") > writeWorksheet(wb, SP, sheet = "SP") alos this one options(java.parameters =

Hi, I had been using a script that works fine for several days and then I stopped using it for a month without having doubt that it would not be working. When I use it again today, I received an error when I reach the last step of generating the data file. *"Error in .jcall(wb, "Lorg/apache/poi/ss/usermodel/Sheet;", "createSheet", : * *

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)

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:

The subject of your email is missing. Perhaps you need to read the Posting Guide (again?) about attachments. Embedding your example directly in the body of the email is generally more accessible in archives than attaching it. -- Sent from my phone. Please excuse my brevity. On April 27, 2016 1:14:17 PM GMT+01:00, G.Maubach at gmx.de wrote: >Hi All, > >I am addressing this post to all

Hi, I'm documenting a package that makes heavy use of S4 methods at the moment, and I'm having a hard time from keeping the PDF output of Rd from looking really terrible. First of all, what is the preferred way to actually document S4 methods? When I use promptClass/promptMethod, I get a style that doesn't use the \S4method macro and puts the entire function signature into a \item.

Hi All, I am addressing this post to all who are new to R. When learing R in the last weeks I took some notes for myself to have code snippets ready for the data analysis process. I put these snippets together as a script template for future use. Almost all of the given command prototypes are tested. The template script contains snippets for best practices and leaves out the commands that

When I read a time hh:mm:ss from a excel sheet with gdata read.xls it is as expected. When I read the time with readWorksheet I get 1899-12-31 00:20:00 UTC. I would prefer XLConnect because it does not nee perl installed but the data coming with XLConnect is not usable.

When using XLConnect's readWorksheet, instead of it correctly reading string and numeric columns, I receive NA's with the following message: " Error when trying to evaluate cell A2 - not implemented yet" I do not know what this means. Can anyone please assist? -- __________________________ *Barry E. King, Ph.D.* Chief Modeler Qualex Consulting Services, Inc.

Hi Everybody In R, the XLConnect package can read and write named region to and from Excel. In order to read a named region with the readNamedRegion function you need to know it's name. You can check is a name exists with existsName, but you still have to know the name. Is there a way to actually get a list of the named regions in XLConnect sinilar to getRanges in the xlsx package. On that

Folks, I am using the XLConnect package. I can download all the named ranges except a couple that are defined by the Excel function ?Offset?. For example I have this named range: =OFFSET(APA!$A$1,0,0,APA!$K$11,3) I am pretty sure that this won?t work but I thought I would give it a shot here. Thanks for your time, Best, KW

Hi Nelly, Are you trying to convert hexadecimal to decimal? nrdf Setting Value 1 Parameters a 2 Parameters b 3 Parameters c 4 Parameters d 5 Parameters e 6 Parameters 2 7 Parameters 8 8 Parameters 9 9 Parameters 7 10 1 a 11 2 b 12 3 c 13 4 d strtoi(nrdf$Value,16) [1] 10 11 12 13 14 2 8 9