[ https://issues.jboss.org/browse/TEIID-3219?page=com.atlassian.jira.plugin... ] Kylin Soong edited comment on TEIID-3219 at 11/20/14 4:23 AM: -------------------------------------------------------------- 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. 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. Assuming a sheet have 10 rows, each row have multiple cells, but all cells in 5th row are null, in the condition, the current excel tranlator only retun the first 4 rows, start from 5th row be discarded, actually we expected result is all 10 rows be returned and all colmuns in row 5 are null, this is what we should resolve in this issue. [1] https://github.com/kylinsoong/data/tree/master/poi-examples-teiid/file was (Author: kylin): 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)