currently I am preparing an R-lesson for a customer. We want to read in data from a password protected xlsx file. Thus, I am trying to read this password protected xlsx file into R (unprotecting th...

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 loaded an Excel workbook in R and want to do some formatting of the borders in a rectangular range of cells. I would like to put a thin border between all cells put a thick border around the ...

is there a way to read an open excel file into R? When an excel file is open in Excel, Excel puts a lock on the file, such as the reading method in R cannot access the file. Can you circumvent this...

I have automated the process of accessing VBA Macros, from R, using Openxlsx and RDCOMClient packages. Below is the code: Function: OpenExcel_5param <- function(directory,filename, MacroName,...

I'm dumping into a file a report, and I'm using openxlsx to do so, as it can be seen below: library(openxlsx) set.seed(100) dataset <- data.frame(A=runif(100),B=runif(100),C=sample(c("A","B",...

The issue is that when I read from an excel sheet into R using read.xlsx from openxlsx package, the TIME column is converted into a fraction. Here is an example, dfin <- DATE TIME 15/02/2015 8...

I am trying to take in a data frame an excel sheet that has two columns, Column A contains names of stores Column B contains the URL of those stores. I would like to take Column A and make it ...

The openxlsx::write.xlsx function is overwriting spreadsheet instead of adding another tab. I tried do follow some orientations of Stackoverflow, but without sucess. dt.escrita <- format(Sys.t...

I am trying to import the data in my Excel file into R using Openxlsx library: library(openxlsx) data <- read.xlsx("datafile.xlsx", sheet = "Sheet1") However, I get the foll...

Can I make sure that two XLSX files (written with openxlsx::write.xlsx) are identical, when given the same data to write? I think there's a timestamp written to the spreadsheet which means the same...

I want to bold part of a text string. For example, is there a way to only bold 'text' in 'this is my text string' using openxlsx R package: wb <- openxlsx::createWorkbook() openxlsx::addWorkshe...

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

I have been trying to obtain the time at which the content of an .xlsx file was created without any success so far. I can track the much-desired information on Windows either through File Propertie...

I have a big Excel table (18k rows and 400 cols) which has some rows highlighted using different colors. Is there a way to filter the rows by colors using openxlsx? I first loaded the workbook wb &...

wight now I'having an issue with R. I could not use library openxlsx in my PC. When I try to import, these errors show me that: Error: package or namespace load failed for ‘openxlsx’: object ‘zip...

I'm trying to generate a .xlsx file through the Openxlsx package with a reactive name and header inside file (the input variables are "ASL.1" and "Year.1"). The object to be saved in the file is th...

The createStyle function in the openxlsx package has an argument numFmt, which allows you to create an excel format to be applied to specific cells in a .xlsx file. You can round values by specifyi...

I am using "openxlsx" package to read and write excel files. I have a fixed file with a sheet called "Data" which is used by formulas in other sheets. I want to update this Data sheet without touch...

I am trying to fill a row in an excel workbook with openxlsx based on text in a column from that row. For example, if cell C3 contains A then highlight row 3. Ideally, this would not be conditiona...

Lets consider this small example: df1<- data.frame(A=c(1,NA,"pvalue",0.0003),B=c(0.5,7,"I destroy","numbers all day"),stringsAsFactors = T) Write file: openxlsx::write.xlsx(df1,"Test.xlsx") ...

How can we save a workbook in a certain folder and make it available for user to download it? ref: Shiny + downloadHandler + Openxlsx does not generate a xlsx file Procedure: Create a data Save as...

I have a set of CSV files. I want to package them up and export the data to a single Excel file that contains multiple worksheets. I read in the CSV files as a set of data frames. My problem is ho...

I use the write.xlsx() function (from the openxlsx package) to turn a list object into an excel spreadsheet, where each element of the list is converted into a "sheet" of the excel file. In the pas...

I would like to output data from R to an excel file, and have been using the openxlsx package. writeDataTable is the function I have been using. The problem is that I want the entries of one of th...