java 使用poi导入Excel通用方法

需要的jar：

[XML] 纯文本查看 复制代码

?

1 2 3 4 5

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

java代码：

[Java] 纯文本查看 复制代码

?

01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87

public static String importExcel(String filePath) throws Exception {        //判断文件        if (filePath != null && !"".equals(filePath)) {            File file = new File(filePath);            //判断格式            if (file.getName().endsWith(EXCEL_XLS) || file.getName().endsWith(EXCEL_XLSX)) {                //创建输入流对象                InputStream is = new FileInputStream(file);                Workbook workbook = null;                //判断excel版本号                if (file.getName().endsWith(EXCEL_XLS)) {                    workbook = new HSSFWorkbook(is);                } else if (file.getName().endsWith(EXCEL_XLSX)) {                    workbook = new XSSFWorkbook(is);                }                Map<String, Object> objectMap=new HashMap<>();                //循环表格（sheet）                for (int i = 0; i < workbook.getNumberOfSheets(); i++) {                    Sheet sheet = workbook.getSheetAt(i);                    //判断sheet是否有数据                    if (sheet.getPhysicalNumberOfRows() <= 0) {                        continue;                    }                    //存放集合                    List<Map<String, Object>> list = new ArrayList<>();                    //存放表头名字（第一行的数据） 更多技术资讯可关注:itheimaGZ获取