openxlsx2
openxlsx2 copied to clipboard
openxlsx2 - read, write and modify xlsx files
Remove content from a worksheet * [x] #1011 * [ ] remove tables could be renamed to `wb_remove_data_table()` * [ ] similar naming issues with: `wb_clean_sheet()` removes: * cell data...
Total coverage is severely impacted by missing xlsb tests. Improving coverage can be tricky, because some tests will fail on big endian systems, maybe we need some way to skip...
Due to some merged cell styles sometimes something like `A1;B2:C2;A3:C5` is needed to import to a data frame. Sadly this is currently not possible. Our selection of multiple cells always...
when calling `writeData()` it should be possible to easily write into a named region instead of just dims
provide function to return path to media objects. If a workbook contains media, this should return the path to the jpg or png files.
We (I) have been pretty lazy with the documentation. These current docs are written just so roxygen doesn't complain. - [ ] ensure `R6` object methods match documentation for wrappers...
This is incomplete here. Just as a test here, but I wouldn't know how to adjust `standardize_case_names()` to make this actually work. Let me know what you think ** No...
As can be seen from code coverage, `helper_functions.R` has a few uncovered lines. Since most of these are pivot related, it might be a good idea to a) move pivot...
Currently we neither write nor copy the webextension folder around. Needs folders (could be copied over): ``` xl/webextensions/ xl/webextensions/_rels/ ``` Needs in `_rels/.rels` (currently unused): ```XML ``` Needs in Content_Types:...