POI导入,导出excel

最新推荐文章于 2024-05-13 13:51:17 发布

少说废话多干活

最新推荐文章于 2024-05-13 13:51:17 发布

阅读量166

点赞数

分类专栏： Java

本文链接：https://blog.csdn.net/qq_24271537/article/details/115391290

版权

本文介绍了如何使用Java的POI库进行Excel的导入和导出操作，包括关键代码示例和注意事项，如文件名在某些情况下可能不生效的问题。

摘要由CSDN通过智能技术生成

导入excel

import org.springframework.web.multipart.MultipartFile; 

    @ApiImplicitParams({
            @ApiImplicitParam(name = "flag", value = "flag", dataType = "int", paramType = "query", example = "")
    })
    @ResponseBody
    @PassLogin //for push
    @RequestMapping(value = "/importExcel", method = RequestMethod.POST)
    public Integer importExcel(@RequestParam MultipartFile  file,Integer flag,HttpServletRequest request) throws IOException{

        boolean FLAG;//身份状态
        Workbook workbook = null;
        try {
            workbook = WorkbookFactory.create(file.getInputStream());
        }catch (Exception e){
            e.printStackTrace();
        }
        Sheet sheet = workbook.getSheetAt(0);  //示意访问sheet
        
        try {
Site,Factory,ParameterType,ProcessOperCode,ProcessEqpType,MeasOperCode,MeasOperCode1,MeasEqpType,MeasEqpType1,ParameterName
            for(Row row : sheet) {

                row.getCell(0).setCellType(Cell.CELL_TYPE_STRING);
                if (StringUtils.isEmpty(row.getCell(0).getStringCellValue())) {
                    break;
                }

                String site = (String) dealCell(row.getCell(0));
                String factory = (String) dealCell(row.getCell(1));
                String parameterType = (String) dealCell(row.getCell(2));


                CharacterValueVo characterValueVo = new CharacterValueVo();
                characterValueVo.setSite(site.toUpperCase());
                characterValueVo.setFactory(factory.toUpperCase());
                characterValueVo.setParameterType(parameterType);
            }
        } catch (Exception e) {
            e.printStackTrace();
            throw new ReportException("导入失败,请检查excel格式是否符合规范!!");
        } finally {
            workbook.close();
        }

        return HttpStatus.SUCCESS;
    }

导出excel


    @ApiImplicitParams({
            @ApiImplicitParam(name = "flag", value = "flag", dataType = "int", paramType = "query", example = "")
    })
    @ResponseBody
    @PassLogin //for push
    @RequestMapping(value = "/excel/exportBankCheckInfo", method = RequestMethod.POST)
    public void exportBankCheckInfo(HttpServletResponse response, HttpServletRequest request,@RequestBody CharacterValueVo characterValueVo,
                                      @RequestHeader(value = "site", required = false) String site) throws Exception {
        try {
            //..........................
            LinkedList<CharacterValueVo> finalList = new LinkedList<>();
            LinkedHashMap<String, String> fieldMap = new LinkedHashMap<>();
            //获取需要转出的excel表头的map字段
                fieldMap.put("site","Site");
                fieldMap.put("factory","factory");
                fieldMap.put("parameterType","parametertype");
                fieldMap.put("processOperCode","processOperCode");

            ExcelUtils2.export(excelName,finalList,fieldMap,response);
            
        }catch (Exception e){
            e.printStackTrace();
        }

    }


import java.io.*;
import java.lang.reflect.Field;
import java.net.URLEncoder;
import java.text.SimpleDateFormat;
import java.util.*;
import org.apache.poi.hssf.usermodel.*;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.s