openxlsx

Read and write files from R, starting with Excel files

Introduction The purpose of this guide is to highlight the many ways to read and write Excel files from R, and discuss alternatives along the way. Bad (but easy) approaches Import Dataset button In RStudio’s Environment pane there is an ‘Import Dataset’ button. Use this button if you are only ever going to read in the data once and are going to write less than 10 lines of code. It requires the TidyVerse to be installed.