Set Background Color in Excel in C#, VB.NET

  • Demo
  • C# source
  • VB.Net source

The sample demonstrates how to set background color in Excel workbook via Spire.XLS.

using System.Drawing;

using Spire.Xls;

namespace BackgrandColor
{
    class Program
    {
        static void Main(string[] args)
        {
            Workbook workbook = new Workbook();
            workbook.LoadFromFile(@"..\..\..\..\Data\country.xls",ExcelVersion.Version97to2003);
            Worksheet worksheet = workbook.Worksheets[0];

            //set the backgroundcolor=LightBlue of Range["A2:E9"]
            worksheet.Range["A2:E9"].Style.Color = Color.LightBlue;

            //set the backgroundcolor=Silver of Range["A11:E18"]
            worksheet.Range["A11:E18"].Style.Color = Color.Silver;

            workbook.SaveToFile("sample.xls", ExcelVersion.Version97to2003);
            System.Diagnostics.Process.Start(workbook.FileName);
        }
    }
}

Imports System.Drawing

Imports Spire.Xls

Namespace BackgrandColor
	Class Program
		Private Shared Sub Main(args As String())
			Dim workbook As New Workbook()
			workbook.LoadFromFile("..\..\..\..\Data\country.xls", ExcelVersion.Version97to2003)
			Dim worksheet As Worksheet = workbook.Worksheets(0)

			'set the backgroundcolor=LightBlue of Range["A2:E9"]
			worksheet.Range("A2:E9").Style.Color = Color.LightBlue

			'set the backgroundcolor=Silver of Range["A11:E18"]
			worksheet.Range("A11:E18").Style.Color = Color.Silver

			workbook.SaveToFile("sample.xls", ExcelVersion.Version97to2003)
			System.Diagnostics.Process.Start(workbook.FileName)
		End Sub
	End Class
End Namespace