openxlsx
openxlsx copied to clipboard
ycphs
openxlsx - a fast way to read and write complex xslx files
**Is your feature request related to a problem? Please describe.** There are are few places in the codebase where row and column indices are combined with `paste()`. This is done...
This PR will preserve the size and position of the window when you open the xlsx in Excel. There are also functions to set and get directly. I had earlier...
R version: 4.4.0 Openxlsx version: 4.2.7.1 Platform: Windows Trying to create a named region that where the cells are cross hatched but have data (see file) causes an error when...
`readxl::read_excel` guesses column types based on the value of the first `guess_max` (an argument of the function) of its cells ([reference](https://readxl.tidyverse.org/articles/cell-and-column-types.html#type-guessing)) This causes problems in importing when a numeric cell...
Using `mergeCells` can be very slow when doing many merges. This is caused by a check for overlapping merges. This is done by extracting all affected fields from all previous...
I am trying to consolidate two excel file with the same column names and write the output into an another excel file while keeping the images in place. But whenever...
**Describe the bug** addStyle accepts only one row across columns, one column across rows, or an equal number of columns and rows. It does not accept a combination (e.g., 15...
**Is your feature request related to a problem? Please describe.** When you have multiple tables you would want to export using openxlsx, with the styling being the same across all...
The default value is: na.strings="NA". I find this default value quite dangerous when the Excel sheet to import has columns with abbreviations that might contain the value "NA" as a...
