extrange wrong error when disableXLSXNumberCellFormat is true

[dacopan]

Currently when try parse attached files we have a error on parse number cells

1. java.lang.NullPointerException: Cannot invoke "String.length()" because "address" is null
2. java.lang.ArrayIndexOutOfBoundsException: Attempt to modify attribute at illegal index: 5

autos2.xlsx
autos3.xlsx

After exhaustive debuggin I can find that when

poiji/src/main/java/com/poiji/bind/mapping/XSSFSheetXMLPoijiHandler.java

Line 59 in 65a9395

if (poijiOptions.isDisableXLSXNumberCellFormat()) {

this line run, somethings extrange and errors occurs after pass this line

[github-actions]

Thank you for contributing to Poiji! Feel free to create a PR If you want to contribute directly :)

[ozlerhakan]

Hi @dacopan ,

I'll look at the problem, thank you!

[ozlerhakan]

can you share your entity model and all code you run as well @dacopan ?

[dacopan]

Hi, sorry by the late, this is my Entity, UqaiExcelBase has only rowIndex
please tell me if you need more info

package com.uqai.excelutil.dto;

import com.poiji.annotation.ExcelCell;
import com.poiji.annotation.ExcelCellName;

import java.math.BigDecimal;
import java.time.LocalDate;

/**
 * @author dacopan on 19/3/22
 */
public class AutoImport extends UqaiExcelBase {

    //marca	modelo	cilindraje	fabricacion	activo	valor	celular
    @ExcelCellName(value = "fabricacion", mandatory = false)
    private LocalDate fecha;

    @ExcelCell(0)
    private String clase;

    @ExcelCell(1)
    private String tipo;

    @ExcelCell(2)
    private String subtipo;

    @ExcelCell(3)
    private String marca;

    @ExcelCell(4)
    private String modelo;

    @ExcelCell(5)
    private String submodelo;

    @ExcelCell(6)
    private String dsc;

    @ExcelCell(7)
    private Double pmercado;

    @ExcelCell(8)
    private Double ptoma;

    @ExcelCell(9)
    private String anio;

    @ExcelCell(10)
    private String cil;

    @ExcelCell(11)
    private String com;

    @ExcelCell(12)
    private String tp;

    @ExcelCell(13)
    private Integer pasajeros;

    @ExcelCell(14)
    private Integer puertas;

    // todo Zonedateime
    // todo BigDecimal

}

[dacopan]

please see this repo https://github.com/dacopan/poiji-error-demo
in Test package you can change autos2 and autos3 both show strange error derivated of the reported error
Note.- Sorry by the bad code, it's a starter library I'm testing

[ozlerhakan]

thank you @dacopan , I see what It causes!

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

[falko]

@ozlerhakan any news on this? I'm also getting an ArrayIndexOutOfBoundsException: Attempt to modify attribute at illegal index 3 when using disableXLSXNumberCellFormat() to parse into a double.

[ozlerhakan]

Hi @falko , could you please share with me your excel file and model class?