csv导入导出组件jcsv

r囧r小猫 2021-10-24 02:34 408阅读 0赞

# jcsv #

#### 介绍 ####

jcsv一个简单的、轻量级的csv导入、导出库，相对于opencsv与javacsv，jcsv侧重于导入导出，包括导入校验、导出模板等。  
源代码地址：https://gitee.com/lpxs/jcsv.git

#### 使用说明 ####

jcsv现在只支持集成到springboot工程中

#### 依赖库 ####

<dependency>
      <groupId>com.github.lipengxs.jcsv</groupId>
      <artifactId>jcsv-spring-boot-starter</artifactId>
      <version>1.0.1</version>
    </dependency>

#### 配置说明 ####

csv-config:
      exportc:
        - id: aa
          compress:
            enabled: true
            file-size: 10000
            type: zip
          template: /template/aa.csv
    
      importc:
        - id: throng-0
          desc : "上传member_id"
          max-size: 30 #单位m
          start-row: 2
          separator: ","
          valicate:
            - {  col: 0, name: member_id,validateRegex: "^\\d{1,10}$", hint: "请填写10位以内的数字",required: true}
        - id: throng-1
          desc : "上传email+语言+站点"
          max-size: 30 #单位m
          separator: ","
          start-row: 2
          valicate:
            - {  col: 0, name: email,required: true,validateRegex: "^[éûàçùôîèíá¡N¿UóñúäöüßàèùåäöãáéàêçíşçöüğşàâäèéêëîïôœùûüÿçÀÂÄÈÉÊËÎÏÔŒÙÛÜŸÇA-Za-z0-9_\\-\\.\\u4e00-\\u9fa5]+@[a-zA-Z0-9_-]+(\\.[a-zA-Z0-9_-]+)+$", hint: "邮箱地址错误"}
            - {  col: 1, name: language ,required: true,hint: "语言错误" ,td-id: 11}
            - {  col: 2, name: site_id,required: true,hint: "站点错误" ,td-id: 13 }
        - id: throng-3
          desc: "上传member_id+占位符"
          max-size: 30 #单位m
          separator: ","
          start-row: 2
          check-column-size: false //该字段是表示不限制字段个数，没有在valicate中配置不需要校验
          valicate:
            - {  col: 0, name: member_id,validateRegex: "^\\d{1,10}$", hint: "请填写10位以内的数字",required: true}
        - id: throng-4
          desc: "上传email"
          max-size: 30 #单位m
          start-row: 2
          separator: ","
          valicate:
            - {  col: 0, name: email,required: true,validateRegex: "^[éûàçùôîèíá¡N¿UóñúäöüßàèùåäöãáéàêçíşçöüğşàâäèéêëîïôœùûüÿçÀÂÄÈÉÊËÎÏÔŒÙÛÜŸÇA-Za-z0-9_\\-\\.\\u4e00-\\u9fa5]+@[a-zA-Z0-9_-]+(\\.[a-zA-Z0-9_-]+)+$", hint: "邮箱地址错误"}

#### 导入 ####

@Autowize
    private CsvContext csvContext;
    public BaseDataAPI upload(HttpServletRequest request,
                                            @RequestParam("file") MultipartFile file){
    try {
                if(file==null){
                    return D.error("请上传文件");
                }
               CsvImportRequest ir=new CsvImportRequest.Builder().setErrorFilter(filterError).setFile(file)
                        .setId("upload-1").build();
                //解析模板内容，对比模板内容是否和上传的一样
                CsvImportResponse response= csvContext.transfer(ir);
                return D.ok(response.getList());
            } catch (CsvImportException e) {
                return D.error(e.getMessage());
            } catch (Exception e) {
                return D.error(e.getMessage());
            }
     }

#### 导出 ####

@Autowize
    private CsvContext csvContext;
    public BaseDataAPI export(){
    
             、try {
                    fileName = new String(fileName.getBytes(), "ISO8859-1");
                } catch (UnsupportedEncodingException var3) {
                    var3.printStackTrace();
                }
                response.setContentType(MediaType.APPLICATION_OCTET_STREAM.toString());
                response.setHeader("Content-Disposition", "attachment;filename=" + fileName);
                response.addHeader("Pargam", "no-cache");
                response.addHeader("Cache-Control", "no-cache");
                FileCopyUtils.copy(csvContext.export(id,data), response.getOutputStream());
            } catch (Exception var4) {
                var4.printStackTrace();
            }
     }