Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- while(rowITR.hasNext())
- {
- row = (XSSFRow)rowITR.next();
- cellITR = row.cellIterator();
- while(cellITR.hasNext())
- {
- cell = (XSSFCell)cellITR.next();
- switch (cell.getCellType()){
- case XSSFCell.CELL_TYPE_STRING:
- if((cell.getReference().startsWith("A")&&(cell.getRowIndex()>1)))
- {
- inSheet=cell.getStringCellValue();
- }
- if((cell.getReference().startsWith("B")&&(cell.getRowIndex()>1)))
- { inCell=cell.getStringCellValue();
- inLIST.add(inCell);
- }
- if((cell.getReference().startsWith("C")&&(cell.getRowIndex()>1)))
- {
- outSheet=cell.getStringCellValue();
- }
- if((cell.getReference().startsWith("D")&&(cell.getRowIndex()>1)))
- {
- outCell=cell.getStringCellValue();
- outLIST.add(outCell); //
- }
- break;
- case XSSFCell.CELL_TYPE_BLANK:
- break;
- }
- }
- }
- -----------------------------------------------------------------------
- sheet-info.xlsx
- <http://i.stack.imgur.com/5ivsd.gif>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement