Is it possible to have mutiple font colors in a single cell in Excel using POI API.

[swathi ramesh]

Is it possible to have mutiple font colors in a single cell in Excel using POI API.


Thanks in Advance.

[Rob Spoor]

Is that even possible in MS Excel?

[swathi ramesh]

Rob Spoor wrote:Is that even possible in MS Excel?

I mean, if "Customer Name: XYZ" as value in a cell, where "Customer Name" in Black font color and "XYZ" in Blue.

[Rob Spoor]

I understand what you want, but I'm not sure that the entire Excel format supports that. I've never seen any option in MS Excel that allows me to change the font of only parts of cells, only for entire cell contents.

[John Jai]

Possibly the poster is asking for setting the text color?

[swathi ramesh]

Rob Spoor wrote:I understand what you want, but I'm not sure that the entire Excel format supports that. I've never seen any option in MS Excel that allows me to change the font of only parts of cells, only for entire cell contents.

Suggest me, if any other option, to fullfill my requirment.

[Ove Lindström]

swathi ramesh wrote:

Rob Spoor wrote:I understand what you want, but I'm not sure that the entire Excel format supports that. I've never seen any option in MS Excel that allows me to change the font of only parts of cells, only for entire cell contents.

Suggest me, if any other option, to fullfill my requirment.

One cell for label, one for data.

[Rob Spoor]

I agree.