com.e-iceblue
  http://repo.e-iceblue.cn/repository/maven-public/
 


 
  e-iceblue
  spire.xls.free
  3.9.1
 

import com.spire.xls.*;
import java.awt.*;

public class RenameSheetandSetTabColor {
 public static void main(String[] args) {
  //加载示例文档
  Workbook workbook = new Workbook();
  workbook.loadFromFile("test2.xlsx");

  //重命名第一个工作表并设置Tab颜色
  Worksheet worksheet = workbook.getWorksheets().get(0);
  worksheet.setName("成绩单");
  worksheet.setTabColor(Color.YELLOW);

  //重命名第二个工作表并设置Tab颜色
  worksheet = workbook.getWorksheets().get(1);
  worksheet.setName("考生信息");
  worksheet.setTabColor(Color.green);

  //重命名第三个工作表并设置Tab颜色
  worksheet = workbook.getWorksheets().get(2);
  worksheet.setName("年纪排名");
  worksheet.setTabColor(Color.RED);

  //保存文档
  workbook.saveToFile("output/Result.xlsx", ExcelVersion.Version2010);
 }
}