Advertisement
Guest User

Untitled

a guest
Jul 7th, 2015
207
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.40 KB | None | 0 0
  1. public String maleNumerical(String malePersonalVestSize, String v) {
  2. column = 5;
  3. row = 6;
  4. cell = null;
  5. int vValue = Integer.valueOf(v.substring(v.length() - 1));
  6. String valueOfCell;
  7. valueOfCell = "";
  8. String maleNumericalValue = "";
  9.  
  10. try {
  11. workb = Workbook.getWorkbook(new File("NFM SFST.sfst"));
  12. sheet = workb.getSheet("TTV14-MALE");
  13.  
  14. for (column = 5; column < 20; column += 2) {
  15. for (row = 6; row < 78; row++) {
  16. cell = sheet.getCell(column, row);
  17. valueOfCell = cell.getContents().replace(" ", "");
  18. if (malePersonalVestSize.equals(valueOfCell)) {
  19. row += vValue;
  20. column--;
  21. cell = sheet.getCell(column, row);
  22. maleNumericalValue = cell.getContents();
  23. }
  24. }
  25. }
  26.  
  27. } catch (Exception e) {
  28. e.printStackTrace();
  29. }
  30. maleNumericalValue.replace(" ", "");
  31. return maleNumericalValue;
  32. }
  33.  
  34. //-------------------------NUMERICAL MALE-UP-----------------------------------
  35. //----------------------------NUMERICAL FEALE------------------------------------
  36. public String femaleNumerical(String femalePersonalVestSize, String v, String bustSize) {
  37. column = 4;
  38. row = 4;
  39. cell = null;
  40. value = 0.0;
  41. index = 0;
  42. int column_tmp = 0;
  43. String femaleNumericalValue = "";
  44. String femalePersonalVestSizePart1 = femalePersonalVestSize.substring(0, femalePersonalVestSize.length() - 1);
  45. int femalePersonalVestSizePart2 = Integer.valueOf(femalePersonalVestSize.substring(femalePersonalVestSize.length() - 1));
  46. int vValue = 0;
  47. vValue = Integer.valueOf(v.substring(v.length() - 1));
  48. String valueOfCell = "";
  49. femalePersonalVestSize = "";
  50. try {
  51. workb = Workbook.getWorkbook(new File("NFM SFST.sfst"));
  52. sheet = workb.getSheet("TTV14-FEMALE");
  53.  
  54. for (column = 4; column < 47; column += 4) {
  55. cell = sheet.getCell(column, row);
  56. valueOfCell = cell.getContents();
  57. valueOfCell = valueOfCell.replace(" ", "");
  58.  
  59. if (femalePersonalVestSizePart1.equals(valueOfCell)) {
  60. column_tmp = column;
  61.  
  62. break;
  63. }
  64.  
  65. }
  66. column = column_tmp;
  67. row += 2;
  68. row = row + ((femalePersonalVestSizePart2 - 1) * 8);
  69. row += vValue;
  70. if (bustSize.equals("A")) {
  71. cell = sheet.getCell(column, row);
  72. femaleNumericalValue = cell.getContents();
  73. }
  74. if (bustSize.equals("B")) {
  75. column++;
  76. cell = sheet.getCell(column, row);
  77. femaleNumericalValue = cell.getContents();
  78. }
  79. if (bustSize.equals("C")) {
  80. column += 2;
  81. cell = sheet.getCell(column, row);
  82. femaleNumericalValue = cell.getContents();
  83. }
  84.  
  85. } catch (Exception e) {
  86. e.printStackTrace();
  87. }
  88. femaleNumericalValue = femaleNumericalValue.replace(" ", "");
  89. return femaleNumericalValue;
  90. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement