Java读取Excel文件，返回list_java读取excel文件返回列表

1、添加pom依赖文件

<dependency>
	<groupId>net.sourceforge.jexcelapi</groupId>
	<artifactId>jxl</artifactId>
	<version>2.6</version>
</dependency>
1
2
3
4
5

2、循环读取excel行

private static List<String> parseExcelChargePos(File file) throws Exception{
        List<String> list = new ArrayList<>();
        Workbook wb = Workbook.getWorkbook(file);
        Sheet sheet = wb.getSheets()[0];
        for (int i = 1; i <=sheet.getRows(); i++) {
            Cell cell = sheet.getCell(0, i);
            String content = cell.getContents();
            list.add(content);
        }
        return list;
    }
1
2
3
4
5
6
7
8
9
10
11

3、测试方法

 List<String> userPos = parseExcelChargePos(new File("/27000099.xls"));
    for (String user:userPos) {
        logger.info("正在插入数据："+i);
        //业务处理代码
        
    }
   }
1
2
3
4
5
6
7