<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>

                ThinkChat2.0新版上線,更智能更精彩,支持會話、畫圖、視頻、閱讀、搜索等,送10W Token,即刻開啟你的AI之旅 廣告
                ![](https://img.kancloud.cn/3b/ef/3befa76ae26a96ffc6716394e20f18a2_1473x178.jpg) **1. 創建對應的實體類** 如果使用注解`@ExcelProperty`標記屬性,則屬性聲明的順序不必與表格中列的順序一致。 ```java /** 1. 如果沒有用注解@ExcelProperty,則聲明屬性的順序要與表格中列的順序一致 */ @Data public class Student { private String name; private Integer age; private String gender; private Integer total; } /** 2. 如果用注解@ExcelProperty,則聲明屬性的順序不必與表格中列的順序一致 */ @Data public class Student { @ExcelProperty(index = 3) private Integer total; @ExcelProperty(index = 2) private String gender; @ExcelProperty(index = 1) private Integer age; @ExcelProperty(index = 0) private String name; } /** 3. 也可以指定表頭名稱 */ @Data public class Student { @ExcelProperty("身高") private Integer total; @ExcelProperty("性別") private String gender; @ExcelProperty("年齡") private Integer age; @ExcelProperty("姓名") private String name; } ``` **2. 創建對應的監聽器** ```java @Slf4j public class StudentExcelListener implements ReadListener<Student> { /** * 每讀取表格中的一行時就會被調用一次 */ @Override public void invoke(Student student, AnalysisContext analysisContext) { log.info("invoke -> {}", student); //invoke -> Student(total=175, gender=男, age=25, name=張三) //invoke -> Student(total=179, gender=男, age=28, name=李四) //invoke -> Student(total=180, gender=男, age=35, name=王五) } /** * 當讀取完表格所有的行后被調用 */ @Override public void doAfterAllAnalysed(AnalysisContext analysisContext) { log.info("doAfterAllAnalysed"); } } ``` **3. 調用`EasyExcel.read`方法讀取表格** ```java @Test public void read01() { String path = this.getClass().getResource("/read/001.xlsx").getPath(); //讀取第一個sheet, 文件流會自動關閉的 EasyExcel.read(path, Student.class, new StudentExcelListener()).sheet().doRead(); } ```
                  <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>

                              哎呀哎呀视频在线观看