Add worksheet
Where readxl
and gdata
were only able to import Excel data, XLConnect
's approach of providing an actual interface to an Excel file makes it able to edit your Excel files from inside R. In this exercise, you'll create a new sheet. In the next exercise, you'll populate the sheet with data, and save the results in a new Excel file.
You'll continue to work with urbanpop.xlsx
(view). The my_book
object that links to this Excel file is already available.
This exercise is part of the course
Introduction to Importing Data in R
Exercise instructions
- Use
createSheet()
, to create a new sheet inmy_book
, named"data_summary"
. - Use
getSheets()
to verify thatmy_book
now represents an Excel file with four sheets.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Build connection to urbanpop.xlsx
my_book <- loadWorkbook("urbanpop.xlsx")
# Add a worksheet to my_book, named "data_summary"
___
# Use getSheets() on my_book
___