Before diving into the "how," let's understand the "why."
install.packages("tinytex") tinytex::install_tinytex()
# Sales Analysis Data sourced from `Q3_Report.xlsx` on `r Sys.Date()`.
Using R as the "middleman" between Excel and PDF offers several advantages over doing it manually:
R Through Excel: A Spreadsheet Interface for Statistics, Data Analysis, and Graphics by Heiberger and Neuwirth. Semantic Scholar RExcel Add-in: