Dom4j创建Excel解压目录里的xml

/**
 * 生成xml方法
 */
public static void createXml(String sheetName) {
    try {
        // 1、创建document对象
        Document document = DocumentHelper.createDocument();
        // 2、创建根节点worksheet
        // 3、向worksheet节点添加xmlns属性
        Element worksheet = document.addElement("worksheet", "http://schemas.openxmlformats.org/spreadsheetml/2006/main");
        // 4、生成子节点及子节点内容
        //dimension ref="A1"
        Element dimension = worksheet.addElement("dimension");
        dimension.addAttribute("ref", "A1");
        Element sheetViews = worksheet.addElement("sheetViews");
        Element sheetView = sheetViews.addElement("sheetView");
        //workbookViewId="0"
        sheetView.addAttribute("workbookViewId", "0");
        Element sheetFormatPr = worksheet.addElement("sheetFormatPr");
        //defaultRowHeight="15.0"
        sheetFormatPr.addAttribute("defaultRowHeight", "15.0");
        Element sheetData = worksheet.addElement("sheetData");
        Element row = sheetData.addElement("row");
        row.addAttribute("r", "1");
        Element c = row.addElement("c");
        //r="A1" s="44" t="inlineStr"
        c.addAttribute("r", "A1");
        c.addAttribute("s", "44");
        c.addAttribute("t", "inlineStr");
        Element is = c.addElement("is");
        Element t = is.addElement("t");
        t.setText("<<Back");

        Element row2 = sheetData.addElement("row");
        row.addAttribute("r", "2");
        Element c2 = row2.addElement("c");
        //r="A1" s="44" t="inlineStr"
        c.addAttribute("r", "A1");
        c.addAttribute("s", "44");
        c.addAttribute("t", "inlineStr");
        Element is2 = c2.addElement("is");
        Element t2 = is2.addElement("t");
        t2.setText("测试,
test");
        //尾部内容(
)
        Element hyperlinks = worksheet.addElement("hyperlinks");
        Element hyperlink = hyperlinks.addElement("hyperlink");
        hyperlink.addAttribute("location", "'总体评审结论'!A1");
        hyperlink.addAttribute("ref", "A1");
        //pageMargins bottom="0.75" footer="0.3" header="0.3" left="0.7" right="0.7" top="0.75"
        Element pageMargins = worksheet.addElement("pageMargins");
        pageMargins.addAttribute("bottom", "0.75");
        pageMargins.addAttribute("footer", "0.3");
        pageMargins.addAttribute("header", "0.3");
        pageMargins.addAttribute("left", "0.7");
        pageMargins.addAttribute("right", "0.7");
        pageMargins.addAttribute("top", "0.75");
        // 5、设置生成xml的格式
        OutputFormat format = OutputFormat.createPrettyPrint();
        // 设置编码格式
        format.setEncoding("UTF-8");
        format.setTrimText(true);
        format.setIndent(false);
        format.setNewlines(true);
        format.setNewLineAfterDeclaration(false);//解决声明下空行问题
        // 6、生成xml文件
        File file = new File(TARGET_PATH, sheetName + ".xml");
        XMLWriter writer = new XMLWriter(new FileOutputStream(file), format);
        // 设置是否转义，默认使用转义字符
        writer.setEscapeText(false);
        writer.write(document);
        writer.close();
        System.out.println("生成sheet4.xml成功");
    } catch (Exception e) {
        e.printStackTrace();
        System.out.println("生成sheet4.xml失败");
    }
}