Java笔记总结（四十三）---java设置并获取sheet标签的颜色

POI无法实现这个功能，需要另外一个jar包叫Spire.XLS for Java
下载地址：Spire.XLS for Java
我已经下载好的jar包：百度网盘下载地址 提取码: 27by

package ArrayTest;

import com.spire.xls.*;

import java.awt.*;

public class Test {
    public static void main(String[] args) {
        test2();
    }

    private static void test2() {
        //获取文件地址
        String filepath = "D:\\b.xls";
        Workbook workbook = new Workbook();
        workbook.loadFromFile("b.xls");
        Worksheet worksheet = workbook.getWorksheets().get(0);
//        worksheet.setName("成绩单");
        worksheet.setTabColor(Color.GREEN);
        Worksheet worksheet1 = workbook.getWorksheets().get(1);
        worksheet1.setTabColor(Color.RED);
        workbook.saveToFile("output/Result.xlsx", ExcelVersion.Version2010);//设置为绿色并输出

        //获取颜色
        System.out.println(worksheet.getTabColor());
    }
}

输出结果：
java.awt.Color[r=0,g=255,b=0]//后面括号里的代表颜色