1

I am trying to find a way to take a snapshot of a given cell range within an Excel workbook, that has been created by openxlsx in R, and generate a picture file with that snapshot. I have seen many posts about how to insert pictures into Excel, and one post about how to create a snapshot/chart combo however no luck with a simple picture export. Is there an openxlsx code, or other R package, that can assist with this?

Brandon
  • 47
  • 5
  • 1
    Maybe this would be helpful: https://stackoverflow.com/questions/43095645/how-to-export-an-excel-sheet-range-to-a-picture-from-within-r –  Dec 20 '19 at 18:59
  • @Adam This is the question I saw that generates a picture/chart combo. It is close to what I am looking for however I don't have a need for the autogenerated chart attached to the image. – Brandon Dec 20 '19 at 19:07
  • Do you need the formatting as in the spreadsheet - or is it enough to have the relevant data in a grid on your image? – G5W Jan 04 '20 at 00:44

0 Answers0