c#/vb.net 在 excel 中使用条件格式设置交替行颜色-凯发线上登陆下载网址

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