使用Spire.XLS,程序员可以非常方便地使用C#给Excel工作表设置背景颜色和添加背景图片。以下示例将详细讲述如何使用Spire.XLS给一个现有Excel工作表设置背景颜色,添加背景图片。
设置背景颜色
C#
//加载Excel文档并获取第一个工作表
Workbook workbook = new Workbook();
workbook.LoadFromFile("Sample.xlsx");
Worksheet sheet = workbook.Worksheets[0];
//为Excel Range 分别设置背景色
sheet.Range["A1:E1"].Style.Color = Color.LightSeaGreen;
sheet.Range["A2:E19"].Style.Color = Color.Green;
sheet.Range["A20:E38"].Style.Color = Color.DeepSkyBlue;
//保存文档
workbook.SaveToFile("SetBackgroundColor.xlsx", ExcelVersion.Version2010);
VB.NET
'加载Excel文档并获取第一个工作表
Dim workbook As New Workbook()
workbook.LoadFromFile("Sample.xlsx")
Dim sheet As Worksheet = workbook.Worksheets(0)
'为Excel Range 分别设置背景色
sheet.Range("A1:E1").Style.Color = Color.LightSeaGreen
sheet.Range("A2:E19").Style.Color = Color.Green
sheet.Range("A20:E38").Style.Color = Color.DeepSkyBlue
'保存文档
workbook.SaveToFile("SetBackgroundColor.xlsx", ExcelVersion.Version2010)
设置背景图片
C#
//加载Excel文档并获取第一个工作表
Workbook workbook = new Workbook();
workbook.LoadFromFile("Sample.xlsx");
Worksheet sheet = workbook.Worksheets[0];
//加载一张图片并设置为背景图片
Bitmap bm = new Bitmap(Image.FromFile("logo.png"));
sheet.PageSetup.BackgoundImage = bm;
//保存文档
workbook.SaveToFile("SetBackgroundimage.xlsx", ExcelVersion.Version2010);
VB.NET
'加载Excel文档并获取第一个工作表
Dim workbook As New Workbook()
workbook.LoadFromFile("Sample.xlsx")
Dim sheet As Worksheet = workbook.Worksheets(0)
'加载一张图片并设置为背景图片
Dim bm As New Bitmap(Image.FromFile("logo.png"))
sheet.PageSetup.BackgoundImage = bm
'保存文档
workbook.SaveToFile("SetBackgroundimage.xlsx", ExcelVersion.Version2010)