如何用Java更新MS Word 2003中嵌入的excel电子表格

Question

我必须更新一个word文档，它以可编辑表格的形式嵌入了excel电子表格。我必须使用Java以编程方式更新这个表，以替换文档中嵌入的excel表中的值。为了获得excel电子表格对象的句柄，我研究了Apache POI（HWPFDocument方法）的所有可能选项，但到目前为止还没有找到任何方法选项可以控制该对象。

Answer 1

我有同样的问题，我一直在寻找，但我没有找到明确的答案，我们如何更新嵌入式excel文件到一个word文件，尝试了许多解决方案后，我找到了一种方法，更新或复制数据到excel嵌入式文件使用POI，也许是晚了，但我希望它能帮助其他人面临同样的问题。下面的代码示例基于此链接中的代码

在本例中，我们有一个word文档（Microsoft Office2007及以上版本），它有两个嵌入式excel文件，我们将用不同的内容（数据）更新这两个文件，

您可以尝试修改此代码以支持Word2003

import org.apache.poi.openxml4j.exceptions.OpenXML4JException;
import org.apache.poi.openxml4j.opc.PackagePart;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.apache.poi.xwpf.usermodel.XWPFDocument;

import java.io.*;
import java.util.List;
import java.util.logging.Logger;

public class UpdateEmbeddedDoc {

    private XWPFDocument doc;
    private File docFile;

    private static final String BINARY_EXTENSION = "xls";
    private static final String OPENXML_EXTENSION = "xlsx";

    private final static Logger LOGGER =
            Logger.getLogger(UpdateEmbeddedDoc.class.getName());

    // Here in the contractor we give the path of the word document (docFilePath) that it contains the excel embedded files
    public UpdateEmbeddedDoc(String docFilePath) throws FileNotFoundException,
            IOException {
        this.docFile = new File(docFilePath);
        if (!this.docFile.exists()) {
            throw new FileNotFoundException("The Word document " + docFilePath + " does not exist.");
        }
        try (FileInputStream fis = new FileInputStream(this.docFile)) {
            // Open the Word document file and instantiate the XWPFDocument class.
            this.doc = new XWPFDocument(fis);
        }
    }

    public void updateEmbeddedDoc(String ExcelFile1, String ExcelFile2) throws OpenXML4JException, IOException {
        List<PackagePart> embeddedDocs = this.doc.getAllEmbeddedParts();

        //in this example we have two embedded excel files the first one it is in first index 0
        //the second excel file will be on the second index 1 (0 based index)
        PackagePart pPart0 = embeddedDocs.get(0);
        PackagePart pPart1 = embeddedDocs.get(1);
        LOGGER.info("embedded first part : " + embeddedDocs.get(0));
        LOGGER.info("embedded second part : " + embeddedDocs.get(1));

        //Here we are calling copyWorkbook method and give the path of the excel file (ExcelFile1 and ExcelFile2 )
        // that it contains the data that we want to copy to embedded execl files (pPart0 and pPart1 )
        copyWorkbook(ExcelFile1, pPart0);
        copyWorkbook(ExcelFile2, pPart1);


        if (!embeddedDocs.isEmpty()) {
            try (FileOutputStream fos = new FileOutputStream(this.docFile)) {
                this.doc.write(fos);
            }
        }


    }

    public void copyWorkbook(String inputExelFilePath, PackagePart pPart) {
        try {

            FileInputStream file = new FileInputStream(inputExelFilePath);
            Workbook workbookInput = new XSSFWorkbook(file);
            String ext = pPart.getPartName().getExtension();

            if (BINARY_EXTENSION.equals(ext) || OPENXML_EXTENSION.equals(ext)) {
                try (
                        OutputStream os = pPart.getOutputStream()) {
                    //Here we write our workbook (excel file) to the outputStream that refer to excel embedded file
                    workbookInput.write(os);

                } catch (IOException e) {
                    LOGGER.severe("Could not update the excel file : " + e.getMessage());
                }
            }

        } catch (IOException e) {
            LOGGER.severe("Could not update the excel file : " + e.getMessage());
        }
    }

public class VdslmopApplication {
    private final static Logger logger = Logger.getLogger(VdslmopApplication.class.getName());

    public static void main(String[] args) {
        // here we provide all the path for the files word document file and the two excel files 
        //its better to provide relative path to the files
        String docFilePath = "docfile/docTest.docx";
        String excelFile1Path = "excelFile/excelFile1.xlsx";
        String excelFile2Path = "excelFile/excelFile2.xlsx";

        try {
            UpdateEmbeddedDoc ued = new UpdateEmbeddedDoc(docFilePath);
            ued.updateEmbeddedDoc(excelFile1Path, excelFile2Path);
            logger.info("Doc file has been successfully updated ");
        } catch (IOException e) {
            e.printStackTrace();
        } catch (OpenXML4JException e) {
            e.printStackTrace();
        }
    }
}