Open msgoussi opened 5 years ago
to keep footers (Left, Center and Right) as it is.
it drops some of the footer items (Center and Right)
(please attach an example xlsx file if possible)
library(openxlsx) wb <- openxlsx::loadWorkbook("Book1.xlsx") openxlsx::writeData(wb, sheet = 1, iris[1:5, ], startRow = 2, colNames = FALSE) openxlsx::saveWorkbook(wb, "newBook.xlsx", overwrite = TRUE)
Expected Behavior
to keep footers (Left, Center and Right) as it is.
Actual Behavior
it drops some of the footer items (Center and Right)
Steps to Reproduce the Problem
(please attach an example xlsx file if possible)
library(openxlsx) wb <- openxlsx::loadWorkbook("Book1.xlsx") openxlsx::writeData(wb, sheet = 1, iris[1:5, ], startRow = 2, colNames = FALSE) openxlsx::saveWorkbook(wb, "newBook.xlsx", overwrite = TRUE)
sessionInfo()