Courses
R for Excel Users

Read and write Excel files using openxlsx. Define the formatting of the columns, and create custom styling for the sheets.

Read and Write Excel Files

Outline
The read.xlsx() Function
Exercise: Read Excel Tables
The write.xlsx() Function
Quiz: The write.xlsx() Function
Save Data Frames as Excel Tables
Exercise: Write Excel Tables

Specify Column Formatting

Outline
Define Column Classes
Exercise: Define Column Classes
Date Formatting Options
Exercise: Date Formatting Options
Column Formatting with openxlsx Workbooks
Exercise: Column Formatting with openxlsx Workbooks

Add Images to Worksheets

Outline
Insert Image Files
Quiz: Insert Image Files
Exercise: Insert Image Files
Insert Plots
Excercise: Insert Plots

Create Excel Files from Scratch

Outline
Create and Save a Workbook
Exercise: Create and Save a Workbook
Add Worksheets to a Workbook
Exercise: Add Worksheets to a Workbook
Insert Data into Worksheets
Exercise: Insert Data into Worksheets
Load Excel Files as Workbooks
Exercise: Load Excel Files as Workbooks

Create Custom Styling

Outline
Define Styling Objects
Exercise: Styling Objects
Header Styling
Exercise: Header Styling
Cell Specific Styling of Worksheets
Exercise: Cell Styling
Combining Cell Formatting and Styling
Exercise: Style Stacking

Define Excel Formulas

Outline
Assign a Formula to a Cell
Exercise: Insert Formula
Assign Formulas to Multiple Cells
Quiz: Insert Multiple Formulas
Assign the Formula Class to a Column
Exercise: Formula Columns

We don't support your browser anymore

Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.