Esempio n. 1
0
  // return the test data from a test in a 2 dim array
  public static Object[][] getData(Xls_Reader xls, String testCaseName) {
    // if sheet is present or not
    if (!xls.isSheetExist(testCaseName)) {
      xls = null;
      return new Object[1][0];
    }

    int rows = xls.getRowCount(testCaseName);
    int cols = xls.getColumnCount(testCaseName);
    // System.out.println(rows  +"**"+cols);

    Object[][] data = new Object[rows - 1][cols];
    for (int rowNum = 2; rowNum <= rows; rowNum++) {
      for (int colNum = 0; colNum < cols; colNum++) {
        // System.out.print(xls.getCellData(testCaseName,colNum , rowNum));
        data[rowNum - 2][colNum] = xls.getCellData(testCaseName, colNum, rowNum);
      }
      System.out.println();
    }

    return data;
  }
Esempio n. 2
0
 // Update the result for a perticular dataSet
 public static void reportDataSetResult(
     Xls_Reader xls, String testCaseName, int rowNum, String result) {
   xls.setCellData(testCaseName, "Results", rowNum, result);
 }