无法在excel文件中写入具有Apache POI的连续单元格值

Question

我不知道为什么我不能用setCellValue（）写2个单元格值，它只更新x1单元格中的1个值，而x2单元格不更新。我有一个文件excel，我想更新这个文件的值，数据来自arraylist listThoaiThang，tt.getNoIbo()和tt.getNgoAimang（）是一个字符串，当日志记录时不是null。

代码在下面，谢谢。

public void writeFile(ArrayList<LLThoaiNoiHat> llList) {
    FileInputStream fis = null;
    try {
        DateFormat dateFormat = new SimpleDateFormat("yyyyMMdd");
        String date1 = dateFormat.format(new Date()).toString();
        File tongHop = new File("Thongke_LL_NOIHAT_VTT_" + date1 + ".xlsx");
        copyFileUsingApacheCommonsIO(new File("Mau_Thongke_LL_NOIHAT_VTT.xlsx"), tongHop);  //copy sample file before edit data
        fis = new FileInputStream(tongHop);
        BufferedInputStream bis = new BufferedInputStream(fis);
        XSSFWorkbook  workbook = new XSSFWorkbook(fis);
        Sheet sheet = workbook.getSheetAt(0);
        fis.close();
        int rowNum = 9;
        Row row;

        ArrayList<LLThoaiThang> listThoaiThang;
        for (LLThoaiNoiHat tnh : llList) {
            row = sheet.getRow(rowNum++);
            int colNum = 2;
            listThoaiThang =tnh.getListThoaiThang();
            for (LLThoaiThang tt :listThoaiThang ) {
                int aa = tt.getThang() / 2+3;
                Cell x1 = row.getCell(aa);
                x1.setCellValue(tt.getNoiBo()); //only first cell ok
                Cell x2 = row.getCell(aa+1);
                x2.setCellValue(tt.getNgoaiMang());//this cell cannot change value and all cell after cannot change value
            }

        }

        FileOutputStream outFile = new FileOutputStream(tongHop);
        workbook.write(outFile);
        outFile.close();
    } catch (Exception ex) {
        ex.printStackTrace();
    }
}

Answer 1

我发现这里的问题是如果你将一个数字值设置为字符串，它将不会在单元格之后更新，我认为这是apache POI的问题，所以答案是：

for (LLThoaiThang tt :listThoaiThang ) {
                int aa = tt.getThang() / 2+3;
                Cell x1 = row.getCell(aa);
                if(!tt.getNoiBo().isEmpty())
                    x1.setCellValue(Double.parseDouble(tt.getNoiBo())); //only this cell ok
                Cell x2 = row.getCell(aa+1);
                if(!tt.getNgoaiMang().isEmpty())
                    x2.setCellValue(Double.parseDouble(tt.getNgoaiMang()));;
}