Excel读取

1、读取，传入excel地址，如：D:\1.xls

public static List Excel(String path) throws Exception {        FileInputStream file = new FileInputStream(path);        HSSFWorkbook wb = new HSSFWorkbook(file);        HSSFSheet sheet = wb.getSheetAt(0);        List<Map<String, Object>> mapList = new ArrayList<>();        //获取Excel总行数，然后循环        for (int j = 2; j <= sheet.getLastRowNum(); j++) {            Row row = sheet.getRow(j);//获取某行            int coloumNum=sheet.getRow(0).getPhysicalNumberOfCells();//获得总列数            Map<String, Object> map = new HashMap<>();            String merc_order_no = getCell((HSSFCell) row.getCell(4));            System.out.println("order_amt:" + order_amt + ",");        }}public static String getCell(HSSFCell cell) {        if (cell == null)            return "";        switch (cell.getCellType()) {            case HSSFCell.CELL_TYPE_NUMERIC:                return cell.getNumericCellValue() + "";            case HSSFCell.CELL_TYPE_STRING:                return cell.getStringCellValue();            case HSSFCell.CELL_TYPE_FORMULA:                return cell.getCellFormula();            case HSSFCell.CELL_TYPE_BLANK:                return "";            case HSSFCell.CELL_TYPE_BOOLEAN:                return cell.getBooleanCellValue() + "";            case HSSFCell.CELL_TYPE_ERROR:                return cell.getErrorCellValue() + "";        }        return "";    }