Java读取Excel文件中的内容（简化版）

创建一个工程，导入pom坐标：

<dependency>
    <groupId>org.jxls</groupId>
    <artifactId>jxls-jexcel</artifactId>
    <version>1.0.6</version>
</dependency>

代码：

import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;

import java.io.*;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.Map;


public class Pricture {
    public static void main(String[] args) throws Exception {
        ArrayList<Map<String,String>> arrayList = new ArrayList();
       //创建工作薄
        jxl.Workbook wb = null;
       //获取文件输入流
        InputStream is = new FileInputStream("C://Users//123//Desktop//123//123.xls");
//改成你自己的文件路径，注意请用将文件另存为xls2003
        wb = Workbook.getWorkbook(is);
        int sheetSize = wb.getNumberOfSheets();
        Sheet sheet = wb.getSheet(0);
        int row_total = sheet.getRows();
        for (int j = 0; j < row_total; j++) {
            Cell[] cells = sheet.getRow(j);
            System.out.println(cells[2].getContents());
            Map<String,String> map=new HashMap<>();
            map.put("name",cells[0].getContents());
            map.put("buMen",cells[2].getContents());
            arrayList.add(map);

        }
 System.out.println(arrayList);

    }

}