Hi Patrick. I never had such a problem although e.g. I've transformed already hundreds of big Excel files into files with newer macros etc.. I look how much cells there are within the row (using getLastCellNum() and adding 1 - although the function in fact already returns that nummer) and I check against this dimension for the actual row.
Then I fetch the cell with getCell(). The resulting cell may be null and then has to be ignored. If the index is exceeded I throw an exception. Regards, Karl-Heinz. -----Urspr�ngliche Nachricht----- Von: Patrick Lightbody [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 25. M�rz 2004 16:20 An: POI Users List Betreff: RE: HSSFRow.cellIterator order But traversing by column still gives you a column number that when passed to getCell(short) may result in an ArrayIndexOutOfBounds. Are you not experiencing this problem? > -----Original Message----- > From: Karl-Heinz Zengerle [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 25, 2004 6:40 AM > To: 'POI Users List' > Subject: AW: HSSFRow.cellIterator order > > Hi Patrick. > I think it's not useless. It's just not an optimum efficiency > (traversing via column numbers instead of the iterator and ignoring null > cells). It's not invented by POI. All what they do is based on Microsoft > behaviour. > Regards, Karl-Heinz. > > > -----Urspr�ngliche Nachricht----- > Von: Patrick Lightbody [mailto:[EMAIL PROTECTED] > Gesendet: Donnerstag, 25. M�rz 2004 15:26 > An: POI Users List > Betreff: RE: HSSFRow.cellIterator order > > That's a bummer -- seems to make POI almost completely useless for > simple scanning of rows. Are there _any_ workarounds short of catching > AIOOBE? Seems like a pretty nasty problem > > > -----Original Message----- > > From: Karl-Heinz Zengerle [mailto:[EMAIL PROTECTED] > > Sent: Thursday, March 25, 2004 6:07 AM > > To: 'POI Users List' > > Subject: AW: HSSFRow.cellIterator order > > > > Hi Patrick. > > You see exactly the similarity of the questions which I've also seen. > In > > that thread several reasons for that behaviour were mentioned. > > Regards, Karl-Heinz. > > > > -----Urspr�ngliche Nachricht----- > > Von: Patrick Lightbody [mailto:[EMAIL PROTECTED] > > Gesendet: Donnerstag, 25. M�rz 2004 15:03 > > An: POI Users List > > Betreff: RE: HSSFRow.cellIterator order > > > > Karl, > > Thanks for the heads up -- I hadn't been following the thread but I'll > > take a look. I'm guessing also related to this is the fact that even > > though the internal cells ArrayList is size 1, getLastCellNumber() > > returns something larger, which causes problems even if I access by > > column number. I end up having to catch AIOOBE :( > > > > Patrick > > > > > -----Original Message----- > > > From: Karl-Heinz Zengerle [mailto:[EMAIL PROTECTED] > > > Sent: Thursday, March 25, 2004 5:48 AM > > > To: 'POI Users List' > > > Subject: AW: HSSFRow.cellIterator order > > > > > > Hi Patrick. > > > I posted the topic "phantom cells ...?" recently. For me it looks > like > > > that the iterator traverses in the internal order. If you don't use > > the > > > iterator > > > But access the column by its number within the row you surely have > the > > > desired effect. > > > Look at the last mails belonging to the topic above. I think there > > > exactly your problem is also mentioned. > > > Regards, Karl-Heinz. > > > > > > -----Urspr�ngliche Nachricht----- > > > Von: Patrick Lightbody [mailto:[EMAIL PROTECTED] > > > Gesendet: Donnerstag, 25. M�rz 2004 14:36 > > > An: [EMAIL PROTECTED] > > > Betreff: HSSFRow.cellIterator order > > > > > > I seem to be getting the order of my cell iterator in something that > > is > > > different from the right-to-left order as defined in my spreadsheet. > > Why > > > is that? > > > > > > Patrick > > > > > > > > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
