To be able to perform some record analysis I have to extract values inside a column of the Stand out sheet. I've been while using Apache POI package to see from Stand out files, and delay pills work fine when one should iterate over rows. However could not find anything about getting posts neither within the API (link text) nor through google searching.

As I have to get max and min values of various posts and generate random amounts with such values, so without obtaining individual posts, the only real other choice is to iterate over rows and posts to find the values and compare 1 by 1, which does not seem everything time-efficient.

Any ideas regarding how to tackle this issue?


Stand out files are row based instead of column based, so the only method to get all of the values inside a column is to check out each row consequently. There is no faster method of getting in the posts, because cells inside a column aren't saved together.

Your code most likely really wants to be something similar to:

List<Double> values = new ArrayList<Double>();
for(Row r : sheet) {
   Cell c = r.getCell(columnNumber);
   if(c != null) {
      if(c.getCellType() == Cell.CELL_TYPE_NUMERIC) {
      } else if(c.getCellType() == Cell.CELL_TYPE_FORMULA && c.getCachedFormulaResultType() == Cell.CELL_TYPE_NUMERIC) {

That'll then provide you with all of the number cell values for the reason that column.