# XLSX.DataTable error

**URL:** https://discourse.julialang.org/t/xlsx-datatable-error/96993
**Category:** General Usage
**Tags:** question, xlsx
**Created:** [April 3, 2023, 2:54am UTC](https://discourse.julialang.org/t/xlsx-datatable-error/96993 "2023-04-03T02:54:15Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Leon6](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/leon6/32/205483_2.png) [@Leon6](https://discourse.julialang.org/u/Leon6)
#### Post date: [April 3, 2023, 2:54am UTC](https://discourse.julialang.org/t/xlsx-datatable-error/96993/1 "2023-04-03T02:54:15Z")

</div>

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:

```julia
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.

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

```

---

<div class="post-metadata">

### Author: ![jd-foster](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/jd-foster/32/35824_2.png) [@jd-foster](https://discourse.julialang.org/u/jd-foster)
#### Post date: [April 3, 2023, 4:59am UTC](https://discourse.julialang.org/t/xlsx-datatable-error/96993/2 "2023-04-03T04:59:20Z")

</div>

> [@Leon6](#):
>
> `West = DataFrame(XLSX.readtable(F2, "WestCoast_final", header=false)...)`

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

---

<div class="post-metadata">

### Author: ![nilshg](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/nilshg/32/2283_2.png) [@nilshg](https://discourse.julialang.org/u/nilshg)
#### Post date: [April 3, 2023, 5:56am UTC](https://discourse.julialang.org/t/xlsx-datatable-error/96993/3 "2023-04-03T05:56:49Z")

</div>

James is right, see

[https://felipenoris.github.io/XLSX.jl/stable/migration/](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.

---

<div class="post-metadata">

### Author: ![Leon6](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/leon6/32/205483_2.png) [@Leon6](https://discourse.julialang.org/u/Leon6)
#### Post date: [April 3, 2023, 12:17pm UTC](https://discourse.julialang.org/t/xlsx-datatable-error/96993/4 "2023-04-03T12:17:33Z")

</div>

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