Dom4j创建Excel解压目录里的xml
【摘要】 /** * 生成xml方法 */public static void createXml(String sheetName) { try { // 1、创建document对象 Document document = DocumentHelper.createDocument(); // 2、创建根节点worksheet /...
/** * 生成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失败"); } }
【版权声明】本文为华为云社区用户原创内容,未经允许不得转载,如需转载请自行联系原作者进行授权。如果您发现本社区中有涉嫌抄袭的内容,欢迎发送邮件进行举报,并提供相关证据,一经查实,本社区将立刻删除涉嫌侵权内容,举报邮箱:
cloudbbs@huaweicloud.com
- 点赞
- 收藏
- 关注作者
评论(0)