Unable to Open EXcel File | Selenium Forum
M
Posted on 23/10/2016
Hi Team,

I am practicing Module 20, in that i am trying to update Result Column for a dataset in a Testcase by writing below code.

package test;

import com.qtpselenium.util.Xls_Reader;

public class UpdateResult_DataSet {

public static void main(String[] args) {

Xls_Reader x = new Xls_Reader(System.getProperty("user.dir")+"\\src\\com\\qtpselenium\\xls\\B suite.xlsx");
reportDataSetResult(x,"TestCase_B1",3,"Pass");
reportDataSetResult(x,"TestCase_B1",4,"Fail");

}

// update results for a particular data set
public static void reportDataSetResult(Xls_Reader xls, String testCaseName, int rowNum,String result){
xls.setCellData(testCaseName, "Results", rowNum, result);
}
}


But iam getting error.
Please do needful.

Thank You.

Regards,
Suhasini.

M
Replied on 24/10/2016

poi api jar files have been corrupted i think.

download poi api again.