ERROR: AssertionError: Invalid column range

felipenoris / XLSX.jl

Excel file reader and writer for the Julia language.

https://felipenoris.github.io/XLSX.jl/stable

Other

273 stars 57 forks source link

ERROR: AssertionError: Invalid column range #175

Open Nosferican opened 3 years ago

Nosferican commented 3 years ago

using Downloads: download
using XLSX: XLSX, readtable

download("https://www.bls.gov/oes/oes_2019_hybrid_structure.xlsx", "oes_2019_hybrid_structure.xlsx")
oews_hybrid = DataFrame(readtable("oes_2019_hybrid_structure.xlsx"), "OES2019 Hybrid", "A6:I874"))
ERROR: AssertionError: Invalid column range: A6:I874.

This file has the first few rows with notes on the A column and then a table. It seems the package is making some wrong assumptions which trigger the AssertionError.

hdavid16 commented 2 years ago

Have you used the first_row keyword argument?