Java 实现Excle表转成XML格式如何读取和写入xml文件？

风陵渡W

已于 2022-05-31 11:17:40 修改

阅读量443

点赞数

文章标签： java 开发语言

于 2022-05-30 21:51:10 首次发布

本文链接：https://blog.csdn.net/qq_45220508/article/details/125054732

版权

输入sheet表名

package com.brains.crm.i18;

import java.io.*;
import java.util.ArrayList;
import java.util.LinkedHashMap;
import java.util.List;
import java.util.Map;

import org.apache.ofbiz.base.util.Debug;
import org.apache.ofbiz.base.util.UtilValidate;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.apache.poi.ss.usermodel.CellType;

import org.dom4j.io.OutputFormat;
import org.dom4j.io.XMLWriter;

/**
 * @version 1.0
 * @author: wjq
 * @description
 * @date 2022/5/30 12:51
 */
public class ExcelToXml {
    public static void main(String[] args) {
        try {
            InputStream inp = new FileInputStream(new File("D:\\CRM-中英文-王金强.xlsx"));
            String sheetName = "order";
            List<Map<String, String>> list = readExcel(inp, sheetName);
//        dealList(list);
            StringBuffer sb = new StringBuffer();
            sb.append("<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n");
            sb.append("<resource xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:noNamespaceSchemaLocation=\"https://ofbiz.apache.org/dtds/ofbiz-properties.xsd\">\n");

            for (Map<String, String> map : list) {
                if (UtilValidate.isNotEmpty(map.get("KEY"))) {
                    sb.append("     <property key=\"").append(map.get("KEY").replace(" ","")).append("\">\n");
                } else if (UtilValidate.isNotEmpty(map.get("英文"))) {
                    sb.append("     <property key=\"").append(map.get("英文").replace(" ","")).append("\">\n");
                } else {
                    sb.append("     <property key=\"").append(map.get("KEY")).append("\">\n");
                }
                sb.append("         <value xml:lang=\"zn\">").append(map.get("中文")).append("</value>\n");
                sb.append("         <value xml:lang=\"en\">").append(map.get("英文")).append("</value>\n");
                sb.append("         &l