How to read multiple sheet in continution from one workbook using java?
<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>