我正在尝试为xlsx文件设置setcellvalue,程序可以正常工作,没有错误,但是在打开xlsx文件时会引发错误,指出Excel发现了不可读的内容

public boolean setCellData(String sheetName,String colName,int rowNum, String data){
    try{
    fis = new FileInputStream(path);
    workbook = new XSSFWorkbook(path);

    if(rowNum<=0)
        return false;

    int index = workbook.getSheetIndex(sheetName);
    int colNum=-1;
    if(index==-1)
        return false;


    sheet = workbook.getSheetAt(index);


    row=sheet.getRow(0);
    for(int i=0;i<row.getLastCellNum();i++){
        //System.out.println(row.getCell(i).getStringCellValue().trim());
        if(row.getCell(i).getStringCellValue().trim().equals(colName))
            colNum=i;
    }
    if(colNum==-1)
        return false;

    sheet.autoSizeColumn(colNum);
    row = sheet.getRow(rowNum-1);
    if (row == null)
        row = sheet.createRow(rowNum-1);

    cell = row.getCell(colNum);
    if (cell == null)
        cell = row.createCell(colNum);

    // cell style
    //CellStyle cs = workbook.createCellStyle();
    //cs.setWrapText(true);
    //cell.setCellStyle(cs);

    cell.setCellValue(data);

    fileOut = new FileOutputStream(path);

    workbook.write(fileOut);
    fileOut.close();

    }
    catch(Exception e){
        e.printStackTrace();
        return false;
    }
    return true;
}

最佳答案

您已经初始化FileInputStream,但是没有使用它。请更换

fis = new FileInputStream(path);
workbook = new XSSFWorkbook(path);


fis = new FileInputStream(path);
workbook = new XSSFWorkbook(fis);

这对我有效,并且没有显示任何错误。

09-10 20:56