openxlsx
openxlsx copied to clipboard
openxlsx - a fast way to read and write complex xslx files
**Is your feature request related to a problem? Please describe.** I'm creating validations that require custom input messages and error alerts, but the current implementation of validations does not appear...
@JanMarvin @jmbarbone @jeff-m-sullivan Could you please update the NEWS for the up coming CRAN release?
In `writeDataTable()` or `writeData()`, col.names and row.names are deprecated. Therefore, please remove col.names and row.names from documentation in `buildWorkbook` and `write.xlsx`: > colNames ~or col.names~ If TRUE, column names of...
**Describe the bug** `openxlsx_setOp` fails to set a style for `headerStyle`. **To Reproduce** When answering [this question](https://stackoverflow.com/questions/73406826/openxlsx-openxlsx-setopheaderstyle/73406961#73406961) on SO I stumbled over a possible bug in `openxlsx_setOp`: ``` r library(openxlsx)...
Disclaimer: I yet have to figure out how to make a reproducible example (because as of now I can't, well, reproduce with a small toy example the issue in one...
Would it be possible to have a function whereby: 1. you load in an existing xlsx file which contains a table using loadWorkbook 2. then use this new function to...
It seems you can only group one set of rows per worksheet with this function. I want to create 3 separate, non-nested groups in the iris data set by Species....
Why the default date format does not match Excel default date format (Windows Regional setting)? The following code formats date as `mm.dd.yyyy`, while my Excel default date formatting is `*dd.mm.yy`....
Hello, It seems like it was already done at one point, but is not present in the current version of openxlsx. https://github.com/awalker89/openxlsx/pull/382 This feature would be incredibly useful. Not sure...