search for: saveworkbook

...14,15,16,17,18),c("date","value","code")))) dados2 <- split(dados, dados$code) dados2 library(XLConnect) wb <- loadWorkbook("Teste.xlsx", create = TRUE) createSheet(wb, name = "Teste1") writeWorksheet(wb, dados2, sheet = "Teste1") saveWorkbook(wb) With this code I only get the "433" series. How could I fix my code? How could I include the other series? Many thanks in advance, Henrique Andrade

...s por tu ayuda! :) > > > > He intentado replicar tu script pero sale el siguiente error: > > > > Error in .jarray(v) : > > Java Exception <no description because toString() failed>.jarray(v)<S4 > > object of class "jobjRef"> > > > saveWorkbook(exc) > > Error in .jcheck() : > > Java Exception <no description because toString() > > failed>.jcall("RJavaTools", "Z", "hasMethod", .jcast(x, > > "java/lang/Object"), name)<S4 object of class "jobjRef"> > &...

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)

...it) > RGui (32-Bit) > > Cuando entro wb <- la primera vez se queda como pensando, acaba de pensar, pero no aparece nada en la carpeta. Vuelvo a meter wb <-load.. y ya no piensa, se queda sin hacer nada. > > Alguien me puede ayudar porfavor? > > P.D.: con el commando saveWorkbook tampoco me ha salido, y tambien he probado con la function new: > > new("workbook", filename, create) > new("workbook",C:/Users/r2753/Desktop/R/test1.xlsx,create) > Error: Unexpected '/' in "new("workbook",C:/" > > Muchas gracias...

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

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:

...Row = 9, endCol = 8) out_wb <- loadWorkbook("resultado.xlsx") writeWorksheet(out_wb, data1, sheet = "dos_primeros", header = FALSE, startRow = 1, startCol = 1) writeWorksheet(out_wb, data2, sheet = "dos_primeros", header = FALSE, startRow = 10, startCol = 1) saveWorkbook(out_wb) Ahora ya no ,me funciona esta librería y con ?openxlsx?, no pudo indicar donde hay que escribir en el Excel y la manera ,más rápida de entregar las tablas a los usuarios es generando los csv y pasándolos a Excel, pero me lleva el doble de trabajo ya que tengo que modificar el formato en Ex...

...est if the named regions can be used within excel ave="=AVERAGE(Var2)" som="=Sum(Var2)" writeWorksheet(wb, data.frame(ave), sheet = "results", startRow = 2, startCol = 2) writeWorksheet(wb, data.frame(som), sheet = "results", startRow = 4, startCol = 2) saveWorkbook(wb) What I need is: 1. a function to repeat this process of naming the regions over 169 columns, and 2. that the excel formulas in sheet "results" really work. (I found that if you find and replace "=" with "=" in Excel it make all the formulas work, maybe there is a...

Hola Klaus y Jorge , gracias por responder. Intente eso mismo y me borra la columna "y", yo quiero eliminar la columna que se genera en los data frame que contiene el número de registro. En el ejemplo de abajo esa columna va de 1 a 4, cuando exporta el data frame se genera esa misma columna (que no tiene cabecera) Años Edad Dpto 1 Bueno 16,75 1 2 Bueno 16 1 3 Malo

Buenos días Creo la siguiente tabla: > tapply(hogares_larioja$DB090, list(HX060=hogares_larioja$HX060, HS190=hogares_larioja$HS190, HH040=hogares_larioja$HH040, HH050=hogares_larioja$HH050, HH081=hogares_larioja$HH081, HH091=hogares_larioja$HH091), sum) y el resultado quiero exportarlo a excel (este y otros que he realizado, claro) para publicarlos. ¿Cómo puedo hacerlo?. Gracias BB

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 see it, run vignette('XLConnect', 'XLConnect') Since it seems that you don't need several worksheets in the output file, a work around would be to use write....

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