public static void main(String[] args) { BatchImportUtils batchImportUtils = new BatchImportUtils(); List<Map<String, String>> mapList = batchImportUtils.uploadExcel("D:\\resources\\123.xls", "D:\\resources\\new.xml", null); //如果遇到错误只返回一条信息 if(mapList.size()<2){ String message = mapList.get(0).get("message"); System.out.println(message); }else { } System.exit(0); }
public List<Map<String,String>> uploadExcel(String excelFilePath,String xmlFilePath , HttpServletRequest request){ List<Map<String,String>> mapList = new ArrayList<>(); try { DocumentBuilderFactory factory = DocumentBuilderFactory.newInstance(); DocumentBuilder db = factory.newDocumentBuilder(); // 创建一个Document对象 Document doc = db.parse(xmlFilePath); //获取第一级菜单集合 NodeList chartsList = doc.getElementsByTagName("Table"); //遍历导入Excel文件 File importFile = new File(excelFilePath); //读取文件流 InputStream reanIn = null; if (!importFile.isDirectory()) { //如果是文件 reanIn = new FileInputStream(imp
java读取xml配置文件实现Excel表格批量导入
最新推荐文章于 2023-07-04 14:02:32 发布