Hi, Purple:
I suggest you to use the import dataset menu. You can click in the upper left menu File > Import Dataset > From Excel and select the file to import it. Then you can copy the code that appears in the R console with the code required for import the data in xlsx and then copy it in a R Markdown code chunk.
Hope it helps.
Greetings.