Uploaded image for project: 'JBeret'
  1. JBeret
  2. JBERET-70

Implement Excel ItemReader

XMLWordPrintable

    • Icon: Feature Request Feature Request
    • Resolution: Done
    • Icon: Major Major
    • 1.1.0.Alpha1
    • 1.0.2.Final
    • jberet-support
    • None

      POI is used for reading and writing excel, and jackson-databind is used for POJO binding, deserialization and serialization. To customize the mapping between excel column names and Java Beans properties for both Excel ItemReader and Excel ItemWriter, use jackson annotations or the more portable JAXB annotations.

      Busy Developers' Guide to Apache POI HSSF and XSSF Features
      POI How to

      jXLS provides jxls-reader module to read XLS files and populate Java beans with spreadsheet data.

      Comparison of JETT and Jxls, 2 framework on top of POI for excel and bean binding and transformation.

      XLSBeans is another library for mapping Excel sheets to POJOs.

          1.
          		 Implement Excel ItemReader with POI usermodel (a la DOM) Sub-task Resolved Major Cheng Fang
          2.
          		 Implement OOXML ExcelStreamingItemReader with StAX Sub-task Resolved Major Cheng Fang
          3.
          		 Implement *.xls ExcelEventItemReader with POI HSSF event API Sub-task Resolved Major Cheng Fang

              cfang@redhat.com Cheng Fang
              cfang@redhat.com Cheng Fang
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: