Read data from excel starting from second row

General Usage
2

If you know the size of your data, you can explicitly specify the input range:

julia> DataFrame(load("test.xlsx", "Sheet1!A2:B5"))
3×2 DataFrames.DataFrame
│ Row │ test1 │ test2 │
├─────┼───────┼───────┤
│ 1   │ 1.0   │ 4.0   │
│ 2   │ 2.0   │ 5.0   │
│ 3   │ 3.0   │ 6.0   │

edit: looks like it might be better to use ExcelReaders.jl, which skips blank starting lines by default, or allows you to skip some number of lines:
readxlsheet("test.xlsx", "Sheet1", skipstartrows=1) |> DataFrame

1 Like