Re: POI not returning all rows

2016-08-17 Thread Andreas Reichel
Thank Microsoft for that, I claim to have had nothing to do with that. :) Cheers! On Wed, 2016-08-17 at 13:17 +0200, Gregor Kovač wrote: > Hi! > > > I know that rows are 0 based, but I didn't know that there can actually be > physically missing rows. Thanks for that. :) > > Best regards, > K

Re: POI not returning all rows

2016-08-17 Thread Gregor Kovač
Hi! I know that rows are 0 based, but I didn't know that there can actually be physically missing rows. Thanks for that. :) Best regards, Kovi 2016-08-17 13:13 GMT+02:00 Andreas Reichel : > Your program is correct! 19th row is in 20th line :) > Line 20 has no row. Sheet.getRow(19)==null! Ro

Re: POI not returning all rows

2016-08-17 Thread Andreas Reichel
Your program is correct! 19th row is in 20th line :) Line 20 has no row. Sheet.getRow(19)==null! Rows and Cell can be physically empty!         try {             File file = new File("/home/gregor/tmp/smyk/LIVE4/POI_TEST.xls");             fis = new FileInputStream(file);             Workbook work

Re: POI not returning all rows

2016-08-17 Thread Gregor Kovač
Hi! Can you please give me a corrected program that I sent in first e-mail? Best regards, Kovi 2016-08-17 12:47 GMT+02:00 Andreas Reichel : > Gregor, > > Rows and Cell are shown in Excel, even when not there (meaning > Row==Null or Cell==Null). > Your need to create a row first and the popu

Re: POI not returning all rows

2016-08-17 Thread Andreas Reichel
Gregor, Rows and Cell are shown in Excel, even when not there (meaning Row==Null or Cell==Null). Your need to create a row first and the populate it with cells. Best regards On Wed, 2016-08-17 at 12:40 +0200, Gregor Kovač wrote: > Hi! > > I have an Excel file for which POI does not return all ro