Excel支持sort导出排序

RuoYi

2020-07-10 c404c280f726af9518afe1dcd8ab61d5fc3c1a4f

Excel支持sort导出排序

 ruoyi-common/ruoyi-common-core/src/main/java/com/ruoyi/common/core/annotation/Excel.java

@@ -15,6 +15,11 @@
public @interface Excel

{

    /**

     * 导出时在excel中排序

     */

    public int sort() default Integer.MAX_VALUE;



    /**

     * 导出到Excel中的名字.

     */

    public String name() default "";


 ruoyi-common/ruoyi-common-core/src/main/java/com/ruoyi/common/core/utils/poi/ExcelUtil.java

@@ -9,10 +9,12 @@
import java.text.DecimalFormat;

import java.util.ArrayList;

import java.util.Arrays;

import java.util.Comparator;

import java.util.Date;

import java.util.HashMap;

import java.util.List;

import java.util.Map;

import java.util.stream.Collectors;

import javax.servlet.http.HttpServletResponse;

import org.apache.poi.hssf.usermodel.HSSFDateUtil;

import org.apache.poi.ss.usermodel.BorderStyle;

@@ -739,6 +741,7 @@
                }

            }

        }

        this.fields = this.fields.stream().sorted(Comparator.comparing(objects -> ((Excel) objects[1]).sort())).collect(Collectors.toList());

    }



    /**