search for: writeworksheet

...FALSE,dimnames=list(c(1,2,3,4,5,6,7,8,9, 10,11,12,13,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

...to do that individually for each column but would lie to automate the process library(XLConnect) wb <- loadWorkbook("Testdata.xlsx", create = TRUE) # create a workbook testdata=expand.grid(letters[1:10], 1:10) # create some data createSheet(wb,"testdata") # create sheet writeWorksheet(wb,testdata,sheet="testdata") # write data to sheet # Create named regions named the column names col1idx=idx2cref(c(2,grep("Var1",names(testdata)), 1+length(testdata$Var1), grep("Var1",names(testdata)))) # addres1=paste(col1idx[[1]],":",col1idx[[2]],sep=...

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

...o 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 = "-Xmx1000m") > writeWorksheet(wb, SP, sheet = "SP") Erreur dans .jcheck() : Java Exception <no description because toString() failed>.jcall("RJavaTools", "Z", "hasField&...

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)

...rary(XLConnect) > >> > >> fileXls <- "newFile.xlsx" > >> unlink(fileXls, recursive = FALSE, force = FALSE) > >> exc <- loadWorkbook(fileXls, create = TRUE) > >> createSheet(exc,'Data') > >> saveWorkbook(exc) > >> writeWorksheet(exc, DataFrame, sheet = "Data", startRow = 1, startCol = > 1) > >> saveWorkbook(exc) > >> > >> Saludos, > >> > >> Javier > >> > >> 2016-07-26 12:52 GMT+02:00 Isidro Hidalgo Arellano <ihidalgo en jccm.es>: > >&gt...

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