- Demo
- C# source
- VB.Net source
The sample demonstrates how to set cell fill in Excel workbook via Spire.XLS.
using Spire.Xls; using System.Drawing; namespace CellFill { class Program { static void Main(string[] args) { //create a workbook Workbook workbook = new Workbook(); Worksheet sheet = workbook.Worksheets[0]; //set the color of Range["C3"] sheet.Range["B3:B4"].Style.Color = Color.Yellow; sheet.Range["B3:B4"].Style.FillPattern = ExcelPatternType.Angle; //set the fillpattern of Range["D4"] sheet.Range["C6:C7"].Style.Color = Color.GreenYellow; sheet.Range["C6:C7"].Style.FillPattern = ExcelPatternType.ThickDiagonalCrosshatch; //set the fillpattern of Range["E5"] sheet.Range["D9:D10"].Style.Color = Color.BlueViolet; sheet.Range["D9:D10"].Style.FillPattern = ExcelPatternType.Vertical; //set the fillpattern of Range["A1:C2"] sheet.Range["E12:F15"].Style.Color = Color.LightSkyBlue; sheet.Range["E12:F15"].Style.FillPattern = ExcelPatternType.ForwardDiagonal; //set the fillpattern of Range["G9:H9"] sheet.Range["G17:I21"].Style.Color = Color.Bisque; sheet.Range["G17:I21"].Style.FillPattern = ExcelPatternType.Percent25Gray; //save the workbook workbook.SaveToFile("sample.xls", ExcelVersion.Version97to2003); System.Diagnostics.Process.Start(workbook.FileName); } } }
Imports Spire.Xls Imports System.Drawing Namespace CellFill Friend Class Program Shared Sub Main(ByVal args() As String) 'create a workbook Dim workbook As New Workbook() Dim sheet As Worksheet = workbook.Worksheets(0) 'set the color of Range["C3"] sheet.Range("B3:B4").Style.Color = Color.Yellow sheet.Range("B3:B4").Style.FillPattern = ExcelPatternType.Angle 'set the fillpattern of Range["D4"] sheet.Range("C6:C7").Style.Color = Color.GreenYellow sheet.Range("C6:C7").Style.FillPattern = ExcelPatternType.ThickDiagonalCrosshatch 'set the fillpattern of Range["E5"] sheet.Range("D9:D10").Style.Color = Color.BlueViolet sheet.Range("D9:D10").Style.FillPattern = ExcelPatternType.Vertical 'set the fillpattern of Range["A1:C2"] sheet.Range("E12:F15").Style.Color = Color.LightSkyBlue sheet.Range("E12:F15").Style.FillPattern = ExcelPatternType.ForwardDiagonal 'set the fillpattern of Range["G9:H9"] sheet.Range("G17:I21").Style.Color = Color.Bisque sheet.Range("G17:I21").Style.FillPattern = ExcelPatternType.Percent25Gray 'save the workbook workbook.SaveToFile("sample.xls", ExcelVersion.Version97to2003) System.Diagnostics.Process.Start(workbook.FileName) End Sub End Class End Namespace