PM> Install-Package Spire.XLS

using Spire.Xls;
using Spire.Xls.Core;
using Spire.Xls.Core.Spreadsheet.Collections;
using System.Drawing;

namespace AlternateRowColors
{
    class Program
    {
        static void Main(string[] args)
        {
            //创建一个Workbook对象
            Workbook workbook = new Workbook();

            //加载 Excel 文件
            workbook.LoadFromFile("商品采买表.xlsx");

            //获取特定的工作表
            Worksheet sheet = workbook.Worksheets[0];

            //向工作表添加条件格式
            XlsConditionalFormats format = sheet.ConditionalFormats.Add();

            //设置应用条件格式的范围
            format.AddRange(sheet.Range[2, 1, sheet.LastRow, sheet.LastColumn]);

            //添加条件以根据公式更改单元格的格式
            IConditionalFormat condition1 = format.AddCondition();
            condition1.FirstFormula = "=MOD(ROW(),2)=0";
            condition1.FormatType = ConditionalFormatType.Formula;
            condition1.BackColor = Color.Yellow;

            //添加另一个条件以根据公式更改单元格的格式
            IConditionalFormat condition2 = format.AddCondition();
            condition2.FirstFormula = "=MOD(ROW(),2)=1";
            condition2.FormatType = ConditionalFormatType.Formula;
            condition2.BackColor = Color.LightGreen;

            //保存文件
            workbook.SaveToFile("交替行颜色.xlsx", ExcelVersion.Version2016);
        }
    }
}

Imports Spire.Xls
Imports Spire.Xls.Core
Imports Spire.Xls.Core.Spreadsheet.Collections
Imports System.Drawing

Namespace AlternateRowColors
    Friend Class Program
        Private Shared Sub Main(ByVal args As String())
            '创建一个Workbook对象
            Dim workbook As Workbook = New Workbook()

            '加载 Excel 文件
            workbook.LoadFromFile("商品采买表.xlsx")

            '获取特定的工作表
            Dim sheet As Worksheet = workbook.Worksheets(0)

            '向工作表添加条件格式
            Dim format As XlsConditionalFormats = sheet.ConditionalFormats.Add()

            '设置应用条件格式的范围
            format.AddRange(sheet.Range(2, 1, sheet.LastRow, sheet.LastColumn))

            '添加条件以根据公式更改单元格的格式
            Dim condition1 As IConditionalFormat = format.AddCondition()
            condition1.FirstFormula = "=MOD(ROW(),2)=0"
            condition1.FormatType = ConditionalFormatType.Formula
            condition1.BackColor = Color.Yellow

            '添加另一个条件以根据公式更改单元格的格式
            Dim condition2 As IConditionalFormat = format.AddCondition()
            condition2.FirstFormula = "=MOD(ROW(),2)=1"
            condition2.FormatType = ConditionalFormatType.Formula
            condition2.BackColor = Color.LightGreen

            '保存文件
            workbook.SaveToFile("交替行颜色.xlsx", ExcelVersion.Version2016)
        End Sub
    End Class
End Namespace