3.2 Finer control of Excel imports

You can specify sheet names or sheet positions for import from an Excel file. If you know the sheet name, you can specify it using the which option:

dos_data <- import('data/simulatedDOS.xlsx', which='Staffing_by_Bureau')

You can also grab the same sheet by position:

dos_data <- import('data/simulatedDOS.xlsx', which = 2)

We’ll talk about how to grab multiple sheets together into a list in the data munging section4.