POI 3.6 XSSF

[R Dom]

Can anyone tell me how can i read the xlsx workbook by using row by column method?

How can i find total number of columns and rows in the excel sheet using xssf.

[Ulf Dittmer]

Start here: http://poi.apache.org/spreadsheet/quick-guide.html#Iterator

[R Dom]

Thanks mate. I was looking for Java 1.5 for each loop to simplify the things.
But I think we still cant access a particular cell identified by its row number and column number?

[Ulf Dittmer]

Sure you can: Sheet.getRow(int).getCell(int)

[R Dom]

i want something like sheet.get(row number , column number) ... not cell number.
Also can we find out number of columns in excel sheet?

[Ulf Dittmer]

There's no such thing as a "cell number" - the parameter to getCell *is* the column number. I don't see a difference between chaining two method calls with one parameter each, and one method call with two parameters. If for some reason you want that you can always write your own convenience method.