danmaidesenling
danmaidesenling
> Follow your example, but i got OutOfMemory error if reading large excel file (1GB). Small one(200MB) still good. > Here is the line throw error because of reading whole...
> you also created #252 - your issue is basically a duplicate of #193 Thank you ! Have closed #252 I will update xlsx-streamer version to 2.2.0 and try.
Can anyone help me out : )
your code on this: ```java ExcelWorkSheetRowCallbackHandler sheetRowCallbackHandler = new ExcelWorkSheetRowCallbackHandler(new ExcelRowContentCallback() { @Override public void processRow(int rowNum, Map map) { // Do any custom row processing here, such as save...
Actually, POI has provided type information . You can see it in WorkBook
Well.,sample code like this: ```java 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...