XLSX.jl ignores stop_in_empty_row

General Usage
1

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

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> 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?

2

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

1 Like
3

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

4

Nevermind, moving to github

5

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

6

I’ve made a further PR 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.

3 Likes