Selenium : Read Excel file using JExcel API



Code to read  value from Excel file using selenium WebDriver & Java is as follows -


inputWorkbook = new File("C:\\Controller.xls"); //specify excel file path

    Workbook w;
               
    try {
               
            try {

                        w = Workbook.getWorkbook(inputWorkbook);

                        sheet = w.getSheet("Sheet1"); //Worksheet name

                        } catch (IOException e) {
                                                                       
                                    error("Reading Master Sheet :-" +e);
                        }
                 
                        suite = new String[sheet.getRows()][sheet.getColumns()];
              
                        for (int j = 0; j < sheet.getColumns(); j++){
                                   
                                    for (int i = 0; i < sheet.getRows(); i++){
                     
                                                Cell cell = sheet.getCell(j, i);
                     
                                                if (cell.getContents()!= null){
                         
                                                            suite[i][j]=cell.getContents();
                                                }
                   
                                    }
                 
                        }
              
Note – Suite[][] is two dimensional array which stores value read from Excel Worksheet.

Comments

Popular posts from this blog

Testing Webservice with SoapUI Having Windows Authentication

How to Re-run Failed Scenarios in Cucumber

Data Driven Testing Using Selenium -WebDriver in Python