Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Reading from a file
Reading from an Excel file
12. Loading Excel from just one sheet


The data is stored across several sheets; each of Q1, Q2, Q3, and Q4 stores the data for one quarter. What if we want data for the second quarter (Q2)? We just pass "Q2" to the sheet parameter, as shown below:

q2_iron_baron <- read_excel("data/iron_baron_mines.xlsx", sheet="Q2")


Read second quarter (Q2) data from data/mount_venture_company.xlsx into the q2_mount_venture variable. Use read_excel() and specify the Q2 sheet.