Edit Question - KnowledgeHub

Title Body

I have tried to read an excel file using POI and then I wanted to put that data into a JTable . Here is the excel file, As you can see, there are two empty cells in the above table, once I read above data into a JTable I got following result, In my JTable , empty cells has moved to a wrong place, I used following codes to get this result please assist me to achieve the correct result, private XLSContainer xLSContainer; Vector cellVectorHolder; private int noOfCells=0; public XLSContainer readXLS(XLSFile xLSFile) { cellVectorHolder = new Vector(); try { FileInputStream inputStream = new FileInputStream(xLSFile.getFileName()); POIFSFileSystem pOIFSFileSystem = new POIFSFileSystem(inputStream); HSSFWorkbook hSSFWorkbook = new HSSFWorkbook(pOIFSFileSystem); HSSFSheet hSSFSheet = hSSFWorkbook.getSheetAt(0); Iterator rowIter = hSSFSheet.rowIterator(); while (rowIter.hasNext()) { HSSFRow row = (HSSFRow) rowIter.next(); if(row.getRowNum()==0){ noOfCells = row.getLastCellNum(); } Iterator cellIter = row.cellIterator(); Vector cellStoreVector = new Vector(); while (cellIter.hasNext()) { HSSFCell hSSFCell = (HSSFCell) cellIter.next(); //System.out.println(hSSFCell.getCellNum()); cellStoreVector.addElement(hSSFCell); } cellVectorHolder.addElement(cellStoreVector); } } catch (Exception e) { e.printStackTrace(); } feedXLSContainer(); return xLSContainer; }//

Tags (comma-separated) Cancel