openxlsx2
openxlsx2 copied to clipboard
JanMarvin
openxlsx2 - read, write and modify xlsx files
Even though they are handled separately in openxml, it is impossible to have identical names for tables and regions (our name for definedName). A check should be added, when creating...
Simple but would probably be pretty useful. I know I've saved many files as both csv and xlsx. A function that can can be passed a csv file (or files)...
probably would be better to do something like : ```r hf_spec
These are pulled out from #9. Didn't want it holding up the issue. May want to look at parity with #6, #36. Haven't started on this yet, maybe a bit...
The output still returns ranges, but that's acceptable. We should be able to catch this and should be able to return `A1:A1` as `A1`.
`wb_dims` gives weird dimension range when the `rows` argument is a vector and the vector contains 1. ```r r$> packageVersion("openxlsx2") [1] '1.8.0.9000' r$> wb_dims(rows = c(2,30), cols = 2) [1]...
This works on my linux machine with 32gb of memory, whereas it ~~fails to export with pugixml due to the dom blowing up~~ needs approximately 6gb more with pugixml. ```...
Our CRAN page is a little noisier than usual. https://cran.r-project.org/web/checks/check_results_openxlsx2.html Not sure what the ggplot2 warning is supposed to mean and I don’t remember any changes to it. Any ideas...
https://github.com/JanMarvin/openxlsx2/blob/7c94ede76e53f7e8c6a4a58ae5672887c6e91720/inst/include/pugixml/pugiconfig.hpp#L21 The xml DOM tree is known to cause memory issues. Especially with wider datasets. We can try to enable the `PUGIXML_COMPACT` mode which should reduce the memory usage 2-5...
Having followed the thread of issues starting at https://github.com/ycphs/openxlsx/issues/461 and ending at https://github.com/JanMarvin/openxlsx2/pull/983 I have had limited success in getting MIP labels to successfully apply to files saved using `wb_save`....
