Exercise

List the sheets of an Excel file

Before you can start importing from Excel, you should find out which sheets are available in the workbook. You can use the excel_sheets() function for this.

You will find the Excel file latitude.xlsx in your working directory (type dir() to see it). This dataset gives information on the latitude of different countries for two different points in time (Source: Gapminder). If you want to experiment with it yourself on your local system, you can download it here.

Instructions

100 XP

Load the readxl package using library(). It's already installed on DataCamp's servers.
Print out the names of both spreadsheets using the excel_sheets() function.

Take Hint (-30 XP)