# XLSX.jl ignores stop\_in\_empty\_row

**URL:** <https://discourse.julialang.org/t/xlsx-jl-ignores-stop-in-empty-row/134712>\
**Category:** General Usage\
**Tags:** xlsx\
**Created:** [December 23, 2025, 5:32pm UTC](https://discourse.julialang.org/t/xlsx-jl-ignores-stop-in-empty-row/134712 "2025-12-23T17:32:44Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Eben60](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/eben60/32/13475_2.png) [@Eben60](https://discourse.julialang.org/u/Eben60)\
**Post date:** [December 23, 2025, 5:32pm UTC](https://discourse.julialang.org/t/xlsx-jl-ignores-stop-in-empty-row/134712/1 "2025-12-23T17:32:44Z")

</div>

This is my file `f3`: an excel table, made with LibreOffice :

```julia-auto
id	val1	val2
		
		
1	1.5	4.5
2	2.5	7.5
		
3	3.5	10.5
4	4.5	13.5

```

And that is what I get when I read it:

```julia-auto
julia> DataFrame(XLSX.readtable(f3, "Sheet1"; header=true, stop_in_empty_row=false, keep_empty_rows=true))
0×3 DataFrame
 Row │ id val1 val2 
     │ Any Any Any  
─────┴─────────────────

```

Apparently both relevant kwargs are ignored. Any ideas?

---

<div class="post-metadata">

**Author:** ![TimG](https://avatars.discourse-cdn.com/v4/letter/t/82dd89/32.png) [@TimG](https://discourse.julialang.org/u/TimG)\
**Post date:** [December 23, 2025, 5:59pm UTC](https://discourse.julialang.org/t/xlsx-jl-ignores-stop-in-empty-row/134712/2 "2025-12-23T17:59:19Z")

</div>

Are you using the release version (v0.10.4)? This is broken there for entirely empty rows, but would work if there was a cell in the row outside the range of the table. I think this is fixed in the Dev version (v0.11.0), but I can’t find a reference for that now. I’ll post back here shortly when I find it.

Here it is! [The readtable function doesn’t respect ‘keep\_empty\_rows’ · Issue #312 · felipenoris/XLSX.jl](https://github.com/felipenoris/XLSX.jl/issues/312)

---

<div class="post-metadata">

**Author:** ![TimG](https://avatars.discourse-cdn.com/v4/letter/t/82dd89/32.png) [@TimG](https://discourse.julialang.org/u/TimG)\
**Post date:** [December 23, 2025, 6:11pm UTC](https://discourse.julialang.org/t/xlsx-jl-ignores-stop-in-empty-row/134712/3 "2025-12-23T18:11:18Z")

</div>

> [@Eben60](#):
>
> ```julia-auto
> XLSX.readtable(f3, "Sheet1"; header=true, stop_in_empty_row=false, keep_empty_rows=true))
> 0×3 DataFrame
> 
> ```

But I see it still doesn’t work with blank leading rows… 😒

---

<div class="post-metadata">

**Author:** ![Jeff\_Emanuel](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/jeff_emanuel/32/15440_2.png) [@Jeff\_Emanuel](https://discourse.julialang.org/u/Jeff_Emanuel)\
**Post date:** [December 23, 2025, 6:37pm UTC](https://discourse.julialang.org/t/xlsx-jl-ignores-stop-in-empty-row/134712/4 "2025-12-23T18:37:19Z")

</div>

Nevermind, _moving to github_

---

<div class="post-metadata">

**Author:** ![Eben60](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/eben60/32/13475_2.png) [@Eben60](https://discourse.julialang.org/u/Eben60)\
**Post date:** [December 23, 2025, 6:58pm UTC](https://discourse.julialang.org/t/xlsx-jl-ignores-stop-in-empty-row/134712/5 "2025-12-23T18:58:23Z")

</div>

OK, then I just assume it will be fixed soon, and move on. Thank you 🙂

---

<div class="post-metadata">

**Author:** ![TimG](https://avatars.discourse-cdn.com/v4/letter/t/82dd89/32.png) [@TimG](https://discourse.julialang.org/u/TimG)\
**Post date:** [December 24, 2025, 12:39pm UTC](https://discourse.julialang.org/t/xlsx-jl-ignores-stop-in-empty-row/134712/6 "2025-12-24T12:39:56Z")

</div>

I’ve made a [further PR](https://github.com/felipenoris/XLSX.jl/pull/339) to resolve all (known) remaining issues with this.

I cannot merge PRs and nor can I make new releases, so I can’t make any statement about whether or when this PR may make it into the Dev version or a new release.