3

Using Apache Poi I'm exporting my table to an excel sheet. I extended ExcelExport class, override the getCellStyle method and customized my cell styles.

Now what i want is when a user edits any cell in the excel document i want that cell to change its color, so anyone later reviewing the document can easily see what has been changed.

Is there way to achieve this?

Spring
  • 11,333
  • 29
  • 116
  • 185

1 Answers1

4

One solution could be to add conditional formatting to the cells use Apache POI's HSSFSheetConditionalFormatting.

For example, if the cell value written by your program is 5 then your conditional formatting could set the cell background to yellow if the value wasn't equal to 5

munyengm
  • 15,029
  • 4
  • 24
  • 34