Re: Problem writing xls

[Alex Karshakevich]

The rowIterator iterates only over actual rows. If a row is empty it may 
not be represented in the excel file. The iterator skips these 
nonexistent rows, so you may not get the same count as the row count of 
the sheet.
To iterate over _all_rows, null or not, I use HSSFSheet.getRow() and 
deal with nulls myself.

Alex.
marc wrote:
Sorry the late reply.
This is the code from where it goes wrong:
I take a sheet and makes a iterator, to go over the rows. Moves the 
iterator's maker to position 4, because thats where me data starts. 
Then I check's if the cell in the current row is blank. If it is not. 
I go thow the rows making them into beans.
And at last I return the beans in a ArrayList.

But as I said in me first mail. First time I call it on a new sheet it 
counts 1 short. See the output in the bottom.

private Collection getAlias(HSSFSheet sheet) throws 
NoRowsExcistException {
        ConstansForAliasPOI constant = ConstansForAliasPOI.getInstance();
        ArrayList _alias = new ArrayList();
        int start = constant.getSTRATOFALIAS();
        Iterator rows = sheet.rowIterator();
        HSSFRow curretrow =(HSSFRow) rows.next();
        for(int n=0;n<start-1;n++)curretrow = (HSSFRow)rows.next();

        MailAliasDTO currentDTO;
        if(!(curretrow.getCell((short)0)==null)){
            while(rows.hasNext()){
                curretrow = (HSSFRow) rows.next();
                currentDTO = new MailAliasDTO();
currentDTO.setOwner(curretrow.getCell((short)0).getStringCellValue());
                currentDTO.setAlias(curretrow.getCell((short 
)1).getStringCellValue());

currentDTO.setReciver(curretrow.getCell((short)2).getStringCellValue());
                _alias.add(currentDTO);
                }
        }else{
            throw new NoRowsExcistException();
        }
        System.out.println("My alias list, from my xls, is this long: 
"+_alias.size()+" when I call getAlias()");
        return _alias;
    }

Output first run:
My alias list, from my xls, is this long: 3 when I call getAlias()
But there is 4 lines in me XLS.
If I then make a change in the XLS or add's one. Lets say I add one, 
so there is 5 lines in the XLS. And then runs the code, then I get:
My alias list, from my xls, is this long: 5 when I call getAlias()

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/