java - 如何使用 JSONArray 和 POI 填充 excel 而不会出现错误警告

Question

正在使用POI生成Excel并循环JSON数组以填充单元格中的值我的 JSON 数组结构如下所示

[[1,"A","0","6","0","6"],[2,"B","3","3","0","6"],[3,"C","3","0","0","3"],[4,"D","4","0","0","4"],[5,"E","3","6","0","9"],[6,"F","3","6","0","9"],[7,"G","3","3","0","6"],[8,"H","3","0","0","3"],[9,"I","3","3","0","6"],[10,"J","2","0","0","2"],[11,"L","3","0","0","3"],[12,"M","3","0","0","3"],[13,"N","3","0","0","3"],[14,"O","3","0","0","3"],[15,"P","3","0","0","3"],[16,"R","3","0","0","3"]]

这个数组像这样循环

for(int i=0;i<jsonArray.length();i++){
            Row row = sheet.createRow(rowCount);
            JSONArray array = jsonArray.getJSONArray(i);
            JSONObject jsonObject = jsonArray.getJSONObject(i);
            for(int j=0;j<array.length();j++) {
                Cell  cell = row.createCell(j);
                cell.setCellType(Cell.CELL_TYPE_STRING);
                cell.setCellValue(array.getString(j));
            }

}

这里 Excel 中的数据是动态的，它可能包含数字或任何内容，但我将其打印到 Excel，如下所示 cell.setCellValue(array.getString(j)) 这会导致类似的警告excel 中的内容(即该单元格中的数字前面带有撇号)生成的 excel 可能包含数字 float 、字符串甚至 double 。我该如何解决此问题请帮助我解决此问题。

Answer 1

方法Cell.setCellValue()有多种风格，即根据您传入的参数类型，它将创建文本单元格、数字单元格、 boolean 值或任何其他支持类型。

当您传入字符串时，POI 会在 Excel 工作簿中创建一个文本单元格。如果在填充单元格之前将字符串转换为数字(POI 使用 double 来允许 float 值)，它将被写入数字单元格，这应该会消除 Excel 中的警告。

请参阅javadoc了解详情