0

I am in the process of automating a number of graphs that are produced where I work through R that are currently in Excel.

Note that for now, I am not able to convince that doing the graphs directly in R is the best solution, so the solution cannot be "use ggplot2", although I will push for it.

So in the meantime, my path is to download, update and tidy data in R, then export it to an existing Excel file where the graph is already constructed.

The way I have been trying to do that is through openxlsx, which seems to be the most frequent recommendation (for instance here). However, I am encountering an issue taht I cannot solve with this way (I asked a question there that did not inspire a lot of answers !).

Therefore, I am going to try other ways, but I seem to mainly be directed to the aforementioned solution. What are the existing alternatives ?

Anthony Martin
  • 767
  • 1
  • 9
  • 28
  • 1
    Personally I use `writexl::write_xlsx` because it is very simple to use. Perhaps you can write to an xlsx that only holds the data, and then make the graphic in a separate xlsx which references the cells in the first xlsx. – Michael Dewar Nov 17 '20 at 13:53
  • I will do the two files solution, even if not optimal. `writexl::write_xlsx` seems to only write a fil, not update it – Anthony Martin Nov 17 '20 at 14:44
  • 1
    Yes. I suggest you read data from wherever, and then write to a clean output file. Separate the stages of your workflow. – Michael Dewar Nov 17 '20 at 14:45

0 Answers0