openxlsx
openxlsx copied to clipboard
ycphs
openxlsx - a fast way to read and write complex xslx files
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.
**Describe the bug** When opening an existing xlsx file containing header styles in cells and then resaving it, the appearance of the cell is preserved, but the naming of this...
**Is your feature request related to a problem? Please describe.** A clear and concise description of what the problem is. The problem is `TextDecoration` of `CreateStyle` can only be applied...
**Is your feature request related to a problem? Please describe.** In my work we have a lot of systems set up to print workbooks using openxlsx in R, since R...
@JanMarvin great work. I hope to have some time over the holidays to enable the already existing `cloneWorksheet(wb, sheetName, clonedSheet)` function with an optional second wb item as source for...
The default for `na.strings` is `"NA"` but the documentation says: > A character vector of strings which are to be interpreted as NA. Blank cells will be returned as NA....
I couldn't find `addStyle()` on the `conditionalFromatting()` page. They are similar functions in that `conditionalFormatting()` adds styles to the Excel worksheet that are more complicated (based on other cells) than...
> packageVersion('openxlsx') [1] ‘4.2.5.2’ Excel has a set of Table Style Options  Most of these can be set with writeDataTable, but apparently not the 'Total Row' option. It would...
Background: I am slowly starting to use openxlsx2 instead of openxlsx, because openxlsx does not support some features I need (specifically, multiple text colors in a single cell). For practical...
loadworkbook function returns error "Error in loadWorkbook(Pla_dolar, isUnzipped = TRUE) : object 'sheetrId' not found". I have tried with different files and different locations in my files to rule out...
