Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public String maleNumerical(String malePersonalVestSize, String v) {
- column = 5;
- row = 6;
- cell = null;
- int vValue = Integer.valueOf(v.substring(v.length() - 1));
- String valueOfCell;
- valueOfCell = "";
- String maleNumericalValue = "";
- try {
- workb = Workbook.getWorkbook(new File("NFM SFST.sfst"));
- sheet = workb.getSheet("TTV14-MALE");
- for (column = 5; column < 20; column += 2) {
- for (row = 6; row < 78; row++) {
- cell = sheet.getCell(column, row);
- valueOfCell = cell.getContents().replace(" ", "");
- if (malePersonalVestSize.equals(valueOfCell)) {
- row += vValue;
- column--;
- cell = sheet.getCell(column, row);
- maleNumericalValue = cell.getContents();
- }
- }
- }
- } catch (Exception e) {
- e.printStackTrace();
- }
- maleNumericalValue.replace(" ", "");
- return maleNumericalValue;
- }
- //-------------------------NUMERICAL MALE-UP-----------------------------------
- //----------------------------NUMERICAL FEALE------------------------------------
- public String femaleNumerical(String femalePersonalVestSize, String v, String bustSize) {
- column = 4;
- row = 4;
- cell = null;
- value = 0.0;
- index = 0;
- int column_tmp = 0;
- String femaleNumericalValue = "";
- String femalePersonalVestSizePart1 = femalePersonalVestSize.substring(0, femalePersonalVestSize.length() - 1);
- int femalePersonalVestSizePart2 = Integer.valueOf(femalePersonalVestSize.substring(femalePersonalVestSize.length() - 1));
- int vValue = 0;
- vValue = Integer.valueOf(v.substring(v.length() - 1));
- String valueOfCell = "";
- femalePersonalVestSize = "";
- try {
- workb = Workbook.getWorkbook(new File("NFM SFST.sfst"));
- sheet = workb.getSheet("TTV14-FEMALE");
- for (column = 4; column < 47; column += 4) {
- cell = sheet.getCell(column, row);
- valueOfCell = cell.getContents();
- valueOfCell = valueOfCell.replace(" ", "");
- if (femalePersonalVestSizePart1.equals(valueOfCell)) {
- column_tmp = column;
- break;
- }
- }
- column = column_tmp;
- row += 2;
- row = row + ((femalePersonalVestSizePart2 - 1) * 8);
- row += vValue;
- if (bustSize.equals("A")) {
- cell = sheet.getCell(column, row);
- femaleNumericalValue = cell.getContents();
- }
- if (bustSize.equals("B")) {
- column++;
- cell = sheet.getCell(column, row);
- femaleNumericalValue = cell.getContents();
- }
- if (bustSize.equals("C")) {
- column += 2;
- cell = sheet.getCell(column, row);
- femaleNumericalValue = cell.getContents();
- }
- } catch (Exception e) {
- e.printStackTrace();
- }
- femaleNumericalValue = femaleNumericalValue.replace(" ", "");
- return femaleNumericalValue;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement