How to use different colors of texts in same Excel cell using ClosedXML?

Question

How to use different colors of texts in the same Excel cell using ClosedXML?

worksheet.Cell(1,1).Value.Character[StartIndex, NoOfChar].Font.Color....??

ClosedXML doesn't have something like above, please help me to use two different font colors in the same cell.

Thanks but I tried the same,this will apply the color to whole cell text.I need portion of the text to be colored.@Innat3 — WSk, Sep 21 '16 at 12:29

Raidri · Accepted Answer · 2018-10-26T23:35:35.657

14

Use RichText to style different parts of the cell, for example:

worksheet.Cell(1,1).RichText.Substring(StartIndex, NoOfChar).SetFontColor(XLColor.Red);

See the documentation for more details.

edited Oct 26 '18 at 23:35

answered Sep 21 '16 at 13:02

Raidri

2

*worksheet.Cell(1,1).RichText.Substring(StartIndex, NoOfChar).SetFontColor(XLColor.Red); – Innat3 Sep 21 '16 at 13:08
@Raidri, you seem to know the library well. We could use your help in developing it further. http://github.com/Closedxml/Closedxml – Francois Botha Sep 22 '16 at 05:03
strangely, i get this error. Is RichText deprecated in ClosedXML? CS1061: "XLCell" does not contain a definition for 'RichText' and no accessible extension method 'Rich Text accepting a first argument of type 'IXLCell' could be found (are you missing a using directive or an assembly reference?) – user3267567 Aug 03 '23 at 05:57

1 Answers1