# Error reading an XLSX file

**URL:** <https://discourse.julialang.org/t/error-reading-an-xlsx-file/85352>\
**Category:** Visualization\
**Tags:** question, dataframes, xlsx\
**Created:** [August 5, 2022, 3:19pm UTC](https://discourse.julialang.org/t/error-reading-an-xlsx-file/85352 "2022-08-05T15:19:19Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![RaquelSantos](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/raquelsantos/32/3668_2.png) [@RaquelSantos](https://discourse.julialang.org/u/RaquelSantos)\
**Post date:** [August 5, 2022, 3:19pm UTC](https://discourse.julialang.org/t/error-reading-an-xlsx-file/85352/1 "2022-08-05T15:19:19Z")

</div>

Hello everybody

I’m having trouble reading the fields from my XLSX file, when I try this error message appears: MethodError: no method matching iterate(::XLSX.DataTable)

```julia
using DataFrames, XLSX

r = string(@ __DIR__ ,"\\teste.xlsx"); XLSX.readxlsx(r)
raquel = DataFrame(XLSX.readtable(r, "raquel")...) MethodError: no method matching iterate(::XLSX.DataTable)

```

XLSXFile(“teste.xlsx”) containing 3 Worksheets

```julia
               raquel 4x1 A1:A4        
               andrea 4x1 A1:A4        
               arthur 4x1 A1:A4 

```

---

<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:** [August 5, 2022, 3:23pm UTC](https://discourse.julialang.org/t/error-reading-an-xlsx-file/85352/2 "2022-08-05T15:23:20Z")

</div>

You are using outdated syntax, see:

[https://felipenoris.github.io/XLSX.jl/stable/migration/](https://felipenoris.github.io/XLSX.jl/stable/migration/)

or the docstring:

```julia
help?> XLSX.readtable()
  readtable(
      filepath,
      sheet,
      [columns];
      [first_row],
      [column_labels],
      [header],
      [infer_eltypes],
      [stop_in_empty_row],
      [stop_in_row_function]
  ) -> DataTable

  Returns tabular data from a spreadsheet as a struct XLSX.DataTable. Use this function to create a DataFrame from package DataFrames.jl.

(...)

Example
  ≡≡≡≡≡≡≡≡≡

  julia> using DataFrames, XLSX

  julia> df = DataFrame(XLSX.readtable("myfile.xlsx", "mysheet"))

```

---

<div class="post-metadata">

**Author:** ![RaquelSantos](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/raquelsantos/32/3668_2.png) [@RaquelSantos](https://discourse.julialang.org/u/RaquelSantos)\
**Post date:** [August 8, 2022, 6:20pm UTC](https://discourse.julialang.org/t/error-reading-an-xlsx-file/85352/3 "2022-08-08T18:20:58Z")

</div>

Thanks!!