search for: createsheet

...39,3939,3939,3939),nrow=18, ncol=3,byrow=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

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

...igure out the indices in Excel I have figured out how 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)))) # a...

...s 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", : * * java.lang.IllegalArgumentException: The workbook already contains a sheet of this name*" I had uninstalled and re-installed both java and R. I tried using XLConnect package to replace the xlsx. I have been trying to search the solution for this and I found no useful exp...

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)

...9;DataFrame' es el df que quieres guardar: > >> > >> library(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...

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

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

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

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