使用java在excel中的两列中写入多条记录

Question

我有两列，即Excel中的Setup和Request，需要使用java在Excel中写入多行

public void WriteExcelValues() throws IOException {

String Ustr= setup.getText();

String urequest = request.getText();

    File file = new File(System.getProperty("user.dir") 

                            + "/src/main/uat/testdata/FreeTestData.xlsx");

    FileInputStream fis = new FileInputStream(file);

    Workbook workbook = new XSSFWorkbook(fis);

    Sheet sheet = workbook.getSheetAt(0);

    int lastRow = sheet.getLastRowNum();

    int n = 1;

    for (int i = 1; i <= n; i++) {   

        Row row = sheet.getRow(i); 

        Cell cell = row.createCell(8);

        Cell cell1 = row.createCell(9);

        cell.setCellValue(Ustr);

        cell1.setCellValue(urequest);

        //cell.setCellValue("AcknowledgementId"); 

    }

    FileOutputStream fos = new FileOutputStream(file);   

    workbook.write(fos);

    fos.close();

}

例如

上面的代码并不完整，也不满足标准。

Answer 1

Workbook workbook = new XSSFWorkbook();Sheet sheet = workbook.createSheet();Row headerRow = sheet.createRow(0);headerRow.createCell(0).setCellValue("Setupid");headerRow.createCell(1).setCellValue("Request");int cellCount = 10;for (int i = 1; i <= cellCount; i++) {&nbsp; &nbsp; Row row = sheet.createRow(i);&nbsp; &nbsp; row.createCell(0).setCellValue("cell " + i);&nbsp; &nbsp; row.createCell(1).setCellValue("cell " + i);}File file = new File(System.getProperty("user.dir")&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; + "/src/main/uat/testdata/FreeTestData.xlsx");if(file.exists()) {&nbsp; &nbsp; file.delete();}file.createNewFile();FileOutputStream fos = new FileOutputStream(file);workbook.write(fos);fos.close();workbook.close();

Answer 2

我认为你的 for 循环不正确&nbsp;for(int&nbsp;i=1;&nbsp;i<=n;&nbsp;i++){它应该是for(int&nbsp;i=1;&nbsp;i<=lastRow;&nbsp;i++){