添加依赖
<!--poi-->
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>4.0.1</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>4.0.1</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml-schemas</artifactId>
<version>4.0.1</version>
</dependency>
代码示例
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import java.io.File;
import java.io.FileInputStream;
import java.io.InputStream;
import java.net.URL;
import java.net.URLDecoder;
import java.util.ArrayList;
import java.util.Collections;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
/**
* @program: simple_tools
* @description: Excel读取工具类
* @author: Mr.chen
* @create: 2020-04-30 09:55
**/
public class ExcelReader {
private static final String XLS = "xls";
private static final String XLSX = "xlsx";
private static final String ENCODING_TYPE_UTF = "UTF-8";
private static final int ROW_TYPE_FLAG = 0;
private static final int LIST_TYPE_FLAG = 1;
/**
* 读取Excel文件
*
* @param fileName 读取Excel文件的名称
* @param sheetName 读取Excel文件的SheetName
* @return
*/
public static Map<String, Object> readExcel(String fileName, String sheetName) {
FileInputStream inputStream = null;
Workbook workbook = null;
try {
String fileType =