Java笔记总结（四十六）---循环遍历所有sheet标签，如果符合颜色就输出sheet名

package ArrayTest;

import com.spire.xls.*;

import java.awt.*;

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

    private static void test2() {
        Color targetColor = new Color(255,0,0);
        //获取文件地址
        Workbook workbook = new Workbook();
        workbook.loadFromFile("b.xls");
        for (int i = 0; i < workbook.getWorksheets().getCount(); i++) {
            String sheetname = workbook.getWorksheets().get(i).getName();
            Worksheet worksheet = workbook.getWorksheets().get(i);
//            System.out.println(worksheet.getTabColor());
            if (worksheet.getTabColor().equals(targetColor)){
                System.out.println(sheetname);
            }
        }
    }
}

输出结果：
Sheet2
Sheet1