package com.demo;

 import java.io.FileInputStream;

 import java.util.Iterator;

 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;

 public class DemoTest {

     public static void main(String[] args) {

         System.out.println(readXls(System.getProperty("user.dir") + "\\case\\副本业务编码大全.xls"));

     }

     public static String readXls(String path) {

         String text = "";

         try {

             FileInputStream is = new FileInputStream(path);

             HSSFWorkbook excel = new HSSFWorkbook(is);

             // 获取第一个sheet

             HSSFSheet sheet0 = excel.getSheetAt(0);

             for (Iterator<?> rowIterator = sheet0.iterator(); rowIterator.hasNext();) {

                 HSSFRow row = (HSSFRow) rowIterator.next();

                 for (Iterator<?> iterator = row.cellIterator(); iterator.hasNext();) {

                     HSSFCell cell = (HSSFCell) iterator.next();

                     // 根据单元的的类型 读取相应的结果

                     if (cell.getCellType() == HSSFCell.CELL_TYPE_STRING)

                         text += cell.getStringCellValue() + "\t";

                     else if (cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC)

                         text += cell.getNumericCellValue() + "\t";

                     else if (cell.getCellType() == HSSFCell.CELL_TYPE_FORMULA)

                         text += cell.getCellFormula() + "\t";

                 }

                 text += "\n";

             }

         } catch (Exception e) {

             // TODO Auto-generated catch block

             e.printStackTrace();

         }

         return text;

     }

 }