保存xlsx文件java poi时获取xmlvaluedisconnectedexception错误

Question

save.addActionListener(new ActionListener() {

        public void actionPerformed(ActionEvent e) {
            String excelFilePath = "sample.xlsx";
            FileInputStream inputStream = null;
            try {
                inputStream = new FileInputStream(new File(excelFilePath));
            } catch (FileNotFoundException e1) {
                e1.printStackTrace();
            }

            Workbook workbook = null;
            try {
                workbook = new XSSFWorkbook(inputStream);
            } catch (IOException e1) {
                e1.printStackTrace();
            }

            //Sheet sheet = workbook.getSheetAt(0);
            for (int i = 0; i < workbook.getNumberOfSheets(); i++) {
                Sheet sheet = workbook.getSheetAt(i);

                Iterator<Row> iterator = sheet.iterator();
                Row row = sheet.getRow(0);
                while (iterator.hasNext()) {
                    Row nextRow = iterator.next();

                    Iterator<Cell> cellIterator = nextRow.cellIterator();
                    Iterator<Cell> scellIterator = nextRow.cellIterator();

                    cellIterator.next();
                    scellIterator.next();
                    scellIterator.next();
                    Cell topicsCell = cellIterator.next();
                    Cell topicSentimentCell = scellIterator.next();

                    String cellContents = topicsCell.getStringCellValue();
                    String scellContents = topicSentimentCell.getStringCellValue();

                    String[] topics = cellContents.split(";");
                    String[] topicSentiment = scellContents.split(";");


                    for (int in = 0; in < topics.length; in++) {
                        Cell cell = row.getCell(in);
                        cell.setCellValue(textArea.getText());
                    }


                }

                try {
                    workbook.write(new FileOutputStream("sample.xlsx"));
                } catch (IOException e1) {
                    e1.printStackTrace();
                }

            }
        }
    });

错误

Answer 1

我知道这是个老问题，但它可以帮助某人。

当尝试两次写入同一文件时，会发生XmlValueDisconnectedException。当我尝试将Word转换成PDF格式时，就发生了这种情况。以下是帮了我的忙：

>

首先，我必须更新所有Opensagres和Apache Poi依赖项的版本。

    FileInputStream is = FileUtils.openInputStream( templateFiles.get( 
    ConstantManager.FILE_NAME ) );
    XWPFDocument document = new XWPFDocument( is );
    tmpDoc = File.createTempFile( "tmp", "docx" );
    //replace body elements here...

    //write this into docx
    tmpDocx = File.createTempFile( "tmpDocx", "docx" );
    FileOutputStream out = new FileOutputStream( tmpDocx );
    document.write( out );
    out.close();
    PdfOptions options = PdfOptions.create();
    //KEY PART!!!           
    //it is not allowed to write into a document two times - 
    //org.apache.xmlbeans.impl.values.XmlValueDisconnectedException
    //that's why I have to reload a workbook from the file
    document = new XWPFDocument( new FileInputStream( tmpDocx ) );

    //and then convert to pdf
    FileOutputStream fos = new FileOutputStream( tmpDoc );
    PdfConverter.getInstance().convert( document, fos, options );
    fos.close();
    is.close();
    document.close();