c#/vb.net 为 excel 单元格设置背景颜色和图案-凯发线上登陆下载网址

pm> install-package spire.xls

using system.drawing;
using spire.xls;
namespace cellbackground
{
    class program
    {
        static void main(string[] args)
        {
            //实例化工作簿对象
            workbook workbook = new workbook();
            //加载示例 excel 文件
            workbook.loadfromfile(@"c:\users\administrator\desktop\data.xlsx");
            //获取第一个工作表
            worksheet worksheet = workbook.worksheets[0];
            //为范围 ["a1:e1"] 和 ["a2:a10"] 设置背景颜色
            worksheet.range["a1:e1"].style.color = color.mediumseagreen;
            worksheet.range["a2:a10"].style.color = color.lightyellow;
            //为单元格 e6 设置背景颜色
            worksheet.range["e6"].style.color = color.red;
            //设置范围 ["b4:d5"] 的模式样式
            worksheet.range["b4:d5"].style.fillpattern = excelpatterntype.percent125gray;
            //保存结果文档
            workbook.savetofile("cellbackground.xlsx", excelversion.version2013);
        }
    }
}

imports system.drawing
imports spire.xls
 
namespace cellbackground
    class program
        shared  sub main(byval args() as string)
            '实例化工作簿对象
            dim workbook as workbook =  new workbook() 
 
            '加载示例 excel 文件
            workbook.loadfromfile("c:\users\administrator\desktop\data.xlsx")
 
            '获取第一个工作表
            dim worksheet as worksheet =  workbook.worksheets(0) 
 
            '为范围 ["a1:e1"] 和 ["a2:a10"] 设置背景颜色
            worksheet.range("a1:e1").style.color = color.mediumseagreen
            worksheet.range("a2:a10").style.color = color.lightyellow
 
            '为单元格 e6 设置背景颜色
            worksheet.range("e6").style.color = color.red
 
            '设置范围 ["b4:d5"] 的模式样式
            worksheet.range("b4:d5").style.fillpattern = excelpatterntype.percent125gray
 
            '保存结果文档
            workbook.savetofile("cellbackground.xlsx", excelversion.version2013)
        end sub
 
    end class
end namespace