Excel ::String cell value is not getting concatenated with integer in java

Question

In this below code, tried to create a 10 cells with String value which will be sequentially increased like "BRT_1", "BRT_2", "BRT_3"...."BRT_10". But in excel, only BRT_ is entered not the integer value concatenated with "BRT_".

        for(r=1;r<10;r++)
        {
            sh.createRow(r);
            for(c=0;c<body.size();c++)
            {
                String value = body.get(c).toString();
                if(value == "BRT_")
                {
                    sh.getRow(r).createCell(c).setCellValue(value+r);
                }
                else
                    sh.getRow(r).createCell(c).setCellValue(value);
            }
        }

you must use the .equals method to compare two strings: if (value.equals("BRT_")) — jalynn2, Nov 18 '19 at 19:14
This is because `if(value == "BRT_")` will never be true since `==` is not the correct way to test for `String` equality. Correct way to do so is `if("BRT_".equals(value))`. — Axel Richter, Nov 18 '19 at 19:14

score 1 · Answer 1 · answered Nov 18 '19 at 19:18

1

Replace

if(value == "BRT_")
{
    sh.getRow(r).createCell(c).setCellValue(value+r);
}

with

if("BRT_".equals(value))
{
    sh.getRow(r).createCell(c).setCellValue(value+String.valueOf(r));
}

answered Nov 18 '19 at 19:18

Arvind Kumar Avinash

71,965
6
74
110

Thanks @Arvind..yes i replaced. – Wasim Nov 18 '19 at 19:40

Excel ::String cell value is not getting concatenated with integer in java

1 Answers1