POI Transformer

PoiTransformer is an implementation of Transformer interface based Apache POI.

It is a built-in Excel transformer from jxls-poi module.

It supports both POI-HSSF and POI-XSSF/SXSSF workbooks and has multiple constructors allowing to create a streaming or non-streaming transformer instance from POI workbook or from the template input stream.

Additionally it allows to ignore the source cells row height and/or column width during the cells transformation. It is achieved with setIgnoreRowProps(boolean) and setIgnoreColumnProps(boolean) methods.

transformer.setExceptionHandler(new PoiExceptionThrower());
// also turn on strict non-silent mode
transformer.getTransformationConfig().setExpressionEvaluator(new JexlExpressionEvaluator(false, true));