Overview of ways to read and create Excel files using R including readxl, writexl, openxlsx, RODBC, ...
2. Read Excel Files
Read Excel files using readxl and learn strategies to deal with complex files and layouts.
3. Write Excel Files
- Writing Excel Files using writexl
- Introduction to openxlsx
- Styling with openxlsx
- Formulas with openxlsx
Write data to Excel quickly using writexl. Create fully-featured Excel files including styles and formulas (and more) using openxlsx.
4. Case Studies
- Create Gapminder report in Excel
- Case Study Fill EBA Stress template
- A dynamic price comparison workbook from willhaben.at
Create custom Excel files based on numerous case studies.