Skip to main content
462 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
1 vote
0 answers
97 views

I have a dataframe which I am trying to export to Excel with formatting and comments. To do this I have created a custom function using functions in the `openxlsx2' package to add color fill and/or ...
user2352714's user avatar
  • 464
0 votes
0 answers
85 views

I’m trying to use the R package openxlsx to map data from one sheet (Source) to another (Target) in Excel using XLOOKUP. The idea is to use multiple key columns to perform the lookup. Here is the ...
TobiSonne's user avatar
  • 1,117
2 votes
2 answers
137 views

I have a simple list like library(tidyverse) library(openxlsx) mtcars |> group_split(cyl) And now I want to save each list as an Excel file to the folder specified in cyl like so: mtcars |> ...
deschen's user avatar
  • 11.6k
3 votes
1 answer
77 views

I have following df and could like to output to an Excel file. Is it possible to add a highlight to S1:S5 with a condition Cell Value = Value in Line. I did look through the condtionalFormatting() but ...
Stataq's user avatar
  • 2,451
1 vote
1 answer
79 views

I need to use the openxlsx library due to java issues at my institution. I have a list of dataframes called data_list that are simply named 1, 2, 3, etc. > data_list $`1` Count TaxID ...
aminards's user avatar
  • 459
0 votes
3 answers
125 views

I have this kind of data: [{"id": 1, "name": "Alex", "projects": ["A", "B", "C"]}, {"id": 2, "name": "Bob&...
Aykhan Aghayev's user avatar
  • 1
2 votes
2 answers
105 views

I have seen a lot of questions involving reading in all the Excel files from folder and merging them all together, however my situation is a bit different where each Excel file contains different data....
user30397791's user avatar
  • 175
1 vote
1 answer
80 views

I would like to write a function to read in all the excel worksheets of all the excel workbooks in a folder as separate datasets each named after the workbook and sheet. For example, if the folder ...
h09812349's user avatar
  • 173
1 vote
2 answers
127 views

I'm q newbie and i searched for the solution across the web making some "minor" progress but i'm pretty sure that i'm do things wrongly and there are very few video and tutorial about that, ...
Moreno's user avatar
  • 23
2 votes
1 answer
208 views

I am exporting data into an xlsx file using the openxlsx R library, and wish to format cells conditionally based on the exact text they contain. To make the example simpler, let's pretend I want cells ...
whv20's user avatar
  • 241
0 votes
1 answer
58 views

I'm trying to parallelise with openxlsx and its function writeData the export of many Excel individual files that should be somehow summarised in a central Excel file. As can be shown in the reprex ...
Olivier7121's user avatar
  • 494
0 votes
1 answer
31 views

I am writing datasets to Excel using the openxlsx and openxlsx2 packages. The report generated from this code has to be updated on a monthly basis, so the header/footer annotations need to reflect ...
Mary Rachel's user avatar
  • 387
2 votes
3 answers
140 views

I have a list a that I need to transform to a data frame with 17 rows and 2 columns. a <- list("01-step" = list("41 - 41" = c(41, 41), "7 - 7" = c(7, 7), "10 - 10&...
Olivier7121's user avatar
  • 494
0 votes
1 answer
58 views

I'm exporting a few dataframes to an excel document using the openxlsx package and using the createStyle() and addStyle() functions to apply aesthetics. However, my "total" row is not being ...
Mary Rachel's user avatar
  • 387
1 vote
2 answers
113 views

I'd like to keep the full data, including any empty rows and columns, when importing. However, I am not sure why the read.xlsx() function from the openxlsx package does not achieve this if the first ...
Grasshopper_NZ's user avatar
  • 1,062
2 votes
1 answer
165 views

I would like to know if there is a way to export a data frame/tibble from R as an .xlsx file with highlighting and comments added natively from the R console rather than post-processing in Excel. I ...
user2352714's user avatar
  • 464
2 votes
1 answer
566 views

I'm writing a script to render an Excel output using openxlsx, and I'm having a hard time wrapping text within a cell. I have a "Report Notes" sheet in my output with the usual disclaimers ...
Mary Rachel's user avatar
  • 387
0 votes
1 answer
60 views

I'm preparing an Excel workbook using the openxlsx package, and I want to use setColWidths() to auto-resized the columns in each sheet. Since I have multiple sheets and I want my code to be relative, ...
Mary Rachel's user avatar
  • 387
2 votes
2 answers
111 views

I am trying to export a set of tables to an excel sheet. However I am using a for loop to create different sheets which means that in some cases not all of the tables exist. Does anyone know how to ...
gimmethedata123's user avatar
  • 83
0 votes
0 answers
147 views

Necessary preamble that will explain my clumsy syntax below: I am a novice with R and having developed in Python for ages I find the R syntax to be unclear form a OOP perspective (i.e. hard to find ...
DryMartini's user avatar
  • 1
1 vote
1 answer
109 views

Currently using the following structure and syntax to copy down a formula in openxlsx workbook. for(i in 1:10){ writeFormula(wb, tab_name, paste0('SUMIFS(A:A,B:B,A',i',), startRow = i, startCol = 1) ...
triangle_coder's user avatar
  • 11
0 votes
2 answers
77 views

I'm trying to produce a table that checks two different table columns, stacks them together to check unique values. When I write this formula manually in excel, it works as expected, but when produced ...
rv_acc's user avatar
  • 1
0 votes
1 answer
64 views

I am attempting to write a function to read in multiple excel files into R, however I am trying to use openxlsx specifically because later on in my program I want to output specific columns/rows into ...
h09812349's user avatar
  • 173
0 votes
1 answer
50 views

I have the shiny app below in which I have two reactive dataframes. I want when I click download to download one excel file with both dataframes in two different tabs with their names if possible. ...
firmo23's user avatar
  • 8,546
2 votes
0 answers
86 views

I am trying to create an overflowing array in R using openxlsx. My end result will have the user change items into row 1, so I need the UNIQUE formula to dynamically add/remove values after exporting. ...
owaiapu's user avatar
  • 61
0 votes
0 answers
108 views

I'm making excel files that contain hyperlinks in some cells using the openxlsx package. However, when you download the file from the Shiny app, it opens in Protected view. Trying to click on the link ...
mkranj's user avatar
  • 549
0 votes
2 answers
228 views

Using the openxlsx r package to write data to excel. Needing to include excel formulas that can be edited by end users so I'm using the openxlsx::writeFormula function to create array formulas that ...
Benjamin Jacob's user avatar
  • 3
0 votes
1 answer
119 views

I want to implement the following formula using openxlsx: =IF(COUNTIF(E3:G3,"none")=3,"N/A",AVERAGE(IF(ISNUMBER(--E3:G3),--E3:G3,""))) to each row This formula works ...
Mel's user avatar
  • 71
0 votes
1 answer
102 views

My reproducible code below writes a super small .xlsx file that has two sheets. I was wondering if there might be a way to color-code values of 3 in red, 4 in orange, and 5 in green anywhere in the ...
Simon Harmel's user avatar
  • 1,489
1 vote
1 answer
112 views

I have a CMake&C++ project where I prepared a condensed wrapper for pugixml. This wrapper is then linked to my io.lib library and works nicely on both ubuntu-22.04 and windows-latest. I then added ...
skrat's user avatar
  • 748
2 votes
1 answer
302 views

I'm trying to read a set of data from my Excel file. I am able to read the integers from the first column: const auto sdf = sheet.cell(fmt::format("A{}", rowIndex)).value().get<int>();...
skrat's user avatar
  • 748
0 votes
0 answers
360 views

I'm trying to make use of the OpenXLSX in my c++ project. I added the source code with a git submodule using command git submodule add [email protected]:troldal/OpenXLSX.git external/OpenXLSX which ...
skrat's user avatar
  • 748
1 vote
0 answers
65 views

I need to read an excel file into R. I am using the following code: library(readxl) data <- read_excel("path/to/file.xlsx") The Excel file looks like this: I would like to read the file ...
Raga's user avatar
  • 426
0 votes
1 answer
250 views

Question 1 In the code below, while performing the run, all the outputs is displayed in RStudio console. This particularly happens if the code add style is in the loop for different workbook tabs. I ...
Mohit's user avatar
  • 597
0 votes
1 answer
87 views

I have an issue with loading data from a Dropbox folder, and have absolutely no idea why. Several posts suggest that the issue can be solved by closing the file before loading it, but it's obviously ...
Fred-LM's user avatar
  • 342
1 vote
1 answer
201 views

I have a dataframe, df1 which is data manipulated from an imported excel, and I need to export it back out to have specific formatting that the original file had - it has many columns, but essentially ...
Confused_by_R's user avatar
  • 11
2 votes
1 answer
152 views

I can read a formatted .xlsx file using the openxlsx package and the loadWorkbook function and further edit it as needed. How can I display this data as a HTML table in a Shiny app? Exact styling is ...
mkranj's user avatar
  • 549
0 votes
0 answers
91 views

I have an xlsx workbook on my desktop with existing sheets. Some of the sheets includes charts (e.g. line chart). I have a dataframe in R that I would like to write into a sheet in this workbook and ...
joers's user avatar
  • 1
1 vote
1 answer
359 views

I'm trying to automate some processes in Excel using R language and openxlsx library. When I write new data to a cell (which works fine) that is a reference to a formula in other cells, those cells ...
Arthur S. de Lima's user avatar
  • 11
1 vote
0 answers
295 views

I have the following table with cells containing numbers from -1 to 10 (decimal places allowed). In some cases there is a trailing A behind the number. Now, I would like to extract all digits from the ...
Ben Nutzer's user avatar
  • 1,163
1 vote
1 answer
83 views

I need to create a bar chart in Excel on a separate sheet to the data. The only way I have managed to do this is by adding the data to the workbook object then referencing that as the data source for ...
AndyDudley's user avatar
  • 51
1 vote
1 answer
139 views

I would like to create conditional formatting for a correlation matrix where cells with correlation coefficients 0.75 to 1 and -0.75 to -1 have green backgrounds with black font (see provided code). ...
Rizek_a_salat's user avatar
  • 47
0 votes
2 answers
472 views

I create a two way table in R using the following code t <- table(df[["Sex"]], df[["C or Better"]], useNA = "ifany") colnames(t)[is.na(colnames(t))] <- "Blank&...
Thomas Philips's user avatar
  • 1,131
0 votes
1 answer
116 views

I'm developing a Shiny app that processes financial data and generates a formatted Excel report. The data processing part works perfectly as a standalone script, but when integrated into Shiny, the ...
ecology's user avatar
  • 673
1 vote
0 answers
71 views

I would like to know what's causing my problem. Whenever I write anything related to updated_origin in Excel.(Example: writeData(wb,"sheet3",x = multiply,xy = c(c,r+2)) It will always give ...
orochi's user avatar
  • 11
0 votes
1 answer
69 views

Im using openxlsx library in R. Excel output of my code is not considering 0.000 format and in my excel output instead of numbers like -0.019 I can see only 0 or 1 (underneath they have good numbers). ...
Fendi's user avatar
  • 93
0 votes
1 answer
167 views

I want to compare two sheets values, and highlight the difference, below is a simple example, can someone help me to out about how to write the rule=? Thanks wb \<- createWorkbook() addWorksheet(wb,...
George N's user avatar
  • 3
1 vote
0 answers
119 views

I'm trying to create an R code which can automatically make excel sheets with drop down lists. I'm using the openxlsx package for this with their Datavalidation function. When I run the file for each ...
Markje009's user avatar
  • 21
0 votes
1 answer
253 views

I have a data frame with a column that contains both text and numbers. As a consequence, the type of this column is character. The numbers have a dot as a decimal separator and no thousands separator. ...
snowman's user avatar
  • 35
1 vote
0 answers
117 views

I'm creating Excel files using an R script. In the script, I want to add comments to several cells and then edit the style of these comments. So far, I have seen that I can use the createStyle() ...
m_delx's user avatar
  • 11

1
2 3 4 5
…
10