Skip to content

XlsxReader doesn't respect calculated tableArea for header column names #887

@lujop

Description

@lujop

There is a buggy condition on some excels when there are blank columns at the start of the sheet.

When es.decide.toolbox.util.XlsxReader#createTable calculates header names it uses a for(Cell cell : row) instead of using the supplied tableArea parameters.

And when there are some blank columns it doesn't always work. I don't know exactly why, but sometimes the first blank column is discarded in the iterator, but sometimes although all values are blank poi maintains the column, and the code doesn't work correctly detecting the header column names.

To calculate the header column names the code should use the tableArea.startColumn and tableArea.endColumn

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions