produce excel report with formatted fill colors

[adrianclo]

Hi Ellis and Patrick! I have a question, that might be interesting for a future episode? :)

Related to excel files that we produce on a weekly basis, but where cells that have a different value from the previous week are highlighted with Excel-s fill format. I am going through the openxlsx documentation, but do not seem to find something particular that addresses this question. Perhaps you guys can help :)

Cheers and thanks! Adrian

[meersel]

HI Adrian,

Have you tried the package {tidyxl} ? With this package you can investigate the content of an Excel spreadsheet per cell . For example. does a cell contains a formula, is a cell formatted, etc..

See: https://nacnudus.github.io/tidyxl/index.html

Maybe this is a solution for you.

Regards,

Miguel