Connect to a workbook
When working with XLConnect, the first step will be to load a workbook in your R session with loadWorkbook(); this function will build a "bridge" between your Excel file and your R session.
In this and the following exercises, you will continue to work with urbanpop.xlsx (view), containing urban population data throughout time. The Excel file is available in your current working directory.
This exercise is part of the course
Introduction to Importing Data in R
Exercise instructions
- Load the
XLConnectpackage usinglibrary(); it is already installed on DataCamp's servers. - Use
loadWorkbook()to build a connection to the"urbanpop.xlsx"file in R. Call the workbookmy_book. - Print out the class of
my_bookusing theclass()function. What does this tell you?
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Load the XLConnect package
library(___)
# Build connection to urbanpop.xlsx: my_book
my_book <- ___
# Print out the class of my_book
___