Question: How to get all cells & rows?

[jordyvandomselaar]

As the title says, how to get all rows and their cells? I don't know beforehand how many rows or cells there'll be.

[xuri]

@jordyvandomselaar Thanks for your issue. You can use GetRows to get all the rows in a sheet like this:

rows, err := f.GetRows("Sheet1")
if err != nil {
    fmt.Println(err)
    return
}
for _, row := range rows {
    for _, colCell := range row {
        fmt.Print(colCell, "\t")
    }
    fmt.Println()
}

The full API docs can be seen on go.dev. If you have any questions or concerns, please let me know by replying to this issue.

[jordyvandomselaar]

Hmm, kept returning an empty slice.

[xuri]

@jordyvandomselaar Verify that the given sheet index is valid or attach your code and .xlsx file if possible.

[jordyvandomselaar]

I ended up using another lib, but I ran the functions to get the active sheet name which I used in getRows()