• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Junilu Lacar
  • Jeanne Boyarsky
  • Bear Bibeault
Sheriffs:
  • Knute Snortum
  • Tim Cooke
  • Devaka Cooray
Saloon Keepers:
  • Ron McLeod
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Ganesh Patekar

SXSSF generated corrupted report in Z/OS on applying cell Style

 
Ranch Hand
Posts: 30
Spring Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.


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?
 
A sonic boom would certainly ruin a giant souffle. But this tiny ad would protect it:
Java file APIs (DOC, XLS, PDF, and many more)
https://products.aspose.com/total/java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!