I am trying to export from R to excel an dataframe with two columns which I want to fill with the excel if formula so that the user could later on change the thresholds. My question is how can I ex...

I am using package xlsx Version:0.5.7 Date: 2014-08-01. in R version 3.0.1 (2013-05-16) -- "Good Sport" Platform: i386-w64-mingw32/i386 (32-bit). I have an xlsx file with at least 2 sheet...

When I type require(xlsx) in order to load the package xlsx in R, the following messages is shown: > require(xlsx) Loading required package: xlsx Loading required package: xlsxjars Loading requ...

I am using ‘openxlsx’ package in R. ٰI want to add some data in xlsx file. I have used following code to create the workbook and add worksheet in it. wb=createWorkbook() addWorksheet(wb,"sheet ...

Is there any way to read out the color-index of cells from excel files with R? While I can set the cell color with packages like XLConnect or XLSX, I have found no way to extract the color-informa...

The xlsx package is reading dates in wrongly. I've read all the top similar Q's here and had a scout round the internet but I can't find this particular behaviour where the origin changes if there'...

I am trying to use .xlsx library but function write.xlsx is returning error that such can not be found. When I am installing library(xlsx) in log I can read: Error : .onLoad nie powiodło się w fu...

At first, I tried to read and write xlsx files in R (while comparing the output between the xlsx and openxlsx packages). I work on mac os. It worked well to read xlsx files using the read.xlsx()...

I have a problem with the write.xlsx2 function of xlsx R package. For instance, see the code below. main_path<-"~/mydir/" read.xlsx2(paste0(main_path,"my_input_excel.xlsx"), sheetIndex=1) a&lt...

I am using the following R code (that utilizes the Java parameter to increase memory as well): library(xlsx) options(java.parameters = "-Xmx1g") library(XLConnect) NiVe <- read.xlsx("version1.x...

Does anyone know why argument colClasses does not seem to work in read.xlsx? I create a sample *.xlsx file: > library(xlsx) > d1 = data.frame(A=LETTERS[1:3], B=letters[1:3], C=1:3, D=c(1.1,...