Question

c#如何设置Excel工作表标签颜色

Answer 1

下载引用免费的Spire.Xls.dll

使用代码：

using Spire.Xls;
using System.Drawing;

namespace SetTabColor
{
    class Program
    {
        static void Main(string[] args)
        {
            //加载excel文件
            Workbook wb = new Workbook();
            wb.LoadFromFile(@"C:\Users\Administrator\Desktop\sample.xlsx");

            //设置工作表标签颜色
            wb.Worksheets[0].TabColor = Color.Red;
            wb.Worksheets[1].TabColor = Color.Green;
            wb.Worksheets[2].TabColor = Color.Blue;

            //保存文档
            wb.SaveToFile("output.xlsx",FileFormat.Version2013);
        }
    }
}

Answer 2

在标签上鼠标右键，就能更改