25 questions
3
votes
1
answer
52
views
How do I apply a font style I created to a range of cells with openxlsx2?
I want to apply a format I created using the create_font method to one or two ranges of cells, but I can't figure out how to use it. I've tried many ways, but unfortunately, without success.
My goal ...
0
votes
0
answers
27
views
Adjust workflow between openxlsx2 (R) into Tableau
I have a dataset that I put through the following workflow:
Raw data is .xlsx
Clean data using R
Write to a specific sheet in an existing Excel file using openxlsx2 (My colleagues use other tabs in ...
- 89
2
votes
1
answer
54
views
openxlsx2 and group_rows function. Warning messages: "...number of items to replace is not a multiple of replacement length"
I'm producing Excel workbooks with openxlsx2. Typically, I'll write a data table to my workbook and include a totals row:
packages <- c("openxlsx2")
lapply(packages, library, character....
- 100
1
vote
1
answer
71
views
Centering an image on merged cells on openxlsx2 package in R
I have been trying to center an image on merged cells using the openxlsx2 package in R. The image's default is the top-left corner of the merged cell. In the wb$add_image, if I specify the merged ...
- 11
2
votes
1
answer
538
views
Is there an R function to wrap text within a cell in an Excel output?
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 ...
- 387
0
votes
1
answer
134
views
how I can customize font color using conditional format in openxlsx2 in r?
Hi and thanks for reading me
Im currently working in an excel file with a conditional format using R and the package openxlsx2, but when I add the style I get an error in the document output. My code ...
- 672
0
votes
2
answers
322
views
Use openxlsx2 to color specific rows in a vector of indexes
I have a data frame that I want to save into XLSX format using openxlsx2.
This data frame contains entries with specific columns with identical values.
I want to highlight those entries (the whole row)...
- 3,247
0
votes
1
answer
458
views
Cannot write to a worksheet with openxlsx2
Here's my reprex
library(openxlsx2)
wb <- openxlsx2::wb_workbook()
openxlsx2::wb_add_worksheet(wb, "All Courses")
allLines = c("This is the first test",
"...
- 1,131
2
votes
1
answer
511
views
Bug importing with openxlsx2 in R?
I find openxlsx2 a very interesting package, it's very useful how you can import a workbook keeping styles.
I just wondering if it is a bug or I'm doing something wrong for the very simple task of ...
- 97
3
votes
1
answer
266
views
Openxlsx2 Pivot Table Layout Options
I am wondering if there is (or will be) a way to change the layout of a pivot table. For example, I would like my pivot table to print without Subtotals and in Tabular form like in the picture:
Excel ...
- 33
0
votes
1
answer
139
views
How can I use group_walk() to write xlsx files formatted to openxlsx2 wb objects?
I am trying to use group_walk() with openxlsx2 workbook objects to produce multiple xlsx files with greater control of the worksheet properties.
I can use the code below to create simple xlsx files...
...
- 1
0
votes
1
answer
324
views
Order values inside a pivot table in openxlsx2
I´m using openxlsx2 so that I can use the function wb_add_pivot_table() but the problem is that the order in which the rows appear, inside the pivot table, isn't in the order I want it to be displayed....
- 117
0
votes
1
answer
359
views
Adding slicers using OpenXLSX2 in R
I'm using OpenXLSX2 in R to process some data and then output a formatted workbook. I have a pivot table that I would like to connect slicers to - I'm wondering if this is possible using OpenXLSX2. ...
- 329