Renaming sheets
Come to think of it, "data_summary" is not an ideal name. As the summary of these excel sheets is always data-related, you simply want to name the sheet "summary".
The workspace already contains a workbook, my_book, that refers to an Excel file with 4 sheets: the three data sheets, and the "data_summary" sheet.
Este ejercicio forma parte del curso
Importing Data in R (Part 1)
Instrucciones del ejercicio
- Use
renameSheet()to rename the fourth sheet to"summary". - Next, call
getSheets()onmy_bookto print out the sheet names. - Finally, make sure to actually save the
my_bookobject to a new Excel file,"renamed.xlsx".
Ejercicio interactivo práctico
Prueba este ejercicio y completa el código de muestra.
# my_book is available
# Rename "data_summary" sheet to "summary"
# Print out sheets of my_book
# Save workbook to "renamed.xlsx"