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
