title: How to read multiple sheet in continution from one workbook using java?
body: <p>I have an multiple sheets in one workbook, it read each and every rows too.</p>
  
  <p>But each time it start reading the sheet from first row and because of that when it start to set/writing the status of cases, it again start to set the result from first row means it overlap the result of each cases on same row.</p>
  
  <p>Also, for reading and writing sheet I am using Jxl api.</p>
  
  <p><strong>Below are the code for logic can anyone please let me know how to resolved it:</strong></p>
  
  <pre><code>    private void handleScenario(String scenarioName) throws Exception {
          ExcelHandler testScenarios = new ExcelHandler(TEST_SUITE_PATH);
          testScenarios.setSheetName(scenarioName);
          testScenarios.columnData();    
  
          int rowWorkBook1 = testScenarios.rowCount();
          System.out.println("Total Rows1: "+ rowWorkBook1);
  
          for (int j = 1; j &lt; rowWorkBook1; j++) {
              String sno = testScenarios.readCell(testScenarios.getCell("Sno"), j); // SendKey
              String testCaseDescription = testScenarios.readCell(testScenarios.getCell("TestCaseDescription"), j);
              String framWork = testScenarios.readCell(testScenarios.getCell("FrameworkName"), j);
              String operation = testScenarios.readCell(testScenarios.getCell("Operation"), j); // SendKey
              String value = testScenarios.readCell(testScenarios.getCell("Value"), j);
  
              handleObjects(operation, value, framWork);
              boolean bTestCaseStepStatus = handleObjects(operation,value, framWork);
  
              generateReport(bTestCaseStepStatus, scenarioName, sno,testCaseDescription, j);
          }
      }
  
  private boolean generateReport(boolean bTestCaseStepStatus,
              String testSuiteName, String SNO, String testCaseDescription, int j)
              throws RowsExceededException, WriteException, IOException {
  
          WritableData writableData = new WritableData(TEST_RESULT, testSuiteName, j, 2);
  
          // If sheet name is already exist then .... write data at row = row +1
          // else write directly .. means row = 1
  
          if (bTestCaseStepStatus) {
              //System.out.println("--------------"+bTestCaseStepStatus+"------------");
              System.out.println("SNo=" +SNO+ ",Test description=" + testCaseDescription + "Row ID: " + j);
  
              writableData.shSheet("Result", 2, j, "Pass");
              driver.manage().timeouts().implicitlyWait(5, TimeUnit.SECONDS);
          } else {
          //  System.out.println("--------------"+bTestCaseStepStatus+"------------");    
              System.out.println("SNo=" +SNO+ ",Test description=" + testCaseDescription + "Row ID: "+ j);            
  
              writableData.shSheet("Result", 2, j, "Fail");
              driver.manage().timeouts().implicitlyWait(5, TimeUnit.SECONDS);
          }
  
          return bTestCaseStepStatus;
  
          // Finally .... close Report file ... 
      }
  
      private boolean handleObjects(String operation, String value,
              String framWork) throws Exception {
          // Return true / False
          ExcelHandler objectRepository = new ExcelHandler(OBJECT_REPOSITORY_PATH, "OR");
          objectRepository.columnData();
          int rowCount = objectRepository.rowCount();
          //System.out.println("Total Rows in hadleObject=" + rowCount);
          boolean testStepStatus = false;
  
          for (int k = 1; k &lt; rowCount; k++) {
              String frameWorkName = objectRepository.readCell(
                      objectRepository.getCell("FrameworkName"), k);
              String ObjectName = objectRepository.readCell(
                      objectRepository.getCell("ObjectName"), k);
              String Locator = objectRepository.readCell(
                      objectRepository.getCell("Locator"), k); // SendKey
  
              //System.out.println("FrameWorkNameV=" + frameWorkName
              //      + ",ObjectName=" + ObjectName + ",Locator=" + Locator);
  
              if (framWork.equalsIgnoreCase(frameWorkName)) {
                  testStepStatus = operateWebDriver(operation, Locator, value,
                          ObjectName);
  
              }
          }
  
          return testStepStatus;
      }
  </code></pre>