- Demo
- C# source
- VB.Net source
The sample demonstrates how to design text color in excel spreadsheet.
using System.Drawing; using Spire.Xls; namespace TextColor { class Program { static void Main(string[] args) { Workbook workbook = new Workbook(); workbook.LoadFromFile(@"..\..\..\..\Data\parts.xls",ExcelVersion.Version97to2003); Worksheet worksheet = workbook.Worksheets[0]; //set the text color of Range["A1"] worksheet.Range["A2:G3"].Style.Font.Color = Color.Red; //set the text color of Range["A2"] worksheet.Range["A4:G4"].Style.Font.Color = Color.Violet; //set the text color of Range["A3"] worksheet.Range["A6:D8"].Style.Font.Color = Color.Blue; //set the text color of Range["A4"] worksheet.Range["F9:G12"].Style.Font.Color = Color.Black; //set the text color of Range["B1"] worksheet.Range["A13:C16"].Style.Font.Color = Color.Green; //set the text color of Range["B2"] worksheet.Range["E13:G13"].Style.Font.Color = Color.Purple; //set the text color of Range["B3"] worksheet.Range["E14:G14"].Style.Font.Color = Color.Plum; //set the text color of Range["B4"] worksheet.Range["A15:G18"].Style.Font.Color = Color.Peru; workbook.SaveToFile("sample.xls", ExcelVersion.Version97to2003); System.Diagnostics.Process.Start(workbook.FileName); } } }
Imports System.Drawing Imports Spire.Xls Namespace TextColor Friend Class Program Shared Sub Main(ByVal args() As String) Dim workbook As New Workbook() workbook.LoadFromFile("..\..\..\..\Data\parts.xls",ExcelVersion.Version97to2003) Dim worksheet As Worksheet = workbook.Worksheets(0) 'set the text color of Range["A1"] worksheet.Range("A2:G3").Style.Font.Color = Color.Red 'set the text color of Range["A2"] worksheet.Range("A4:G4").Style.Font.Color = Color.Violet 'set the text color of Range["A3"] worksheet.Range("A6:D8").Style.Font.Color = Color.Blue 'set the text color of Range["A4"] worksheet.Range("F9:G12").Style.Font.Color = Color.Black 'set the text color of Range["B1"] worksheet.Range("A13:C16").Style.Font.Color = Color.Green 'set the text color of Range["B2"] worksheet.Range("E13:G13").Style.Font.Color = Color.Purple 'set the text color of Range["B3"] worksheet.Range("E14:G14").Style.Font.Color = Color.Plum 'set the text color of Range["B4"] worksheet.Range("A15:G18").Style.Font.Color = Color.Peru workbook.SaveToFile("sample.xls", ExcelVersion.Version97to2003) System.Diagnostics.Process.Start(workbook.FileName) End Sub End Class End Namespace