Read excel datasets with column names in multiple lines

read multiline excel files

read_excel_multiline(filename, row_collapse = 1, ...)

Arguments

filename

excel filename

row_collapse

number of rows to collapse

...

additional parameter(s) passed on to readxl::read_excel

Value

tibble with the column names from multiple lines

Details

This function reads multiline Excel files using the solution proposed by brianwdavis.

References

See the solution proposed by brianwdavis: https://github.com/tidyverse/readxl/issues/486#issuecomment-398224438

See also

read_excel

Examples

if (FALSE) {

# example ---------------------------------------------------

#library(readxl)

#file_path <- "https://github.com/brianwdavis/public/raw/master/example.xlsx"
#download.file(file_path, "example.xlsx", mode = "wb")
#read_excel_multiline("example.xlsx", row_collapse = 2)

}