Bug 43005

Summary: Problems in Large Sheet - Action Read
Product: POI Reporter: Raphael Milani <ramilani>
Component: HSSFAssignee: POI Developers List <dev>
Status: CLOSED INVALID    
Severity: normal CC: ramilani
Priority: P2    
Version: 3.0-FINAL   
Target Milestone: ---   
Hardware: PC   
OS: Windows 2000   

Description Raphael Milani 2007-07-31 14:01:04 UTC
I´m try reading a simple Sheet in Excel 2003, for specify sheet it contains 683
rows I passed problems 
I´m using object HSSFSheet for Read but not it reaches the last row which is 683
 the read stop in row 628 

somebody help me?
Comment 1 Andy Oliver 2007-07-31 14:14:24 UTC
Inappropriate place to ask a question.  You found your way here...now find the
mail list as well.
Comment 2 Raphael Milani 2007-08-01 05:46:58 UTC
(In reply to comment #1)
> Inappropriate place to ask a question.  You found your way here...now find the
> mail list as well.

Yes I know this inappropriate place to ask question , I´m sorry  but I searched
many sites and not found solution for my Problem

My Sheet has this	
structure:

XXXXX YYYY	1200401		10	11	12	13	14
A	55	104		 1      76      27       0       0
B							
C							
D							
E							
F							
G							
H							
I							
J							
------------------------- row blank
This structure repeat many times in sheet 
but when call  HSSFSheet.getPhysicalNumberOfRows() not it reaches the last row 




Comment 3 Bina Prieto 2007-08-03 08:09:38 UTC
(In reply to comment #2)
/**
  * Returns the number of phsyically defined rows (NOT the number of rows in 
the sheet)
*/
public int getPhysicalNumberOfRows()

Try to use HSSFSheet.getLastRowNum() to solve your problem because
getPhysicalNumberOfRows() has another nature as you can see - this method don't 
considered empty rows.



> (In reply to comment #1)
> > Inappropriate place to ask a question.  You found your way here...now find 
the
> > mail list as well.
> 
> Yes I know this inappropriate place to ask question , I´m sorry  but I 
searched
> many sites and not found solution for my Problem
> 
> My Sheet has this	
> structure:
> 
> XXXXX YYYY	1200401		10	11	12	13	14
> A	55	104		 1      76      27       0       0
> B							
> C							
> D							
> E							
> F							
> G							
> H							
> I							
> J							
> ------------------------- row blank
> This structure repeat many times in sheet 
> but when call  HSSFSheet.getPhysicalNumberOfRows() not it reaches the last 
row 
> 
> 
> 
> 
> 

Comment 4 Raphael Milani 2007-08-04 09:27:09 UTC
(In reply to comment #3)
> (In reply to comment #2)
> /**
>   * Returns the number of phsyically defined rows (NOT the number of rows in 
> the sheet)
> */
> public int getPhysicalNumberOfRows()
> 
> Try to use HSSFSheet.getLastRowNum() to solve your problem because
> getPhysicalNumberOfRows() has another nature as you can see - this method don't 
> considered empty rows.

Hello Bina thanks for you help but I fixed my problem before , reading all
javadoc I discovered this method getLastRowNum().
First moment I thought was bug but did not.