XLSX.DataTable error

General Usage
,
1

My script was running OK while on Julia V1.7. I recently upgraded my Julia to V1.8.5, now I have trouble reading info out of xlsx files. Would anyone please help me out?

Here are the errors:

ERROR: LoadError: MethodError: no method matching iterate(::XLSX.DataTable)
Closest candidates are:
  iterate(::Union{LinRange, StepRangeLen}) at range.jl:872
  iterate(::Union{LinRange, StepRangeLen}, ::Integer) at range.jl:872
  iterate(::T) where T<:Union{Base.KeySet{<:Any, <:Dict}, Base.ValueIterator{<:Dict}} at dict.jl:712
  ...

Based on the Line numbers of the error report, it is the 2nd line of my code below that triggered the above errors.

F2 = "/Volumes/Working/Matlab_setpathFiles/LME/WestCoast.xlsx";
West = DataFrame(XLSX.readtable(F2, "WestCoast_final", header=false)...);
2

I think you just need to remove the ... before the end bracket.

1 Like
3

James is right, see

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

Your issue is unrelated to your Julia version, it appears that in moving to Julia 1.8 you updated XLSX.jl from version 0.7 to 0.8, which is a breaking change.

2 Likes
4

It is working now. Thank you so much for the trick!