日本免费全黄少妇一区二区三区-高清无码一区二区三区四区-欧美中文字幕日韩在线观看-国产福利诱惑在线网站-国产中文字幕一区在线-亚洲欧美精品日韩一区-久久国产精品国产精品国产-国产精久久久久久一区二区三区-欧美亚洲国产精品久久久久

  1. 首頁 > 云知道 > >

java實現excel導入 java批量導入excel數據( 四 )

云知道

public static void main(String[] args) throws FileNotFoundException {FileInputStream inputStream = new FileInputStream(new File("/Users/panzhi/Documents/easyexcel-user1.xls"));//初始化一個監(jiān)聽器UserDataListener userDataListener = new UserDataListener();//讀取文件數據EasyExcel.read(inputStream, userDataListener).sheet().doRead();System.out.println("表頭：" + JSONArray.toJSONString(userDataListener.getHeadList()));System.out.println("數據體：" + JSONArray.toJSONString(userDataListener.getDataList()));}運行程序，輸出結果如下：
表頭：[{0:"姓名",1:"年齡",2:"操作時間"}]數據體：[{0:"張三0",1:"20",2:"2021-03-28 16:32:40"},{0:"張三1",1:"21",2:"2021-03-28 16:32:40"},{0:"張三2",1:"22",2:"2021-03-28 16:32:40"},{0:"張三3",1:"23",2:"2021-03-28 16:32:40"},{0:"張三4",1:"24",2:"2021-03-28 16:32:40"},{0:"張三5",1:"25",2:"2021-03-28 16:32:40"},{0:"張三6",1:"26",2:"2021-03-28 16:32:40"},{0:"張三7",1:"27",2:"2021-03-28 16:32:40"},{0:"張三8",1:"28",2:"2021-03-28 16:32:40"},{0:"張三9",1:"29",2:"2021-03-28 16:32:40"}]其中key表示列下表！
2.3.3、復雜表頭讀取在實際的開發(fā)中，我們還會遇到復雜表頭的數據讀取，以如下表頭為例，我們應該如何讀取呢？

java實現excel導入 java批量導入excel數據


如果你是采用注解的方式導出的文件，同樣也可以通過注解方式來讀取，例如上文中，我們是使用如下實體類生成的文件，我們也可通過這個類讀取文件！
public class UserEntity {@ExcelProperty(value = "https://www.jinnalai.com/fenxiang/班級")private String className;@ExcelProperty({"學生信息", "姓名"})private String name;@ExcelProperty({"學生信息", "年齡"})private int age;@DateTimeFormat("yyyy-MM-dd HH:mm:ss")@ExcelProperty({"學生信息", "入學時間"})private Date time;//set、get}//讀取文件List<UserEntity> list = EasyExcel.read(filePath).head(UserEntity.class).sheet().doReadSync();System.out.println(JSONArray.toJSONString(list));讀取結果如下：
[{"age":20,"className":"一年級～1班","name":"張三0","time":1618719961000},{"age":21,"className":"一年級～1班","name":"張三1","time":1618719961000},{"age":22,"className":"一年級～1班","name":"張三2","time":1618719961000},{"age":23,"className":"一年級～1班","name":"張三3","time":1618719961000},{"age":24,"className":"一年級～1班","name":"張三4","time":1618719961000},{"age":25,"className":"一年級～1班","name":"張三5","time":1618719961000},{"age":26,"className":"一年級～1班","name":"張三6","time":1618719961000},{"age":27,"className":"一年級～1班","name":"張三7","time":1618719961000},{"age":28,"className":"一年級～1班","name":"張三8","time":1618719961000},{"age":29,"className":"一年級～1班","name":"張三9","time":1618719961000}]如果你是使用動態(tài)參數化來生成文件，那么這個時候可以采用動態(tài)監(jiān)聽器的方式來讀取文件，在讀取的時候需要指定數據所在行，示例代碼如下：
public static void main(String[] args) throws FileNotFoundException {FileInputStream inputStream = new FileInputStream(new File("/Users/panzhi/Documents/easyexcel-export-user4.xlsx"));//初始化一個監(jiān)聽器UserDataListener userDataListener = new UserDataListener();//讀取文件數據，指定數據所在行使用headRowNumber方法EasyExcel.read(inputStream, userDataListener).sheet().headRowNumber(2).doRead();System.out.println("表頭：" + JSONArray.toJSONString(userDataListener.getHeadList()));System.out.println("數據體：" + JSONArray.toJSONString(userDataListener.getDataList()));}讀取結果如下：
表頭：[{0:"班級",1:"學生信息",2:"學生信息",3:"學生信息"},{0:"班級",1:"姓名",2:"年齡",3:"入學時間"}]數據體：[{0:"一年級～1班",1:"張三0",2:"20",3:"2021-04-18 12:26:01"},{0:"一年級～1班",1:"張三1",2:"21",3:"2021-04-18 12:26:01"},{0:"一年級～1班",1:"張三2",2:"22",3:"2021-04-18 12:26:01"},{0:"一年級～1班",1:"張三3",2:"23",3:"2021-04-18 12:26:01"},{0:"一年級～1班",1:"張三4",2:"24",3:"2021-04-18 12:26:01"},{0:"一年級～1班",1:"張三5",2:"25",3:"2021-04-18 12:26:01"},{0:"一年級～1班",1:"張三6",2:"26",3:"2021-04-18 12:26:01"},{0:"一年級～1班",1:"張三7",2:"27",3:"2021-04-18 12:26:01"},{0:"一年級～1班",1:"張三8",2:"28",3:"2021-04-18 12:26:01"},{0:"一年級～1班",1:"張三9",2:"29",3:"2021-04-18 12:26:01"}]

推薦閱讀