xlsx.java

  public static void getUserName(String xlsLocation) throws IOException {
        FileInputStream file = new FileInputStream( new File(xlsLocation));
        Workbook workbook = new XSSFWorkbook(file);
        Sheet sheet = workbook.getSheetAt(0);
        for(Row row: sheet)
        {
            Cell tenCell = row.getCell(0);
            tenCell.setCellType(CellType.STRING);
            Cell sixCell  = row.getCell(1);
            sixCell.setCellType(CellType.STRING);
            try {
                String email = getEmail(Integer.parseInt(sixCell.getStringCellValue()));
                Cell emailCell = row.createCell(2);
                if (email != null) {
                    emailCell.setCellValue(email);
                }
            }
            catch (Exception e){
                e.printStackTrace();
            }
        }
        workbook.write(new FileOutputStream("/tmp/2.xlsx"));

    }