POI 로 엑셀파일 읽기(xls , xlsx)

package test2;
 
import java.io.File;
import java.io.FileInputStream;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
 
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.usermodel.WorkbookFactory;
 
public class test3 {
 
    /**
     * @param args
     */
    public static void main(String[] args)   throws Exception{
        // TODO Auto-generated method stub
          InputStream is;
          
          List<Map<String , Object>> list = new ArrayList<Map<String,Object>>();
          
          try {
           
              
              File file = new File("d:/test.xlsx");
              
              if(file.exists()){
                  
                  System.out.println(file.getPath());
                 
                  
                  InputStream inp = new FileInputStream(file.getPath());
                  //InputStream inp = new FileInputStream("workbook.xlsx");
 
                  String fileName = file.getName();
                  int idx = fileName.lastIndexOf(".");
                  String fileExt = fileName.substring(idx+1);
                  
                  System.out.println("fileExt : " + fileExt);
                  
                  if("xls".equals(fileExt)){
                                            
                      POIFSFileSystem fileSystem = new POIFSFileSystem(inp);
                      HSSFWorkbook workbook = new HSSFWorkbook(fileSystem);
                      
                      HSSFRow row;
                      HSSFRow rowNm;
                      HSSFCell cell;
                      HSSFSheet sheet = workbook.getSheetAt(0);
                      
                      int rows; // No of rows
                      rows = sheet.getPhysicalNumberOfRows();
                      
                      System.out.println("the total number of rows are"+rows);
                      int cols = 0; // No of columns
                      int tmp = 1;
                        
                      for(int i = 0; i < 10 || i < rows; i++) {
                          row = sheet.getRow(i);
                          if(row != null) {
                              tmp = sheet.getRow(i).getPhysicalNumberOfCells();
                              if(tmp > cols){
                                  cols = tmp;
                              }
                          }
                      }
                      
                      rowNm = sheet.getRow(0);
                      
                      for(int r1 = 1; r1< rows; r1++) {
                          row = sheet.getRow(r1);
                          if(row == null || row.getCell(0) == null){
                              continue;
                          }else{
                              System.out.println("<row>");
                              Map<String,Object> map = new HashMap<String, Object>();
                              for(int c = 0; c < cols; c++) {
                                  cell = row.getCell(c);
                                  if(c == 0 && cell == null){
                                      break;
                                  }
                                  if(cell == null){
                                      map.put(rowNm.getCell(c).getRichStringCellValue().getString(), "");
                                  }else{
                                      map.put(rowNm.getCell(c).getRichStringCellValue().getString(), cell.getRichStringCellValue().getString());
                                  }
                                  System.out.println("\t<"+rowNm.getCell(c)+">" +cell+"</"+rowNm.getCell(c).getRichStringCellValue().getString()+">");
                                }
                                list.add(map);
                                System.out.println("</row>");
                                //cnt ++;
                            }
                      }
                      
                  }else {
                      Workbook wb = WorkbookFactory.create(inp);
                      Sheet sheet = wb.getSheetAt(0);
                    
                    Row row;
                    Row rowNm;
                    Cell cell;
                   
                    
                    int rows; // No of rows
                    rows = sheet.getPhysicalNumberOfRows();
                     
                    System.out.println("the total number of rows are"+rows);
                  
                    int cols = 0; // No of columns
                    int tmp = 1;
                    
                    for(int i = 0; i < 10 || i < rows; i++) {
                        
                        row = sheet.getRow(i);
                        if(row != null) {
                            tmp = sheet.getRow(i).getPhysicalNumberOfCells();
                           //out.println("tmp value"+tmp);
                            if(tmp > cols){
                                cols = tmp;
                            }
                        }
                    }
                   // out.println("<row><cell>"+cols+
                    rowNm = sheet.getRow(0);
                    int cnt = 1;
                    String blank = "";
                    for(int r1 = 1; r1< rows; r1++) {
                        row = sheet.getRow(r1);
                        if(row == null || row.getCell(0) == null){
                            continue;
                        }else{
                            System.out.println("<row>");
                            Map<String,Object> map = new HashMap<String, Object>();
                            for(int c = 0; c < cols; c++) {
                                cell = row.getCell((short)c);
                                if(c == 0 && cell == null){
                                    break;
                                }
                                if(cell == null){
                                    map.put(rowNm.getCell(c).getStringCellValue(), "");
                                }else{
                                    map.put(rowNm.getCell(c).getStringCellValue(), cell.getStringCellValue());
                                }
                                //System.out.println("\t<"+rowNm.getCell(c)+">" +cell+"</"+rowNm.getCell(c).getStringCellValue()+">");
                                
                               
                            }
                            list.add(map);
                            System.out.println("</row>");
                            cnt ++;
                        }
                    }
                    
                    System.out.println("cnt : " + cnt);
                    
                    System.out.println(list.size());
                    
                    System.out.println(list.toString());
                  }
                  
                  
         }
             
            
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
            
          
 
    }
 
}