<dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-ooxml</artifactId>
            <version>4.1.2</version>
        </dependency>

 /**
     * 讀取Excel文件的內(nèi)容
     * @param inputStream excel文件，以InputStream的形式傳入
     * @param sheetName sheet名字
     * @return 以List返回excel中內(nèi)容
     */
    public static List<Map<String, String>> readExcel(InputStream inputStream, String sheetName) {

        //定義工作簿
        XSSFWorkbook xssfWorkbook = null;
        try {
            xssfWorkbook = new XSSFWorkbook(inputStream);
        } catch (Exception e) {
            System.out.println("Excel data file cannot be found!");
        }

        //定義工作表
        XSSFSheet xssfSheet;
        if (sheetName.equals("")) {
            // 默認(rèn)取第一個(gè)子表
            xssfSheet = xssfWorkbook.getSheetAt(0);
        } else {
            xssfSheet = xssfWorkbook.getSheet(sheetName);
        }

        List<Map<String, String>> list = new ArrayList<Map<String, String>>();

        //定義行
        //默認(rèn)第一行為標(biāo)題行，index = 0
        XSSFRow titleRow = xssfSheet.getRow(0);

        //循環(huán)取每行的數(shù)據(jù)
        for (int rowIndex = 1; rowIndex < xssfSheet.getPhysicalNumberOfRows(); rowIndex++) {
            XSSFRow xssfRow = xssfSheet.getRow(rowIndex);
            if (xssfRow == null) {
                continue;
            }

            Map<String, String> map = new LinkedHashMap<String, String>();
            //循環(huán)取每個(gè)單元格(cell)的數(shù)據(jù)
            for (int cellIndex = 0; cellIndex < xssfRow.getPhysicalNumberOfCells(); cellIndex++) {
                XSSFCell titleCell = titleRow.getCell(cellIndex);
                XSSFCell xssfCell = xssfRow.getCell(cellIndex);
                map.put(getString(titleCell),getString(xssfCell));
            }
            list.add(map);
        }
        return list;
    }

    /**
     * 把單元格的內(nèi)容轉(zhuǎn)為字符串
     * @param xssfCell 單元格
     * @return 字符串
     */
    public static String getString(XSSFCell xssfCell) {
        if (xssfCell == null) {
            return "";
        }
        if (xssfCell.getCellTypeEnum() == CellType.NUMERIC) {
            return String.valueOf(xssfCell.getNumericCellValue());
        } else if (xssfCell.getCellTypeEnum() == CellType.BOOLEAN) {
            return String.valueOf(xssfCell.getBooleanCellValue());
        } else {
            return xssfCell.getStringCellValue();
        }
    }

    /**
     * 把內(nèi)容寫入Excel
     * @param list 傳入要寫的內(nèi)容，此處以一個(gè)List內(nèi)容為例，先把要寫的內(nèi)容放到一個(gè)list中
     * @param outputStream 把輸出流懟到要寫入的Excel上，準(zhǔn)備往里面寫數(shù)據(jù)
     */
    public static void writeExcel(List<List> list, OutputStream outputStream) {
        //創(chuàng)建工作簿
        XSSFWorkbook xssfWorkbook = null;
        xssfWorkbook = new XSSFWorkbook();

        //創(chuàng)建工作表
        XSSFSheet xssfSheet;
        xssfSheet = xssfWorkbook.createSheet();

        //創(chuàng)建行
        XSSFRow xssfRow;

        //創(chuàng)建列，即單元格Cell
        XSSFCell xssfCell;

        //把List里面的數(shù)據(jù)寫到excel中
        for (int i=0;i<list.size();i++) {
            //從第一行開始寫入
            xssfRow = xssfSheet.createRow(i);
            //創(chuàng)建每個(gè)單元格Cell，即列的數(shù)據(jù)
            List sub_list =list.get(i);
            for (int j=0;j<sub_list.size();j++) {
                xssfCell = xssfRow.createCell(j); //創(chuàng)建單元格
                xssfCell.setCellValue((String)sub_list.get(j)); //設(shè)置單元格內(nèi)容
            }
        }

        //用輸出流寫到excel
        try {
            xssfWorkbook.write(outputStream);
            outputStream.flush();
            outputStream.close();
        }catch (IOException e) {
            e.printStackTrace();
        }

    }

public static List<List> convertMapToList(Map map) {
        List<List> list = new ArrayList<List>();
        List<String> key_list = new LinkedList<String>();
        List<String> value_list = new LinkedList<String>();

        Set<Entry<String,String>> set = map.entrySet();
        Iterator<Entry<String,String>> iter1 = set.iterator();
        while (iter1.hasNext()) {
            key_list.add(iter1.next().getKey());
        }
        list.add(key_list);

        Collection<String> value = map.values();
        Iterator<String> iter2 = value.iterator();
        while (iter2.hasNext()) {
            value_list.add(iter2.next());
        }
        list.add(value_list);
        return list;
    }