Hi POI:
I want to get the FillForeGround color index and FillBackGround color index
of the Cell. But its returning 64 for background and Zero for foreground
index(In case of XLSX type). In case of XLS foreground color index is
retrieving correctly.
here is the small code:
///////////////////////////////////////////////////////////////////////////////////////////////
Iterator cells = row.cellIterator();
while (cells.hasNext()) {
Cell cell = (Cell) cells.next();
CellStyle cStyle = cell.getCellStyle();
System.out.println("Color
getFillBackgroundColor:"+cStyle.getFillBackgroundColor());//64
System.out.println("Color
getFillForegroundColor:"+cStyle.getFillForegroundColor());//0 in xlsx
///////////////////////////////////////////////////////////////////////////////////////////////////////////
Please tell me that what should i do to get the fillBackgroundcolor and
fillforeground color correctly?
Share some code snippet as well.
Thanks in Advance.
Vajahat Ali
--
View this message in context:
http://old.nabble.com/Get-Cell-FillForeground-and-FillBackground-Color-tp28667968p28667968.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
