How can I analize Excel file with Apache POI?

[Armen Arzumanyan]

How can I analize Excel file with Apache POI?
I have excel file with a lot of cell values, some values must be ignored some cells must be split into two part,

public void displayFromExcel(String filename) {
    InputStream inputStream = null;
    try {
      inputStream = new FileInputStream(filename);
    } catch (FileNotFoundException e) {
      System.out.println("File not found in the specified path.");
      e.printStackTrace();
    }
 
 
    POIFSFileSystem fileSystem = null;
 
    try {
      fileSystem = new POIFSFileSystem(inputStream);
 
      HSSFWorkbook workBook = new HSSFWorkbook(fileSystem);
      HSSFSheet sheet = workBook.getSheetAt(0);
      //HSSFRow row     = sheet.getRow(2);       
      //HSSFCell cell   = row.getCell((short)3);  // fourth cell
      Iterator<HSSFRow> rows = sheet.rowIterator();
 
      while (rows.hasNext()) {
        HSSFRow row = rows.next();
       // System.out.println("Row No.: " + row.getRowNum());
        Iterator<HSSFCell> cells = row.cellIterator();
 
        while (cells.hasNext()) {
          HSSFCell cell = cells.next();
 
         // System.out.println("Cell No.: " + cell.getCellNum());
          
          switch (cell.getCellType()) {
            case HSSFCell.CELL_TYPE_NUMERIC: {              
              System.out.println("Numeric value: " + cell.getNumericCellValue());              
              
              break;
            }
            case HSSFCell.CELL_TYPE_STRING: {              
              HSSFRichTextString richTextString = cell.getRichStringCellValue();              
             
             
              System.out.println("String value: " + richTextString.getString());
              break;
            }
            default: {              
              //System.out.println("Type not supported.");
              break;
            }
          }
        }
      }
    } catch (IOException e) {
      e.printStackTrace();
    }
  }

this code read all strings and numbers, but I need split it into different blocks ............................
[ November 28, 2008: Message edited by: Martijn Verburg ]

[Ulf Dittmer]

Can you give an example of the contents of a spreadsheet cell, along with what the result of the analysis would be?