Missing row for XLSX.getdata with a column range.

[jeff-emanuel]

julia> worksheet
143528×15 XLSX.Worksheet: ["..."](A1:O143528) 

julia> XLSX.getdata(worksheet, "A1:O143528") |> size
(143528, 15)

julia> XLSX.getdata(worksheet, "A:O") |> size
(143527, 15)

My row 53 seems to be omitted, but it is only one of 176 all-missing rows.

julia> [i for (i,r) in enumerate(eachrow(XLSX.getdata(worksheet, "A1:O143528"))) if all(ismissing,r)]
176-element Vector{Int64}:
     19
     22
     26
     31
     36
     40
     53
     64
     82
     87
       ⋮

julia> [i for (i,r) in enumerate(eachrow(XLSX.getdata(worksheet, "A:O"))) if all(ismissing,r)]
175-element Vector{Int64}:
     19
     22
     26
     31
     36
     40
     63
     81
     86
       ⋮

XLSX.eachrow(worksheet) also returns only 143527 rows and omits row 53. isempty returns true for 23 of the rows that it does return.

I've only seen this behavior for one worksheet. Let me know if you need more information.

[TimG1964]

I think this is a duplicate of #258.

The eachrow iterator iterates through each row in the internal .xml file. However, Excel does not represent any completely empty row in the xml file at all, so eachrow cannot see it.

<sheetData>
    <row r="2" spans="2:3" x14ac:dyDescent="0.25">
        <c r="B2" t="s">
            <v>0</v>
        </c>
        <c r="C2" t="s">
            <v>1</v>
        </c>
    </row>
    <row r="3" spans="2:3" x14ac:dyDescent="0.25">
        <c r="B3">
            <v>1</v>
        </c>
        <c r="C3" t="s">
            <v>2</v>
        </c>
    </row>
    <row r="5" spans="2:3" x14ac:dyDescent="0.25">
        <c r="B5">
            <v>2</v>
        </c>
        <c r="C5" t="s">
            <v>3</v>
        </c>
    </row>
</sheetData>

Only rows 2, 3 and 5 are represented in the .xml file and only these rows are returned by eachrow. This is a feature not a bug^tm!

The specific issue is fixed with respect to getdata in v0.11.0-Dev. So, using my short example above:

julia> getdata(w, "B:C")
4×2 Matrix{Any}:
  "Col A"  "Col B"
 1         "a"    
  missing  missing
 2         "b"

The docs for eachrow in v0.11.0-Dev contain the following:

Note: The eachrow row iterator will not return any row that
consists entirely of EmptyCells. These are simply not seen
by the iterator. The length(eachrow(sheet)) function therefore
defines the number of rows that are not entirely empty and will,
in any case, only succeed if the worksheet cache is in use.

[TimG1964]

Does this work for you in v0.11.0 or do you see this issue there, too? If the issue is present there, too, can you share the Excel file, please.

Also, note that rows with valid cells beyond column O will show as all missing in your test but will still be returned by eachrow.

[jeff-emanuel]

Thanks! I'll check it out, but it may be a few days. I appreciate your efforts.