Aan de slagGa gratis aan de slag

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.

Deze oefening maakt deel uit van de cursus

Introduction to Importing Data in R

Cursus bekijken

Oefeninstructies

  • Use createSheet(), to create a new sheet in my_book, named "data_summary".
  • Use getSheets() to verify that my_book now represents an Excel file with four sheets.

Praktische interactieve oefening

Probeer deze oefening eens door deze voorbeeldcode in te vullen.

# Build connection to urbanpop.xlsx
my_book <- loadWorkbook("urbanpop.xlsx")

# Add a worksheet to my_book, named "data_summary"
___

# Use getSheets() on my_book
___
Code bewerken en uitvoeren