Excel Workbook Creation and Formatting in R by Rick Pack

R packages like openxlsx and readxl enable reading Microsoft Excel files (.xls or .xlsx) and writing such files with features like conditional formatting and worksheet-specific output. I will show data concerning the local TriPASS and Research Triangle Analysts groups using the Meetup API (meetupr package) and how to use functions to output Excel files with the aforementioned features in an automated way. Data will sometimes be manipulated with local data scientist Ian Cook's tidyquery R package, which enables running SQL queries on R data frames.

Rick Pack is a Data Scientist in Raleigh / Durham, NC who uses R, SAS, SQL, and Alteryx to perform a variety of business and population health analyses at LabCorp, including those supporting accountable care organizations (ACOs) and healthcare providers. He has a Master’s of Applied Statistics from Penn State University and over 10 years of data science experience.