read_excel_multiline: Read excel datasets with column names in multiple lines

In avallecam/epihelper: Miscelanea of Custom Funtions From Epidemiology

Read excel datasets with column names in multiple lines

Description

read multiline excel files

Usage

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

Details

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

Value

tibble with the column names from multiple lines

References

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

See Also

read_excel

Examples

## Not run: 

# 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)


## End(Not run)

avallecam/epihelper documentation built on March 1, 2024, 9:18 a.m.