Advertisement
Guest User

Untitled

a guest
Apr 27th, 2022
47
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.92 KB | None | 0 0
  1.     private Vector<Vector<Cell>> leerArchivoExcel(HSSFWorkbook archivo) {
  2.         Vector<Vector<Cell>> cellVectorHolder = new Vector<Vector<Cell>>();
  3.         try {
  4.             HSSFSheet mySheet = archivo.getSheetAt( 0 );
  5.             Iterator<Row> rowIter = mySheet.rowIterator();
  6.             while (rowIter.hasNext()) {
  7.                 Row myRow = rowIter.next();
  8.                 Vector<Cell> cellStoreVector = new Vector<Cell>();
  9.                 int lastColumn = Math.max( myRow.getLastCellNum(), 5 );
  10.                 for (int cn = 0; cn < lastColumn; cn++) {
  11.                     Cell c = myRow.getCell( cn, Row.MissingCellPolicy.CREATE_NULL_AS_BLANK );
  12.                     cellStoreVector.addElement( c );
  13.                 }
  14.                 cellVectorHolder.addElement( cellStoreVector );
  15.             }
  16.         } catch (Exception e) {
  17.             LOG.error(e.getMessage());
  18.         }
  19.         return cellVectorHolder;
  20.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement