It would be fantastic if I could set a column to be calculated as a formula inside Excel. At present, we would have to manually perform this calculation in a non-persistent entity which is cumbersome. This article says it would be easy:
https://www.baeldung.com/java-apache-poi-set-formulas
I would imagine something along the lines of Retrieve Type: Formula and then a text box would appear where you input a string for the desired formula. (i.e. set column I to = (D x H x G)/100)