Video 20 datadriven framework geting issue | Selenium Forum
M
Posted on 30/01/2017
Hi,
Following video20->aug 2014 trying to implement for my project but geting below issue
Note:
[1) .xlsx file not supported in our org so changed .xlsx files to .xls

...............................................................................................................
org.apache.poi.openxml4j.exceptions.InvalidOperationException: Can't open the specified file: 'C:\Users\ruma\AppData\Local\Temp\poifiles\poi-ooxml-67883344.tmp'
at org.apache.poi.openxml4j.opc.ZipPackage.<init>(ZipPackage.java:102)
at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:199)
at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:178)
at org.apache.poi.util.PackageHelper.open(PackageHelper.java:53)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:176)
at com.qtpselenium.framework.datadriven.util.Xls_Reader.<init>(Xls_Reader.java:41)
at com.qtpselenium.framework.datadriven.util.TestDataProvider.getDataSuiteA(TestDataProvider.java:15)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.testng.internal.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:85)
at org.testng.internal.MethodInvocationHelper.invokeDataProvider(MethodInvocationHelper.java:136)
at org.testng.internal.Parameters.handleParameters(Parameters.java:430)
at org.testng.internal.Invoker.handleParameters(Invoker.java:1276)
at org.testng.internal.Invoker.createParameters(Invoker.java:992)
at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:1082)
at org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:124)
at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:108)
at org.testng.TestRunner.privateRun(TestRunner.java:773)
at org.testng.TestRunner.run(TestRunner.java:623)
at org.testng.SuiteRunner.runTest(SuiteRunner.java:357)
at org.testng.SuiteRunner.runSequentially(SuiteRunner.java:352)
at org.testng.SuiteRunner.privateRun(SuiteRunner.java:310)
at org.testng.SuiteRunner.run(SuiteRunner.java:259)
at org.testng.SuiteRunnerWorker.runSuite(SuiteRunnerWorker.java:52)
at org.testng.SuiteRunnerWorker.run(SuiteRunnerWorker.java:86)
at org.testng.TestNG.runSuitesSequentially(TestNG.java:1185)
at org.testng.TestNG.runSuitesSequentially(TestNG.java:1181)
at org.testng.TestNG.runSuitesLocally(TestNG.java:1110)
at org.testng.TestNG.run(TestNG.java:1018)
at org.testng.remote.AbstractRemoteTestNG.run(AbstractRemoteTestNG.java:126)
at org.testng.remote.RemoteTestNG.initAndRun(RemoteTestNG.java:137)
at org.testng.remote.RemoteTestNG.main(RemoteTestNG.java:58)

Finishing suite BusinessLoanSuite
{LoginTest Iteration 1=java.lang.NullPointerException, test2 Iteration 1=java.lang.NullPointerException}
[LoginTest Iteration 1, test2 Iteration 1]
....................................................................................................................

2)
testdataprovider.java file



public class TestDataProvider {

@DataProvider(name="BusinessLoanSuiteDataProvider")
public static Object[][] getDataSuiteA(Method m){
TestBase.init();
System.out.println(TestBase.prop.getProperty("xlsFileLocation"));
Xls_Reader xls1 = new Xls_Reader(TestBase.prop.getProperty("xlsFileLocation")+Constants.BusinessLoan_SUITE+".xls");

return Utility.getData(m.getName(), xls1);
}

@DataProvider(name="suiteBDataProvider")
public static Object[][] getDataSuiteB(Method m){
TestBase.init();
Xls_Reader xls1 = new Xls_Reader(TestBase.prop.getProperty("xlsFileLocation")+Constants.SECOND_SUITE+".xls");

return Utility.getData(m.getName(), xls1);
}


}


..................................................................................................................


note: xls_reader.java file attached here


please suggest

Regards
Ruma

M
Replied on 30/01/2017

xls_reader.java only works with xlsx files.

try this file but i can't promise you anything


M
Replied on 30/01/2017

Thanks a lot