I am trying to execute a program in Z-OS machine, to write an excel report.
Due to size of the Report, we are using SXSSFWorkbook to write the report.
One of the cell in the report is grey in color. So i have to apply Color to
that cell.
Used the following code to set the color.
XSSFCellStyle cellStyle = (XSSFCellStyle) wb.createCellStyle();
XSSFColor myColor = new XSSFColor(DatatypeConverter
.parseHexBinary("FFBFBFBF")); //also tried the java.awt.Color
cellStyle.setFillForegroundColor(myColor);
cell.setCellStyle(cellStyle);
But for the report generated, this cell is dark incolor.
Out of curiocity, i checked the Styles.xml inside the excel document.
Folowing is what i found.
<fill><patternFill patternType="solid"><fgColor rgb="ããâãâãâã
"/></patternFill></fill>
I tried to generate the same report in Windows machine, it gave me correct
result.
<fill><patternFill patternType="solid"><fgColor rgb="FFBFBFBF
"/></patternFill>
Can any one help me to resolve this issue?
--
*RENJITH R*
9446011990
