easyexcel最新版本:1.1.2-beta4
源码git地址:easyexcel
maven坐标:
com.alibaba
easyexcel
1.1.2-beta4
一、定义Java模型,以Java模型解析excel文件
@Data
public class WeatherModel extends BaseRowModel {
@ExcelProperty(index = 0)
private String areaId;
@ExcelProperty(index = 1)
private String nameEn;
@ExcelProperty(index = 2)
private String nameCn;
}
二、读取小于1000行的Excel文件
/**
* 读取小于1000行的数据
*/
private static void readSmallExcel(){
String fileName = "/Users/xxx/Desktop/weather.xlsx";
InputStream inputStream = getInputStream(fileName);
try {
//new Sheet(int sheetNum, int headLineNum, Class extends BaseRowModel> clazz)
Listdata = EasyExcelFactory.read(inputStream, new