CODEWITHSUNDEEP
javaapache-poi
Spring
Spring

Reputation: 11835

Apache POI excel cell style update

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?

Upvotes: 3

Views: 1890

Answers (1)

munyengm
munyengm

Reputation: 15479

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

Upvotes: 4

Related Questions