Android使用EasyExcel操作Excel

1.添加依赖

// Excel
implementation 'org.apache.poi:poi:3.17'
implementation 'org.apache.poi:poi-ooxml:3.17'
implementation 'org.apache.xmlbeans:xmlbeans:3.1.0'
implementation 'stax:stax:1.2.0'
implementation 'com.alibaba:easyexcel:2.2.10'

2.实现一个简单的java.awt.Color类

package java.awt;

public class Color {
    public static final Color white;
    public static final Color WHITE;
    public static final Color lightGray;
    public static final Color LIGHT_GRAY;
    public static final Color gray;
    public static final Color GRAY;
    public static final Color darkGray;
    public static final Color DARK_GRAY;
    public static final Color black;
    public static final Color BLACK;
    public static final Color red;
    public static final Color RED;
    public static final Color pink;
    public static final Color PINK;
    public static final Color orange;
    public static final Color ORANGE;
    public static final Color yellow;
    public static final Color YELLOW;
    public static final Color green;
    public static final Color GREEN;
    public static final Color magenta;
    public static final Color MAGENTA;
    public static final Color cyan;
    public static final Color CYAN;
    public static final Color blue;
    public static final Color BLUE;
    int value;

    public Color(int red, int green, int blue) {
        this(red, green, blue, 255);
    }

    public Color(int red, int green, int blue, int alpha) {
        this.value = (alpha & 255) << 24 | (red & 255) << 16 | (green & 255) << 8 | (blue & 255);
    }

    public Color(int rgb) {
        this.value = -16777216 | rgb;
    }

    public int getRed() {
        return this.getRGB() >> 16 & 255;
    }

    public int getGreen() {
        return this.getRGB() >> 8 & 255;
    }

    public int getBlue() {
        return this.getRGB() & 255;
    }

    public int getAlpha() {
        return this.getRGB() >> 24 & 255;
    }

    public int getRGB() {
        return this.value;
    }

    static {
        white = new Color(255, 255, 255);
        WHITE = white;
        lightGray = new Color(192, 192, 192);
        LIGHT_GRAY = lightGray;
        gray = new Color(128, 128, 128);
        GRAY = gray;
        darkGray = new Color(64, 64, 64);
        DARK_GRAY = darkGray;
        black = new Color(0, 0, 0);
        BLACK = black;
        red = new Color(255, 0, 0);
        RED = red;
        pink = new Color(255, 175, 175);
        PINK = pink;
        orange = new Color(255, 200, 0);
        ORANGE = orange;
        yellow = new Color(255, 255, 0);
        YELLOW = yellow;
        green = new Color(0, 255, 0);
        GREEN = green;
        magenta = new Color(255, 0, 255);
        MAGENTA = magenta;
        cyan = new Color(0, 255, 255);
        CYAN = cyan;
        blue = new Color(0, 0, 255);
        BLUE = blue;
    }
}

3.使用Map和List<Map>填充普通数据和列表数据

---

参考链接：

EasyExcel