loadWorkbook - R

Question

Good afternoon,

I am developing a code that performs the update of a spreadsheet called BD of a file . xlsx

This file has several tabs, each with its specific formatting.

I am having trouble keeping original file formatting when exporting it

Is there any way to save the original formatting before exporting the file ? I performed a lot of research before putting in the forum.

Follows where I read and export:

MIX <- loadWorkbook(file = "C:/Users/Desktop/TESTE SHEETS/REPLAN - MIX DE NEGOCIAÇÕES.xlsx")
saveWorkbook(MIX, "C:/Users/Desktop/TESTE SHEETS/REPLAN - MIX DE NEGOCIAÇÕES_TESTE.xlsx", overwrite = TRUE)