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

Post a Comment

Popular posts from this blog

Testing Webservice with SoapUI Having Windows Authentication

Sometims SoapUI doesn't seem to work directly with NTLM authentication, but you can use a proxy such as Burp Suite to do the auth for you. Following are the steps you can perform: Burp Suite Configuration     Download Burp Suite from http://portswigger.net/burp/ and set it up.     On Burp's "Proxy : Intercept" tab, click the button to turn intercept off.     On Burp's "Proxy : Options" tab, make sure it's set to an unused port, the default is 8081     On Burp's "Options" tab, tick "do www authentication" and add a setting for the server you wish to hit. Also tick "prompt for credentials on authentication failure"     Switch to Burp's "Proxy : History" tab so you can see requests going through. SoapUI Settings     In SoapUI, choose File > Preferences, then select "Proxy Settings". Enter Host "localhost" and port "8081".     Use SoapUI as normal. It will s
Read more

How to Re-run Failed Scenarios in Cucumber

Usually we require to rerun the failed test cases again once they are fixed or for double verification.In cucumber we can do that easily without developing any customize code for it. Cucumber directly supports the feature to re- run the failed test cases as following: Run Cucumber with rerun formatter simply using :   cucumber -f rerun --out rerun.txt It will output locations of all failed scenarios to the file. Then you can rerun them by using cucumber @rerun.txt This can be further bundled as a rake task and can be run simply as : require 'cucumber' require 'cucumber/rake/task' Cucumber::Rake::Task.new(: jenkins_with_rerun ) do |t|   cucumber -f rerun --out rerun.txt   cucumber @rerun.txt end task :default => : jenkins_with_rerun  And then can be run as simply "rake" inside the project folder:   C:/>ProjectFolder>rake
Read more