在查看很多有复杂的数据的表格时,为了能够快速地找到所需要的数据组时,往往需要对该数据组进行分类,一个简单快速的方法就是对数据组所在的单元格填充背景颜色,这样就使得我们在阅读文件时能够直观的看到数据分类,既美观又实用。那对于开发者而言,我这里提供一个简单快速的方法,即用C#给单元格设置背景颜色。下面是我的操作方法,供参考。我这里使用了一个叫Spire.XLS for . NET的免费版组件,该产品由E-iceblue公司发布,具体详情可上官网了解(https://www.e-iceblue.cn/Introduce/Spire-XLS-NET.html),不废话,下面我演示一下我的操作。

原文件如图:

步骤:

1、添加命名空间

UsingSpire.Xls;UsingSystem.Drawing;

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

Workbookworkbook=newWorkbook();workbook.LoadFromFile(@"C:\Users\Administrator\Desktop\test.xlsx",ExcelVersion.Version97to2003);Worksheetworksheet=workbook.Worksheets[0];Worksheetworksheet=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);

完成以上步骤后文档背景颜色添加成功,如下图所示:

完整代码:

C#

usingSystem.Drawing;usingSpire.Xls;namespacebackground_color{classProgram{staticvoidMain(string[]args){Workbookworkbook=newWorkbook();workbook.LoadFromFile(@"C:\Users\Administrator\Desktop\test.xlsx",ExcelVersion.Version97to2003);Worksheetworksheet=workbook.Worksheets[0];//setthebackgroundcolorofRange["A1:C2"]worksheet.Range["A1:C2"].Style.Color=Color.LightSeaGreen;//setthebackgroundcolorofRange["A3:C4"]worksheet.Range["A3:C4"].Style.Color=Color.LightYellow;//setthebackgroundcolorofRange["A5:C19"]worksheet.Range["A5:C19"].Style.Color=Color.SpringGreen;//setthebackgroundcolorofRange["A20:C21"]worksheet.Range["A20:C21"].Style.Color=Color.DeepSkyBlue;//setthebackgroundcolorofRange["A22:C23"]worksheet.Range["A22:C23"].Style.Color=Color.Yellow;//saveandlaunchtheprojectworkbook.SaveToFile("Sample.xls",ExcelVersion.Version97to2003);System.Diagnostics.Process.Start(workbook.FileName);}}}

VB.NET

ImportsSystem.DrawingImportsSpire.XlsNamespacebackground_colorClassProgramPrivateSharedSubMain(ByValargs()AsString)DimworkbookAsWorkbook=NewWorkbookworkbook.LoadFromFile("C:\Users\Administrator\Desktop\test.xlsx",ExcelVersion.Version97to2003)DimworksheetAsWorksheet=workbook.Worksheets(0)'setthebackgroundcolorofRange["A1:C2"]worksheet.Range("A1:C2").Style.Color=Color.LightSeaGreen'setthebackgroundcolorofRange["A3:C4"]worksheet.Range("A3:C4").Style.Color=Color.LightYellow'setthebackgroundcolorofRange["A5:C19"]worksheet.Range("A5:C19").Style.Color=Color.SpringGreen'setthebackgroundcolorofRange["A20:C21"]worksheet.Range("A20:C21").Style.Color=Color.DeepSkyBlue'setthebackgroundcolorofRange["A22:C23"]worksheet.Range("A22:C23").Style.Color=Color.Yellow'saveandlaunchtheprojectworkbook.SaveToFile("Sample.xls",ExcelVersion.Version97to2003)System.Diagnostics.Process.Start(workbook.FileName)EndSubEndClassEndNamespace