Java excel 导入功能

最新推荐文章于 2023-02-12 17:05:49 发布

Java_攻城狮

最新推荐文章于 2023-02-12 17:05:49 发布

阅读量1k

点赞数 1

分类专栏： Java 服务端文章标签： eacel导入 java 后台

本文链接：https://blog.csdn.net/u014266877/article/details/53691572

版权

Java 同时被 2 个专栏收录

31 篇文章 1 订阅

订阅专栏

服务端

31 篇文章 0 订阅

订阅专栏

/**
     * 导入数据
     * @param path
     */
    @SuppressWarnings("static-access")
    @ResponseBody
    @RequestMapping(value = "/interfaceLeadingIn")
    public JSONObject interfaceLeadingIn(HttpServletRequest request, String path){
        JSONObject json = new JSONObject();
        String returnCode = new String();
        try {
            String loginAccount = (String) request.getSession().getAttribute("userName");//登陆帐号
            URL url = new URL(path);
            URLConnection conn = url.openConnection();  
            
            InputStream is = conn.getInputStream();
            XSSFWorkbook hssfWorkbook = new XSSFWorkbook(is);
            List<InterfaceConcludeSign> list = new ArrayList<InterfaceConcludeSign>();
            for (int numSheet = 0; numSheet < hssfWorkbook.getNumberOfSheets(); numSheet++) {
                XSSFSheet hssfSheet = hssfWorkbook.getSheetAt(numSheet);
                if (hssfSheet == null) {
                    continue;
                }
                for (int rowNum = 1; rowNum <= hssfSheet.getLastRowNum(); rowNum++) {
                    XSSFRow hssfRow = hssfSheet.getRow(rowNum);
                    if(hssfRow != null){
                        InterfaceConcludeSign inter = new InterfaceConcludeSign();
                        XSSFCell interface_name = hssfRow.getCell(0);
                        XSSFCell parent_interface_name = hssfRow.getCell(1);
                        XSSFCell son_interface_name = hssfRow.getCell(2);
                        XSSFCell interface_remark = hssfRow.getCell(3);
                        XSSFCell catalog_name = hssfRow.getCell(4);
                        XSSFCell tiny_catalog = hssfRow.getCell(5);
                        XSSFCell out_parameter = hssfRow.getCell(6);
                        XSSFCell put_parameter = hssfRow.getCell(7);
                        
                        XSSFCell buy_price = hssfRow.getCell(8);
                        XSSFCell pack_price = hssfRow.getCell(9);
                        XSSFCell company_name = hssfRow.getCell(10);
                        XSSFCell company_code = hssfRow.getCell(11);
                        XSSFCell company_abutment = hssfRow.getCell(12);
                        XSSFCell company_tel = hssfRow.getCell(13);
                        
                        XSSFCell channel_area = hssfRow.getCell(14);
                        XSSFCell channel_user = hssfRow.getCell(15);
                        Date stime = hssfRow.getCell(16).getDateCellValue();
                        Date etime = hssfRow.getCell(17).getDateCellValue();
                        XSSFCell product_model = hssfRow.getCell(18);
                        XSSFCell type = hssfRow.getCell(19);
                        XSSFCell scope = hssfRow.getCell(20);
                        XSSFCell test_scope = hssfRow.getCell(21);
                        XSSFCell upd_rate = hssfRow.getCell(22);
                        XSSFCell remark = hssfRow.getCell(23);
                        XSSFCell cell_url = hssfRow.getCell(24);
                        XSSFCell test_url = hssfRow.getCell(25);
                        XSSFCell upd_info = hssfRow.getCell(26);
                        XSSFCell platform_price = hssfRow.getCell(27);

                        inter.setPact_sttime(stime);
                        inter.setPact_entime(etime);
                        inter.setCompany_tel(String.valueOf(company_tel));
                        inter.setPlatform_price(String.valueOf(platform_price));
                        inter.setTest_url(String.valueOf(test_url));
                        inter.setUpd_info(String.valueOf(upd_info));
                        inter.setCell_url(String.valueOf(cell_url));
                        inter.setRemark(String.valueOf(remark));
                        inter.setProduct_model(String.valueOf(product_model));
                        inter.setChannel_area(String.valueOf(channel_area));
                        inter.setBuy_price(String.valueOf(buy_price));
                        inter.setPack_name(String.valueOf(pack_price));
                        inter.setCompany_name(String.valueOf(company_name));
                        inter.setCompany_abutment(String.valueOf(company_abutment));
                        inter.setCompany_name(String.valueOf(company_name));
                        inter.setCompany_code(String.valueOf(company_code));
                        inter.setCatalog_name(String.valueOf(catalog_name));
                        inter.setTiny_catalog(String.valueOf(tiny_catalog));
                        inter.setOut_parameter(String.valueOf(out_parameter));
                        inter.setPut_parameter(String.valueOf(put_parameter));
                        inter.setCompany_name(String.valueOf(company_name));
                        inter.setChannel_user(String.valueOf(channel_user));
                        inter.setType(String.valueOf(type));
                        inter.setScope(String.valueOf(scope));
                        inter.setTest_scope(String.valueOf(test_scope));
                        inter.setUpd_rate(String.valueOf(upd_rate));
                        inter.setInterface_remark(String.valueOf(interface_remark));
                        inter.setInterface_name(String.valueOf(interface_name));
                        inter.setSon_interface_name(String.valueOf(son_interface_name));
                        inter.setParent_interface_name(String.valueOf(parent_interface_name));
                        
                        inter.setStatus(1);
                        inter.setAdd_user(loginAccount);
                        inter.setAdd_time(new Date());
                        inter.setIs_show(1);
                        list.add(inter);
                    }
                }
            }
            if(list != null && list.size() > 0){
                int circleInsertInterface = interfaceConcludeSignServiceImpl.circleInsertInterface(list);
                if(circleInsertInterface > 0){
                    returnCode = new String(ReturnCode.LEADINGIN_SUCCESS.toString());
                }else{
                    returnCode = new String(ReturnCode.LEADINGIN_ERROR.toString());
                }
            }else{
                returnCode = new String(ReturnCode.FILE_NULL.toString());
            }
        } catch (Exception e) {
            returnCode = new String(ReturnCode.OPERATE_ERROR.toString());
            e.printStackTrace();
        }
        json = json.fromObject(returnCode);
        return json;
    }

Java 实现导出：http://blog.csdn.net/u014266877/article/details/53691381