public void createXLSReport() { String colName = Constants.RESULT + (CurrentTestDataSetID - 1); boolean isColExist = false; for (int c = 0; c < CurrentTestSuiteXls.getColumnCount(Constants.TEST_STEPS_SHEET); c++) { System.out.println(CurrentTestSuiteXls.getCellData(Constants.TEST_STEPS_SHEET, c, 2)); if (CurrentTestSuiteXls.getCellData(Constants.TEST_STEPS_SHEET, c, 1).equals(colName)) { isColExist = true; break; } } if (!isColExist) CurrentTestSuiteXls.addColumn(Constants.TEST_STEPS_SHEET, colName); int index = 0; for (int i = 2; i <= CurrentTestSuiteXls.getRowCount(Constants.TEST_STEPS_SHEET); i++) { if (CurrnetTestCaseName.equals( CurrentTestSuiteXls.getCellData(Constants.TEST_STEPS_SHEET, Constants.TEST_CASE_ID, i))) { if (ResultSet.size() == 0) CurrentTestSuiteXls.setCellData( Constants.TEST_STEPS_SHEET, colName, i, Constants.KEYWORD_SKIP); else CurrentTestSuiteXls.setCellData( Constants.TEST_STEPS_SHEET, colName, i, ResultSet.get(index)); index++; } } if (ResultSet.size() == 0) { // skip CurrentTestSuiteXls.setCellData( CurrnetTestCaseName, Constants.RESULT, CurrentTestDataSetID, Constants.KEYWORD_SKIP); return; } else { for (int i = 0; i < ResultSet.size(); i++) { if (!ResultSet.get(i).equals(Constants.KEYWORD_PASS)) { CurrentTestSuiteXls.setCellData( CurrnetTestCaseName, Constants.RESULT, CurrentTestDataSetID, ResultSet.get(i)); return; } } } CurrentTestSuiteXls.setCellData( CurrnetTestCaseName, Constants.RESULT, CurrentTestDataSetID, Constants.KEYWORD_PASS); // if(!currentTestSuiteXLS.getCellData(currentTestCaseName, // "Runmode",currentTestDataSetID).equals("Y")){} }