Bug 43005 - Problems in Large Sheet - Action Read
Summary: Problems in Large Sheet - Action Read
Status: CLOSED INVALID
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.0-FINAL
Hardware: PC Windows 2000
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-07-31 14:01 UTC by Raphael Milani
Modified: 2007-08-04 09:27 UTC (History)
1 user (show)


Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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.