openxlsx2
openxlsx2 copied to clipboard
JanMarvin
openxlsx2 - read, write and modify xlsx files
Similar to the removal of most of the included example and test files, I want to remove the images from the vignettes and point people to https://github.com/JanMarvin/ox2-book for a detailed...
Currently, when writing output, we force a cell `` node on every row `` we write. Working on #475 I created the attached file that breaks this logic. I assume...
Currently when providing dims to write data, we should provide an option to check if the area we are writing to is equal to dims and otherwise we should inform...
In 2014 someone decided, that having `charts[0-9].xml` was not enough and introduced `chartEx[0-9].xml`. These are used with newer chart options in Excel like histograms and box whisker plots. Unfortunately this...
`R/class-workbook.R` has become quite massive (6000+ lines!) This can be reduced by a little `{R6}` wrapper trick (yes, more _wrappers_). An example can be seen with the `{desc}` package: https://github.com/r-lib/desc/blob/main/R/description.R...
* we have `wbWorksheet` and `wbChartSheet` and `worksheet` and `chart-sheet` * Internally we treat them in `wb$worksheets` which could be `wb$sheets` * both could share the same origin `wbSheet`. This...
See this [SO](https://stackoverflow.com/questions/73441774/reading-data-from-excel-with-openxlsx-into-r-shows-minor-differences?noredirect=1#comment129740698_73441774)
It's possible to clone them as named region for a worksheet. Though that might create issues further down the line.
https://adv-r.hadley.nz/r6.html#finalizer We may have a few temporary files that are created with the workbook object. If we track these files then we can try to remove them when the object...
List of functions that may be able to be moved from the `wbWorkbook` class to another class. Suggestions welcomed. Most of these seem to be better suited for the `wbWorksheet()`...