java - 需要按预期将长字符串值发送到 Excel

Question

我得到的字符串值是(控制台 View )我的输出是(excel)我需要将输出视为 在Excel中。有什么解决办法吗？

关键字

@Keyword
    public void demoKey(String name) throws IOException{

        FileInputStream fis = new FileInputStream("C:\\Users\\\\Decypha data files\\Demo1.xlsx");
        XSSFWorkbook workbook = new XSSFWorkbook(fis);

        XSSFSheet sheet = workbook.getSheet("Sheet1");
        int rowCount = sheet.getLastRowNum()-sheet.getFirstRowNum();
        Row row = sheet.createRow(rowCount+1);
        Cell cell = row.createCell(0);
        cell.setCellType(cell.CELL_TYPE_STRING);
        cell.setCellValue(name);
        FileOutputStream fos = new FileOutputStream("C:\\Users\\\\Decypha data files\\Demo1.xlsx");
        workbook.write(fos);
        fos.close();

测试用例

String str = arrlist.toString();
str = str.replaceAll("[\\[\\]]", "");
System.out.println(str);
String listString = String.join(", ", str);
String[] arrOfStr = listString.split("\\|");
CustomKeywords.'WriteExcel.demoKey'(listString)
for (String a : arrOfStr)
System.out.println(a);

Answer 1

在 for 循环内调用 demoKey 方法，如下所示。

for(String a:arrOfStr)
{
    System.out.println(a);
    CustomKeywords.`WriteExcel.demoKey'(a);
}