Advertisement
Guest User

Untitled

a guest
Dec 6th, 2016
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.28 KB | None | 0 0
  1. private Set<String> readRowsFromExcel(XSSFWorkbook workbook, int sheetNumber) {
  2. XSSFSheet sheet = workbook.getSheetAt(sheetNumber);
  3. Set<String> rows = new HashSet<>();
  4. for (Row row : sheet) {
  5. StringBuilder cells = new StringBuilder();
  6. Iterator<Cell> cellIterator = row.cellIterator();
  7. while (cellIterator.hasNext()) {
  8. Cell cell = cellIterator.next();
  9. switch (cell.getCellType()) {
  10. case Cell.CELL_TYPE_NUMERIC:
  11. cells.append(String.valueOf(cell.getNumericCellValue()));
  12. break;
  13. case Cell.CELL_TYPE_STRING:
  14. cells.append(cell.getStringCellValue());
  15. break;
  16. }
  17. cells.append(" | ");
  18. }
  19. rows.add(cells.toString());
  20. }
  21. return rows;
  22. }
  23.  
  24. final Set<String> expRows = readRowsFromExcel(expWorkbook, 0);
  25. final Set<String> actRows = readRowsFromExcel(actWorkbook, 0);
  26.  
  27. if (expRows.size() != actRows.size()) {
  28. //бросаем ошибку
  29. } else {
  30. for (final String row : expRows) {
  31. if (!actRows.contains(row)) {
  32. //бросаем ошибку
  33. break;
  34. }
  35. }
  36. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement