Does it has low memory footprint ?

[danmaidesenling]

No description provided.

[jeevatkm]

@danmaidesenling I believe so. Just released v1.3 to maven central. Please give it try.

[danmaidesenling]

your code on this:

ExcelWorkSheetRowCallbackHandler sheetRowCallbackHandler = new ExcelWorkSheetRowCallbackHandler(new ExcelRowContentCallback() {
    @Override
    public void processRow(int rowNum,    Map<String, String> map) {
        // Do any custom row processing here, such as save
        // to database
        // Convert map values, as necessary, to dates or
        // parse as currency, etc
        System.out.println("rowNum=" + rowNum + ", map=" + map);
    }
});

you said that Convert map values, as necessary, to dates or parse as currency, etc.
BUT What type to convert? I mean How to know the data_type of the cell

[jeevatkm]

Typically, you have to know the structure (no. of columns, column names, etc) and excel column type information. POI doesn't provide type information.

Example 1:

There is a excel file you're reading that has 3 columns -

• column 1: Row number, integer
• column 2: Full Name, string
• column 3: join date, date type

Per your requirement you have process it.

Example 2:

Let's say excel file has 50 columns, but per your requirements, you need 4 columns., etc.

[danmaidesenling]

Actually, POI has provided type information . You can see it in WorkBook

[jeevatkm]

Could you provide more specific details? that would be helpful.

[danmaidesenling]

Well.,sample code like this:

Workbook wb = WorkbookFactory.create(new File("MyExcel.xls"));
Sheet sheet = wb.getSheetAt(0);
Row row = sheet.getRow(0);
Cell cell = row.getCell(0);
int cellType = cell.getCellType();   //CELL_TYPE_NUMERIC = 0; CELL_TYPE_STRING = 1...

[jeevatkm]

Okay, I understand now what you meant. And what I meant was java data types not a excel cell types.

FYI excelReader library handles only XSSF (.xlsx file) and provides row values as a Map. Kindly handle java type conversion at your end.

PS: feel free to PR for any improvements, thanks.