C#/VB.NET设置Excel表格背景色

1、添加命名空间

Using Spire.Xls;

Using System.Drawing;

2、 初始化工作簿并加载文档

Workbook workbook = new Workbook();

 workbook.LoadFromFile(@"C:\Users\Administrator\Desktop\test.xlsx", ExcelVersion.Version97to2003);

 Worksheet worksheet = workbook.Worksheets[0];Worksheet worksheet = workbook.Worksheets[0];

3、设置单元格背景颜色

worksheet.Range["A1:C2"].Style.Color = Color.LightSeaGreen;

worksheet.Range["A3:C4"].Style.Color = Color.LightYellow;

worksheet.Range["A5:C19"].Style.Color = Color.SpringGreen;

worksheet.Range["A20:C21"].Style.Color = Color.DeepSkyBlue;

worksheet.Range["A22:C23"].Style.Color = Color.Yellow;

4、保存并预览文件

workbook.SaveToFile("GradesRank.xls",ExcelVersion.Version97to2003;

System.Diagnostics.Process.Start(workbook.FileName);

1、【C#】

using System.Drawing;

using Spire.Xls; 

namespace background_color

{    

class Program

{        

static void Main(string[] args)        

{            

//实例化Workbook类，加载测试文档

Workbook workbook = new Workbook();            

workbook.LoadFromFile(@"C:\Users\Administrator\Desktop\test.xlsx", ExcelVersion.Version97to2003);        

//获取第一个工作表    

Worksheet worksheet = workbook.Worksheets[0];            

//给指定单元格设置颜色填充效果           

worksheet.Range["A1:C2"].Style.Color = Color.LightSeaGreen;                    worksheet.Range["A3:C4"].Style.Color = Color.LightYellow;             

worksheet.Range["A5:C19"].Style.Color = Color.SpringGreen;            

worksheet.Range["A20:C21"].Style.Color = Color.DeepSkyBlue;             

worksheet.Range["A22:C23"].Style.Color = Color.Yellow;             

//保存并打开文档           

workbook.SaveToFile("Sample.xls", ExcelVersion.Version97to2003);            

System.Diagnostics.Process.Start(workbook.FileName);        

}    

}

}

2、【VB.NET】

Imports System.Drawing Imports Spire.Xls Namespace background_color          Class Program                  Private Shared Sub Main(ByVal args() As String)             Dim workbook As Workbook = New Workbook             workbook.LoadFromFile("C:\Users\Administrator\Desktop\test.xlsx", ExcelVersion.Version97to2003)             Dim worksheet As Worksheet = workbook.Worksheets(0)             'set the backgroundcolor of Range["A1:C2"]             worksheet.Range("A1:C2").Style.Color = Color.LightSeaGreen             'set the backgroundcolor of Range["A3:C4"]             worksheet.Range("A3:C4").Style.Color = Color.LightYellow             'set the backgroundcolor of Range["A5:C19"]             worksheet.Range("A5:C19").Style.Color = Color.SpringGreen             'set the backgroundcolor of Range["A20:C21"]             worksheet.Range("A20:C21").Style.Color = Color.DeepSkyBlue             'set the backgroundcolor of Range["A22:C23"]             worksheet.Range("A22:C23").Style.Color = Color.Yellow             'save and launch the project             workbook.SaveToFile("Sample.xls", ExcelVersion.Version97to2003)             System.Diagnostics.Process.Start(workbook.FileName)         End Sub     End Class End Namespace