Reading sheets without column headings

[robertfeldt]

Thanks for a useful package.

I just got a large excel file where the data has been split into separate sheets so only the first sheet has column headings. Is there a way I can manually give the column headings/names when reading in a sheet? (This way I can read the first sheet and then use its column headings when reading the other sheets)

Thanks for any pointers.

[hhaensel]

I would do it this way:

data = reduce(vcat, readxlsheet.(Ref(f), f.workbook.sheet_names()))
df = DataFrame(data[2:end, :], string.(data[1, :]))