package finder1;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.util.Date;
import org.apache.poi.xssf.usermodel.*;


public class Finder1 {
    
    private static XSSFWorkbook readFile(String filename) throws IOException {
        return new XSSFWorkbook(new FileInputStream(filename));
    }


    public static void main(String[] args) throws FileNotFoundException, IOException, Exception {

  String fileName = "D:\\proj\\92.xlsx";
  
  String value = null;
    
  try {

      XSSFWorkbook wb = Finder1.readFile(fileName);
                                for (int nsh = 0; nsh < wb.getNumberOfSheets(); nsh++) {
                                XSSFSheet sheet = wb.getSheetAt(nsh);
                                
                                    for (int nr = 0; nr <sheet.getPhysicalNumberOfRows();nr++ ){
                                    XSSFRow row = sheet.getRow(nr);
                                    if (row == null) { continue; }
                                    
                                            //System.out.println("row.getPhysicalNumberOfCells()="+row.getPhysicalNumberOfCells());

                                    for(int nc = 0;nc<=row.getPhysicalNumberOfCells()+1;nc++){
                                           
                                            XSSFCell cell = row.getCell(nc);
                                            if (cell == null) { continue; }
                                           
                                            Date dat;
                                            Double d;
                                            

                                            switch (cell.getCellType()) {
                                                
                                                case XSSFCell.CELL_TYPE_NUMERIC:System.out.println("CELL_TYPE_NUMERIC");

                                            try{
                                                //№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№ №№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№
                                                //почему для явно указанного формата ячейки столбца 1 как ДАТА, POI  понимает как число!!!!!!!!!!
                                                //№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№№
                                                //получаем дату    
                                                dat = cell.getDateCellValue();
                                                    value = dat.toString();
                                            }
                                                    
                                                    catch(Exception ex){
                                                        d=cell.getNumericCellValue(); 
                                                        value =d.toString();
                                                    }
                                                       
                                                    break;
                                                case XSSFCell.CELL_TYPE_STRING:System.out.println("CELL_TYPE_STRING");
                                                    
                                                    
                                                    try{
                                                    dat = cell.getDateCellValue();
                                                    value = dat.toString();}
                                                    catch(Exception ex){
                                                        value = cell.getStringCellValue(); 
                                                    }
                                                            break;
                                                    
                                                    
                                                case XSSFCell.CELL_TYPE_BLANK:  System.out.println("CELL_TYPE_BLANK");

                                                    XSSFCell c1 = row.getCell(nc);
                                                    System.out.println(c1.getCellType()+" "+XSSFCell.CELL_TYPE_NUMERIC+"!!!");
                                                    System.out.println(c1.getRichStringCellValue());
                                                    d=c1.getNumericCellValue(); value =d.toString();
                                                    break;
                                                           
                                                default:System.out.println("default");
                                                    Integer f = cell.getCellType();
                                                    value = f.toString();
                                                }
                                                System.out.println(cell.getCellType()+"    "+value);
                                            cell=null;
                                        }
                                        row=null;
                                    }
                                 sheet=null;
                                }
                                
		} catch (Exception e) {e.printStackTrace();}	
    }
   
}

public static String get_cell(XSSFCell cell) {
String s="";
    switch (cell.getCellType()) {
        case XSSFCell.CELL_TYPE_STRING:  s=cell.getRichStringCellValue().getString();break;
        case XSSFCell.CELL_TYPE_NUMERIC: 

            if (DateUtil.isCellDateFormatted(cell)) //вот этот костыль - высший пилотаж!)))
                 {s=cell.getDateCellValue().toString();} 
            else {s=Double.toString(cell.getNumericCellValue());}
            break;

        case XSSFCell.CELL_TYPE_BOOLEAN: s=Boolean.toString(cell.getBooleanCellValue()); break;
        case XSSFCell.CELL_TYPE_FORMULA: s=cell.getCellFormula(); break;
        default:
    }
return(s);
}