How can I merge multiple sheets of an excel workbook in r?
<p>Let's say I have an excel file called report.xlsx. This file has 10 sheets, conveniently named Sheet1 through Sheet10. On each sheet, on row 14 there are the column headers: S/N, RegistryNr, Surname, FirstName, (empty), FatherName, MotherName, sex, (empty), DOB. How can I merge every sheet into one dataset?</p>

<p>I know that with <code>excel_sheets("report.xlsx")</code> I can get all the sheet names into a vector.</p>

<p>I know that with <code>df &lt;- read_excel("report.xlsx", 1, skip = 14)</code> I can get all the data of one sheet into data frame df.</p>

<p>That's the extent of my knowledge in R :/</p>

<p>How do I combine the above commands to import every sheet into the same data frame?</p>