Option to not drop rows containing only missing data

[rben01]

When reading an excel sheet into a dataframe, it can be handy to keep a record of the corresponding row numbers in the original sheet so that you know the origin of each row in your own Julia DataFrame. I would like to use something like this:

df = DataFrame(XLSX.gettable(xl_file[tab_name], xl_args...; xl_kwargs...))
rownum_offset = get(xl_kwargs, :first_row, 1)
df[!, :row_num] .= (1:nrow(df)) .+ rownum_offset

However, because XLSX always drops all non-missing rows, the rows in the DataFrame do not necessarily originate from consecutive rows in the excel sheet, and so this numbering scheme doesn't work.

Ideally XLSX.jl would provide an option to keep all-missing rows so that I could assign row number and then drop those rows myself.

[rben01]

After a quick glance at the source code I think this would require add a keyword argument drop_empty_rows::Bool to eachtablerow (and all functions that eventually call it) and then changing if !isempty(r) to if !(isempty(r) && drop_empty_rows).