public static void dataFromExcel(String path, String arkusz) {
        int column = 2;
        int row = 2;
        int index = 0;

        Cell cell = null;
        Workbook workb = null;
        Sheet sheet = null;
        String value = "";
        int rowsInXls = 0;
        int columnsInXls = 0;
        Cell[] rowFromXlsCell = null;

        String id = "";
        String pid = "";
        int measure_no = 0;
        String first_name = "";
        String last_name = "";
        String user_group = "";
        String location = "";
        String gender = "";
        String added_date = "";
        String added_who = "";
        double chest_W = 0.0;
        double chest_H = 0.0;
        double waist = 0.0;
        double height = 0.0;
        double breast_Height = 0.0;
        String cup_Size = "";
        String v = "";
        String personal_Vest = "";
        String tactical_Vest = "";
        String reinforcement_Insert = "";
        String numerical = "";
        String project = "";
        String remark = "";
        String test = "";
        Date date = new Date();
        SimpleDateFormat formatDate;
        formatDate = new SimpleDateFormat("YYYY-MM-dd kk:mm");
        ArrayList<String> idList = new ArrayList<String>();
        Connection conn = null;
        Statement stat = null;
        ResultSet rs = null;
        String id_tmp = "";
        PreparedStatement preparedStmt = null;
        functions fun = new functions();
        try {
            Class.forName("com.mysql.jdbc.Driver").newInstance();
            conn = DriverManager.getConnection("jdbc:mysql://sql.tworzymynet.nazwa.pl:3307/tworzymynet_83?characterEncoding=utf8", "tworzymynet_83", "!QAZ2wsx#EDC");
            stat = conn.createStatement();
            System.out.println("polaczono z glowna");
            rs = stat.executeQuery("SELECT * FROM personrecord");
            while (rs.next()) {
                id_tmp = rs.getString("id");
                idList.add(id_tmp);
            }
        } catch (Exception e) {
            e.printStackTrace();
        }

        try {
            workb = Workbook.getWorkbook(new File(path));
            sheet = workb.getSheet(arkusz);
            rowsInXls = sheet.getRows();
            columnsInXls = sheet.getColumns();
            System.out.println("rows: " + rowsInXls);
            System.out.println("columns: " + columnsInXls);
            String[] rowFromXls = new String[columnsInXls];
            for (row = 2; row < rowsInXls; row++) {
                for (column = 2; column < columnsInXls; column++) {
                    cell = sheet.getCell(column, row);

                    rowFromXls[index] = cell.getContents();

                    index++;
                }

                test = rowFromXls[0];
                if (!test.equals("")) {
                    id = rowFromXls[0].replace(" ", "") + "_" + Integer.parseInt(rowFromXls[1].replace(" ", ""));
                    pid = rowFromXls[0].replace(" ", "");
                    measure_no = Integer.parseInt(rowFromXls[1].replace(" ", ""));
                    first_name = rowFromXls[2].replace(" ", "");
                    last_name = rowFromXls[3].replace(" ", "");
                    user_group = rowFromXls[4].replace(" ", "");
                    location = rowFromXls[5].replace(" ", "");
                    gender = rowFromXls[6].replace(" ", "").toLowerCase();
                    added_date = formatDate.format(date);
                    added_who = "Admin";
                    chest_W = Double.valueOf(rowFromXls[7].replace(" ", ""));
                    chest_H = Double.valueOf(rowFromXls[8].replace(" ", ""));
                    waist = Double.valueOf(rowFromXls[9].replace(" ", ""));
                    height = Double.valueOf(rowFromXls[10].replace(" ", ""));
                    breast_Height = Double.valueOf(rowFromXls[11].replace(" ", ""));
                    cup_Size = rowFromXls[12].replace(" ", "").toUpperCase();
                    v = rowFromXls[13].replace(" ", "");
                    personal_Vest = rowFromXls[14].replace(" ", "");
                    tactical_Vest = rowFromXls[15].replace(" ", "");
                    reinforcement_Insert = rowFromXls[16].replace(" ", "");
                    if (gender.equals("male")) {
                        numerical = fun.maleNumerical(personal_Vest, v);
                    } else if (gender.equals("female")) {
                        numerical = fun.femaleNumerical(personal_Vest, v, cup_Size);
                    }

                    project = rowFromXls[17].replace(" ", "");
                    remark = rowFromXls[18].replace(" ", "");
                    System.out.println("id: " + id);
                    System.out.println("pid: " + pid);
                    System.out.println("measure_no: " + measure_no);
                    System.out.println("first_name: " + first_name);
                    System.out.println("last_name: " + last_name);
                    System.out.println("user_group: " + user_group);
                    System.out.println("location: " + location);
                    System.out.println("gender: " + gender);
                    System.out.println("added_date: " + added_date);
                    System.out.println("added_who: " + added_who);
                    System.out.println("chest_W: " + chest_W);
                    System.out.println("chest_H: " + chest_H);
                    System.out.println("waist: " + waist);
                    System.out.println("height: " + height);
                    System.out.println("breast_Height: " + breast_Height);
                    System.out.println("cup_Size " + cup_Size);
                    System.out.println("v: " + v);
                    System.out.println("personal_Vest: " + personal_Vest);
                    System.out.println("tactical_Vest: " + tactical_Vest);
                    System.out.println("reinforcement_Insert: " + reinforcement_Insert);
                    System.out.println("numerical: " + numerical);
                    System.out.println("project: " + project);
                    System.out.println("remark: " + remark);
                    if (!idList.contains(id)) {
                        String query = " insert into personrecord (id, pid, measure_no, first_name, last_name, user_group, location, gender, added_date,added_who, chest_W,"
                                + " chest_H, waist, height, breast_Height, cup_Size, v, personal_Vest,tactical_Vest, reinforcement_Insert, numerical, project, remark)"
                                + " values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ,?, ?, ?, ?, ?)";
                        preparedStmt = conn.prepareStatement(query);
                        preparedStmt.setString(1, id);
                        preparedStmt.setString(2, pid);
                        preparedStmt.setInt(3, measure_no);
                        preparedStmt.setString(4, first_name);
                        preparedStmt.setString(5, last_name);
                        preparedStmt.setString(6, user_group);
                        preparedStmt.setString(7, location);
                        preparedStmt.setString(8, gender);
                        preparedStmt.setString(9, added_date);
                        preparedStmt.setString(10, added_who);
                        preparedStmt.setDouble(11, chest_W);
                        preparedStmt.setDouble(12, chest_H);
                        preparedStmt.setDouble(13, waist);
                        preparedStmt.setDouble(14, height);
                        preparedStmt.setDouble(15, breast_Height);
                        preparedStmt.setString(16, cup_Size);
                        preparedStmt.setString(17, v);
                        preparedStmt.setString(18, personal_Vest);
                        preparedStmt.setString(19, tactical_Vest);
                        preparedStmt.setString(20, reinforcement_Insert);
                        preparedStmt.setString(21, numerical);
                        preparedStmt.setString(22, project);
                        preparedStmt.setString(23, remark);
                        preparedStmt.execute();
                        preparedStmt.clearParameters();
                        preparedStmt.clearBatch();

                    } else {
                        System.out.println("pid sie powtarza");
                    }
                } else {

                    break;
                }

                System.out.println("");
                index = 0;
            }

//            rowFromXlsCell = sheet.getRow(index);
//            rowFromXls = rowFromXlsCell.toString();
            preparedStmt.close();
            conn.close();
            stat.close();
            rs.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }