<ruby id="bdb3f"></ruby>

    <p id="bdb3f"><cite id="bdb3f"></cite></p>

      <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
        <p id="bdb3f"><cite id="bdb3f"></cite></p>

          <pre id="bdb3f"></pre>
          <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

          <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
          <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

          <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                <ruby id="bdb3f"></ruby>

                合規國際互聯網加速 OSASE為企業客戶提供高速穩定SD-WAN國際加速解決方案。 廣告
                :-: ![](https://img.kancloud.cn/0d/23/0d2352e68aecd259648945d721aab397_1504x224.jpg) ![](https://img.kancloud.cn/0c/53/0c5301e6b855c25831e335746c92053f_1493x224.jpg) Sheet1、Sheet2 **1. 創建對應的實體類** ```java @Data public class Student { @ExcelProperty("姓名") private String name; @ExcelProperty("年齡") private Integer age; @ExcelProperty("性別") private String gender; @ExcelProperty("身高") private Integer total; } ``` **2. 創建對應的監聽器** ```java @Slf4j public class StudentExcelListener implements ReadListener<Student> { /** * 每讀取表格中的一行時就會被調用一次 */ @Override public void invoke(Student student, AnalysisContext analysisContext) { log.info("invoke -> {}", student); //invoke -> Student(name=張三, age=25, gender=男, total=175) //invoke -> Student(name=李四, age=28, gender=男, total=179) //invoke -> Student(name=王五, age=35, gender=男, total=180) // //invoke -> Student(total=175, gender=男, age=25, name=zhangsan) //invoke -> Student(total=179, gender=男, age=28, name=lisi) //invoke -> Student(total=180, gender=男, age=35, name=wangwu) } /** * 每當讀取完一個sheet就會被調用一次 */ @Override public void doAfterAllAnalysed(AnalysisContext analysisContext) { log.info("doAfterAllAnalysed"); } } ``` **3. 調用`EasyExcel.read(...).doReadAll()`方法讀取所有的sheet** ```java @Test public void read02() { String path = this.getClass().getResource("/read/001.xlsx").getPath(); EasyExcel.read(path, Student.class, new StudentExcelListener()).doReadAll(); } ``` **4. 調用`EasyExcel.readSheet(index)`方法讀取指定的sheet** ```java @Test public void read03() { String path = this.getClass().getResource("/read/001.xlsx").getPath(); //讀取第一個sheet, 文件流會自動關閉的 EasyExcel.read(path, Student.class, new StudentExcelListener()).doReadAll(); try (ExcelReader excelReader = EasyExcel.read(path).build()) { ReadSheet readSheet1 = EasyExcel.readSheet(0).head(Student.class).registerReadListener(new StudentExcelListener()).build(); ReadSheet readSheet2 = EasyExcel.readSheet(1).head(Student.class).registerReadListener(new StudentExcelListener()).build(); //注意:一個sheet不能讀取多次,比如第0個sheet已經被讀取過了,所在不能再調用EasyExcel.readSheet(0) //注意:一定要把sheet1、sheet2 一起傳進去,不然有個問題就是03版的excel會讀取多次,浪費性能 excelReader.read(readSheet1, readSheet2); } } ```
                  <ruby id="bdb3f"></ruby>

                  <p id="bdb3f"><cite id="bdb3f"></cite></p>

                    <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
                      <p id="bdb3f"><cite id="bdb3f"></cite></p>

                        <pre id="bdb3f"></pre>
                        <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

                        <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
                        <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

                        <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                              <ruby id="bdb3f"></ruby>

                              哎呀哎呀视频在线观看