Columns argument in XLSX.readtable() not recognized about xlsx.jl HOT 3 CLOSED

Thanks for reporting this bug!
I think this API got lost in some update. Now you can use it as described in the docs. But be aware that columns is not a keyword parameter. So your code would work like this:

df = DataFrame(XLSX.readtable("my_data.xlsx", "raw_data", "C"; first_row=20, header=true)...)

from xlsx.jl.

Hi, felipenoris,
I'm a little puzzle about how to select multi-column which are not coninuous.
For example, i've tried "C G", ":C :G", "CG", but all wrong.
Can you add an example about this in document?

I'm using julia 1.4.2 and XLSX 0.7.2.
Thank u.

from xlsx.jl.

@AndyYangjd non-continuous column ranges are not supported. I'll update the docs on that. Thanks!

from xlsx.jl.