[ https://issues.jboss.org/browse/TEIID-3219?page=com.atlassian.jira.plugin... ] Kylin Soong commented on TEIID-3219: ------------------------------------ I have done some investigation, [1] are the sample sheets I used for testing. The poi parse the excel sheet will trim all null rows both bottom and top, only keep non-null rows as sheet data, if .xlsx file contains any of the formatting for the blank cells, the poi reading is not treating it as null, like test.xlsx in [1]. I have tested both in windows with Excel 2007 and linux with OpenOffice, only if you scroll cell has style then it may cause empty iterations, like test.xlsx in [1], I have add style left-justified horizontal alignment, the poi reading isn't thinking it not null, all 20 rows be loaded, the cell with null value but have style as below: ~~~ <main:sheetData> <main:row r="1" spans="1:4"> <main:c r="A1" s="1"/> <main:c r="B1" s="1"/> <main:c r="C1" s="1"/> <main:c r="D1" s="1"/> </main:row> ~~~ If you scroll a fresh empty sheet, you can't see that behavior. [1] https://github.com/kylinsoong/data/tree/master/poi-examples-teiid/file -- This message was sent by Atlassian JIRA (v6.3.8#6338)