• Post Reply Bookmark Topic Watch Topic
  • New Topic

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

 
swathi ramesh
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is it possible to have mutiple font colors in a single cell in Excel using POI API.


Thanks in Advance.
 
Rob Spoor
Sheriff
Posts: 21135
87
Chrome Eclipse IDE Java Windows
  • Likes 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is that even possible in MS Excel?
 
swathi ramesh
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Sheriff
Posts: 21135
87
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Rancher
Posts: 1776
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Possibly the poster is asking for setting the text color?
 
swathi ramesh
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 326
Android Firefox Browser Mac OS X
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Sheriff
Posts: 21135
87
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I agree.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!