openxlsx
openxlsx copied to clipboard
ycphs
openxlsx - a fast way to read and write complex xslx files
**Describe the bug** `colWidths = "auto"` adjusts the columns widths but does not take the into account the space taken by the filter button **To Reproduce** ``` df
I'm trying to overwrite an existing sheet in a previously created excel file (not from R). When using the following functions I get an error when I try to open...
In the createStyle function, could the fontColour option be allowed to be set to automatic? In terms of spreadsheet accessibility, setting the font colour to automatic is supposed to be...
**Describe the bug** `freezePane()` does not freeze panes when called on a workbook which might have previously had panes freezed. Freezing panes therefore works on documents generated in-memory, but does...
How to use openxlsx to control the value of text column, e.g. I want to make sure the certain character column must be "Yes" or "No"?
**Description** If some data is deleted from a workbook via `deleteData`, the workbook can not be saved due to the following error: `Error: invalid assignment for reference class field ‘cols’,...
**Is your feature request related to a problem? Please describe.** When I use R1C1 cell references in writeFormula(), I am unable to open the resulting excel file without error. I...
**Describe the bug** When passing a list of dataframes with S3 class `vctrs_list_of` (e.g., as returned by `dplyr::group_split()`) to `write.xlsx`, the resulting Excel file has an unexpected structure. Instead of...
I can not seem to run my code due to an error with '#include "OpenXLSX-Exports.hpp"' I have checked through the files and I can not seem to find this file.
Closes #467. I considered [Szudzik's Elegant Pairing Function](http://szudzik.com/ElegantPairing.pdf), but it quickly exceeds `.Machine$integer.max`. Instead, we create a double vector by taking the row position as the whole number and the...
