spring-projects/spring-batch-extensions

Support customization of FormulaEvaluator in PoiSheet

sravaniv-3cortex opened this issue · 1 comments

Our use case of reading Excel files requires that errors in resolving the external sheet references in formula evaluations be ignored. This requires calling the org.apache.poi.ss.usermodel.FormulaEvaluator.setIgnoreMissingWorkbooks(boolean). This isn't currently possible with the current PoiSheet implementation - PoiSheet is package-private so it can't be extended to override the getRow method, which allows us to customize the FormulaEvalutor instance used.

What is the feasibility of doing one of these things?

  • Opening up PoiSheet for extension
  • Have a settings class which can be passed by the user and later applied by the PoiSheet to the FormulaEvaluator. This might result in future asks for setting classes for other things.

If nothing above works, the other option is to duplicate PoiSheet with necessary changes and then override PoiItemReader.