Questions tagged [openxlsx]

Use this tag for questions related to the openxlsx package. The openxlsx package provides functions to make it easy to read, write and edit XLSX Files in the R programming language.

The package simplifies the creation of Excel files in the programming language by providing a high level interface to writing, styling and editing worksheets. Through the use of , read/write times are comparable to the xlsx () and packages with the added benefit of removing the dependency on Java.

For more information on the package see:

Original author: Alex Walker
Current maintainer: Philipp Schauberger

410 questions
-1
votes
2 answers

file.copy, loadworkbook not working in R shiny reactive environment but working outside reactive environment

I have created the following app to read an excel file from the temp folder in R. I would like to retain the file format in R shiny library(XLConnect) library(shiny) library(openxlsx) library(readxl) ui <- fluidPage( titlePanel("Writer…
Raghavan vmvs
  • 1,213
  • 1
  • 10
  • 29
-1
votes
1 answer

join two dataframes with marking of cell by color when write.xlsx in R

i have two dataframes prop=structure(list(KOD_NAR.id = structure(c(1L, 1L, 2L, 9L, 15L, 16L, 17L, 3L, 4L, 18L, 5L, 6L, 19L, 20L, 7L, 8L, 21L, 10L, 11L, 12L, 13L, 14L), .Label = c("", "-1", "04А ", "04Б ", "05А ", "05Б ", "07Д ", "07С ",…
psysky
  • 3,037
  • 5
  • 28
  • 64
-1
votes
1 answer

How to append values to existing comma delimited csv (excel) file

I have an existing CSV-file with 4 columns (comma delimited, so all values in one column in excel) How do I write a code to add for example the value '10' to every row (that is the length) Also, how do I add a string to these rows? Ideal output…
-1
votes
2 answers

I am not able to create new tab in Excel via R

I would like to create two tabs with Terms and Commloans. But when I am using this code, Terms are overwriting Commloans and I don't have these two tabs :/ library("openxlsx") write.xlsx(Comms, file = "PnL.xlsx", sheetName="Commloans",…
KennyR
  • 5
  • 1
-1
votes
1 answer

R script to arguments

currently, in this code below, there is manual intervention I want to define the path of 2 input files. but then I am not sure how to do it library("openxlsx") nm=readline("Enter data file name:") readline("Enter input file name:…
1 2 3
27
28