Details
Description
The Excel Input step using the Apache POI Streaming engine will shift the data in a row over a column when it encounters a null, duplicating the null as well.
This only happens when cells have their format modified, such as a number category change, text alignment, font, etc.
Also, setting a cell back to it's default formatting either manually or by Clear -> Clear Formats does not correct this. You can only resolve it by selecting the entire sheet and then selecting Clear -> Clear Formats.