how to get only non-blank cells in excel by java Excel api

[indu yeturu]

Hi,

am trying to get total no.of rows from excel sheet with this code.

 int numOfRows = s.getRows();
		   	 	    int numOfColumns = s.getColumns();          


for(int x=21;x<numOfRows;x++)
	   	 	    {
	   	 	    	for(int y=0;y<numOfColumns-1;y++)
	   	 	    	{
	   	 	    	       if(sheet.getCell(y,x).getContents()!=null)
                                          {
	   	 	    		   
                                                     //code to get ...
	   	 	    			   	 	    	
	   	 	                        }
	   	 	    		
	   	 	    } 
    

[indu yeturu]

sorry,, please have a look on this ,,,ignore the previous one...

 
                                int numOfRows = sheet.getRows();
		   	 	              int numOfColumns = sheet.getColumns();
                                     int rows_containData=0;
                          // //here in my Excel sheet data starts from 22 nd row

                    for(int x=21;x<numOfRows;x++)
	   	 	       {
	   	 	    	for(int y=0;y<numOfColumns-1;y++)
	   	 	    	{
	   	 	    	    if(sheet.getCell(y,x).getContents()!=null)
                                   {
	   	 	    		   //code to no.of actual rows which contain data....
                                             rows_containData++;

	   	 	    		    }
	   	 	    			   	 	    	
	   	 	    	}
	   	 	    		
	   	 	    } 

   

but am getting the "rows_containData " as some thing wrong say 100.. Not getting exactly the number of rows which are having data..
Please, please , tell me how to get that ???


thaks
indu

[Rob Spoor]

You're not counting rows, you're counting cells. You need to stop the inner loop once you've found a non-null cell. Adding "break;" just below the increment of rows_containData should do the trick.

[indu yeturu]

thank you, but it displays the total no.of rows in the excel sheet(say 329, including blank rows)

my code is -->>>

   for(int x=0;x<numOfRows;x++)  
		   	                    {  
		   	                      for(int y=0;y<numOfColumns-1;y++)  
		   	                      {  
		   	                        if(s.getCell(y,x).getContents()!=null)  
		   	                               {  
		   	                        	        rows_containData++;         
		   	                        	        break;
		  		   	                           }  
		   	                                                               
		   	                       }  
		   	   	               }      

[Rob Spoor]

Then apparently blank rows don't cause the cell's getContents() method to return null. You could check against being empty as well:

String contents = s.getCell(y, x).getContents();
if (contents != null && contents.length() > 0)
{
    rows_containData++;
    break;
}