tag:blogger.com,1999:blog-9028922528361045176.post1767060577577493054..comments2024-03-27T10:13:03.251+05:30Comments on Road To Automation: Road to data driven testing in webdriver java TestNg Part 1Unknownnoreply@blogger.comBlogger31125tag:blogger.com,1999:blog-9028922528361045176.post-87808226906129714942015-03-11T23:20:16.268+05:302015-03-11T23:20:16.268+05:30and the same file,
package com.bobcares.webdrive...<br /><br />and the same file, <br /><br />package com.bobcares.webdriver.branding;<br /> <br />import java.io.File;<br />import java.io.FileInputStream;<br />import java.util.ArrayList;<br />import java.util.List;<br />import org.apache.poi.xssf.usermodel.XSSFCell;<br />import org.apache.poi.xssf.usermodel.XSSFRow;<br />import org.apache.poi.xssf.usermodel.XSSFSheet;<br />import org.apache.poi.xssf.usermodel.XSSFWorkbook;<br /> <br />public class ReadXLS {<br /> <br /> public List getData() {<br /> <br /> String path = "/tmp/DataSheet.xlsx";<br /> List dataList = new ArrayList();<br /> FileInputStream fis = null;<br /> try {<br /> fis = new FileInputStream(new File(path));<br /> XSSFWorkbook workbook = new XSSFWorkbook(fis);<br /> XSSFSheet sheet = workbook.getSheet("TestData");<br /> java.util.Iterator rows = sheet.rowIterator();<br /> <br /> while (rows.hasNext()) {<br /> XSSFRow row = ((XSSFRow) rows.next());<br /> // int r=row.getRowNum();<br /> java.util.Iterator cells = row .cellIterator();<br /> int i = 1;<br /> String[] testData= new String[3];<br /> while (cells.hasNext()) {<br /> <br /> XSSFCell cell = (XSSFCell) cells.next();<br /> String value = cell.getStringCellValue();<br /> if (!value.equals(null)) {<br /> testData [i] = value;<br /> i++;<br /> }<br /> }<br /> dataList.add(testData);<br /> }<br /> }<br /> catch (Exception e) {<br /> e.printStackTrace();<br /> }<br /> return dataList;<br /> }<br /> <br />}<br /><br /><br />and from main I call <br /> @Test()<br /> public void testSearchCountry() throws Exception {<br /> InvalidLogin.testSearchCountry();<br /> }<br /> <br /><br />Please help,<br /><br />Thanks!<br />Anonymoushttps://www.blogger.com/profile/06536868781567001571noreply@blogger.comtag:blogger.com,1999:blog-9028922528361045176.post-81970154317570833792015-03-11T23:20:09.115+05:302015-03-11T23:20:09.115+05:30Hello,
I used the same script. but getting error ...Hello,<br /><br />I used the same script. but getting error <br /><br /><br />log4j:WARN No appenders could be found for logger (org.openqa.selenium.server.SeleniumServer).<br />log4j:WARN Please initialize the log4j system properly.<br />log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.<br />23:16:05.175 INFO - Default driver org.openqa.selenium.ie.InternetExplorerDriver registration is skipped: registration capabilities Capabilities [{platform=WINDOWS, ensureCleanSession=true, browserName=internet explorer, version=}] does not match with current platform: LINUX<br />FAILED: testSearchCountry<br />java.lang.NullPointerException<br /> at com.bobcares.webdriver.branding.LoginAttemps.testSearchCountry(LoginAttemps.java:23)<br /> at com.bobcares.webdriver.branding.Main.testSearchCountry(Main.java:38)<br /> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br /> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)<br /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br /> at java.lang.reflect.Method.invoke(Method.java:606)<br /> at org.testng.internal.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:84)<br /> at org.testng.internal.Invoker.invokeMethod(Invoker.java:714)<br /> at org.testng.internal.Invoker.invokeTestMethod(Invoker.java:901)<br /> at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:1231)<br /> at org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:127)<br /> at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:111)<br /> at org.testng.TestRunner.privateRun(TestRunner.java:767)<br /> at org.testng.TestRunner.run(TestRunner.java:617)<br /> at org.testng.SuiteRunner.runTest(SuiteRunner.java:334)<br /> at org.testng.SuiteRunner.runSequentially(SuiteRunner.java:329)<br /> at org.testng.SuiteRunner.privateRun(SuiteRunner.java:291)<br /> at org.testng.SuiteRunner.run(SuiteRunner.java:240)<br /> at org.testng.SuiteRunnerWorker.runSuite(SuiteRunnerWorker.java:52)<br /> at org.testng.SuiteRunnerWorker.run(SuiteRunnerWorker.java:86)<br /> at org.testng.TestNG.runSuitesSequentially(TestNG.java:1224)<br /> at org.testng.TestNG.runSuitesLocally(TestNG.java:1149)<br /> at org.testng.TestNG.run(TestNG.java:1057)<br /> at org.testng.remote.RemoteTestNG.run(RemoteTestNG.java:111)<br /> at org.testng.remote.RemoteTestNG.initAndRun(RemoteTestNG.java:204)<br /> at org.testng.remote.RemoteTestNG.main(RemoteTestNG.java:175)<br /><br /><br />===============================================<br /> Default test<br /> Tests run: 1, Failures: 1, Skips: 0<br /><br /><br /><br />In the excel file, I have pasted the following,<br />Country Description<br />India This article is about the Republic of India<br />Brazil Brazil bounded by the Atlantic Ocean on the east<br />Canada Canada is a North American country <br />England England is a country that is part of the United Kingdom<br /><br /><br /><br />I have a separate file for <br /><br />public class LoginAttemps extends Setup {<br /> private String baseUrl;<br /> public void testSearchCountry() throws Exception {<br /> driver.get(baseUrl + "/wiki/Main_Page");<br /> ReadXLS readXls = new ReadXLS();<br /> List dataList = readXls.getData();<br /> for (int i = 1; i < dataList.size(); i++) {<br /> String[] testCase = new String[5];<br /> String[] test = (String[]) dataList.get(i);<br /> String countryName = test[0];<br /> String countryDesc = test[1];<br /> driver.findElement(By.id("searchInput")).clear();<br /> driver.findElement(By.id("searchInput")).sendKeys(countryName);<br /> driver.findElement(By.id("searchButton")).click();<br /> String str = driver.findElement(<br /> By.xpath("//h1[@id='firstHeading']/span")).getText();<br /> System.out.println(countryDesc);<br /> Assert.assertTrue(str.contains(countryName));<br /> }<br /> }<br /> <br />}<br />Anonymoushttps://www.blogger.com/profile/06536868781567001571noreply@blogger.comtag:blogger.com,1999:blog-9028922528361045176.post-32743231917070694742014-11-19T15:03:05.251+05:302014-11-19T15:03:05.251+05:30showing an error...
java.lang.RuntimeException: ...showing an error...<br /><br /><br />java.lang.RuntimeException: java.lang.NoClassDefFoundError: org/apache/xmlbeans/XmlException<br /> at org.testng.internal.MethodInvocationHelper.invokeDataProvider(MethodInvocationHelper.java:161)<br /> at org.testng.internal.Parameters.handleParameters(Parameters.java:429)<br /> at org.testng.internal.Invoker.handleParameters(Invoker.java:1383)<br /> at org.testng.internal.Invoker.createParameters(Invoker.java:1075)<br /> at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:1180)<br /> at org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:127)<br /> at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:111)<br /> at org.testng.TestRunner.privateRun(TestRunner.java:767)<br /> at org.testng.TestRunner.run(TestRunner.java:617)<br /> at org.testng.SuiteRunner.runTest(SuiteRunner.java:334)<br /> at org.testng.SuiteRunner.runSequentially(SuiteRunner.java:329)<br /> at org.testng.SuiteRunner.privateRun(SuiteRunner.java:291)<br /> at org.testng.SuiteRunner.run(SuiteRunner.java:240)<br /> at org.testng.SuiteRunnerWorker.runSuite(SuiteRunnerWorker.java:52)<br /> at org.testng.SuiteRunnerWorker.run(SuiteRunnerWorker.java:86)<br /> at org.testng.TestNG.runSuitesSequentially(TestNG.java:1224)<br /> at org.testng.TestNG.runSuitesLocally(TestNG.java:1149)<br /> at org.testng.TestNG.run(TestNG.java:1057)<br /> at org.testng.remote.RemoteTestNG.run(RemoteTestNG.java:111)<br /> at org.testng.remote.RemoteTestNG.initAndRun(RemoteTestNG.java:204)<br /> at org.testng.remote.RemoteTestNG.main(RemoteTestNG.java:175)<br />Caused by: java.lang.NoClassDefFoundError: org/apache/xmlbeans/XmlException<br /> at datadrivenfromexel.getData(datadrivenfromexel.java:23)<br /> at datadrivenfromexel2.createData1(datadrivenfromexel2.java:22)<br /> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br /> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)<br /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)<br /> at java.lang.reflect.Method.invoke(Unknown Source)<br /> at org.testng.internal.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:84)<br /> at org.testng.internal.MethodInvocationHelper.invokeDataProvider(MethodInvocationHelper.java:135)<br /> ... 20 more<br />Caused by: java.lang.ClassNotFoundException: org.apache.xmlbeans.XmlException<br /> at java.net.URLClassLoader$1.run(Unknown Source)<br /> at java.net.URLClassLoader$1.run(Unknown Source)<br /> at java.security.AccessController.doPrivileged(Native Method)<br /> at java.net.URLClassLoader.findClass(Unknown Source)<br /> at java.lang.ClassLoader.loadClass(Unknown Source)<br /> at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)<br /> at java.lang.ClassLoader.loadClass(Unknown Source)<br /> ... 28 more<br /><br />Anonymoushttps://www.blogger.com/profile/02665575311295866690noreply@blogger.comtag:blogger.com,1999:blog-9028922528361045176.post-12179436312514245932014-06-25T07:24:23.277+05:302014-06-25T07:24:23.277+05:30*Previous comment deleted due to typo's
Hi,
I...*Previous comment deleted due to typo's<br /><br />Hi,<br />I have tried to implement this code as detailed above. I am fairly new to Webdriver, so I have had not changed anything other then the spreadsheet name and workbook name.<br /><br />When I run the script it fails to run. When I debug it falls over at the line:<br />XSSFWorkbook workbook = new XSSFWorkbook(fis);<br /><br />Before executing this line, the 'fis' variable has the following value:<br />fis = FileInputStream (id=58)<br /><br />When I step into the line XSSFWorkbook workbook = new XSSFWorkbook(fis); in debug mode I get the following error<br />"Source not found." and in the Variables window it has the following values:<br />Name - Value<br />this - ClassNotFoundException (id=73)<br />arg0 - org.apache.poi.xssf.usermodel.XSSFWorkbook<br />arg1 - null<br /><br />I can't work out what might be causing the script to fail. Has anyone got any suggestions?<br /><br />Thanks<br /><br />SimonSimonMhttps://www.blogger.com/profile/09618057612848546667noreply@blogger.comtag:blogger.com,1999:blog-9028922528361045176.post-82026133006679945182014-06-25T07:21:58.569+05:302014-06-25T07:21:58.569+05:30This comment has been removed by the author.SimonMhttps://www.blogger.com/profile/09618057612848546667noreply@blogger.comtag:blogger.com,1999:blog-9028922528361045176.post-72896354519930670782014-06-04T20:53:11.873+05:302014-06-04T20:53:11.873+05:30Hi Every one,
I am getting below error after runn...Hi Every one,<br /><br />I am getting below error after running above programs, please help me to resolve this:<br /><br />java.lang.ArrayIndexOutOfBoundsException: 3<br /> at test.ReadXLS.getData(ReadXLS.java:34)<br /> at test.SearchCountry.testSearchCountry(SearchCountry.java:33)<br /> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br /> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<br /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<br /> at java.lang.reflect.Method.invoke(Method.java:597)<br /> at org.testng.internal.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:84)<br /> at org.testng.internal.Invoker.invokeMethod(Invoker.java:714)<br /> at org.testng.internal.Invoker.invokeTestMethod(Invoker.java:901)<br /> at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:1231)<br /> at org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:127)<br /> at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:111)<br /> at org.testng.TestRunner.privateRun(TestRunner.java:767)<br /> at org.testng.TestRunner.run(TestRunner.java:617)<br /> at org.testng.SuiteRunner.runTest(SuiteRunner.java:336)<br /> at org.testng.SuiteRunner.runSequentially(SuiteRunner.java:329)<br /> at org.testng.SuiteRunner.privateRun(SuiteRunner.java:291)<br /> at org.testng.SuiteRunner.run(SuiteRunner.java:240)<br /> at org.testng.SuiteRunnerWorker.runSuite(SuiteRunnerWorker.java:64)<br /> at org.testng.SuiteRunnerWorker.run(SuiteRunnerWorker.java:87)<br /> at org.testng.TestNG.runSuitesSequentially(TestNG.java:1225)<br /> at org.testng.TestNG.runSuitesLocally(TestNG.java:1149)<br /> at org.testng.TestNG.run(TestNG.java:1057)<br /> at org.testng.remote.RemoteTestNG.run(RemoteTestNG.java:111)<br /> at org.testng.remote.RemoteTestNG.initAndRun(RemoteTestNG.java:215)<br /> at org.testng.remote.RemoteTestNG.main(RemoteTestNG.java:175)Manju S Reddyhttps://www.blogger.com/profile/10427945873829256944noreply@blogger.comtag:blogger.com,1999:blog-9028922528361045176.post-22299102800383915472014-06-04T20:49:55.154+05:302014-06-04T20:49:55.154+05:30This comment has been removed by the author.Manju S Reddyhttps://www.blogger.com/profile/10427945873829256944noreply@blogger.comtag:blogger.com,1999:blog-9028922528361045176.post-65653800953629453032014-05-31T15:52:38.314+05:302014-05-31T15:52:38.314+05:30Hello Atul,
For execution you need to run TestNG n...Hello Atul,<br />For execution you need to run TestNG not main method.<br /><br />You can follow below URL for setup and execution:<br />http://roadtoautomation.blogspot.in/2013/02/start-with-java-webdriver-how-to-create.html<br />Adminhttps://www.blogger.com/profile/15096936763273601422noreply@blogger.comtag:blogger.com,1999:blog-9028922528361045176.post-52712537988885389212014-05-31T12:45:54.050+05:302014-05-31T12:45:54.050+05:30Hi
I am new to selenium and i cannot run the abo...Hi <br />I am new to selenium and i cannot run the above code as there is no main function , so can you provide proper steps for that.Anonymoushttps://www.blogger.com/profile/18047148997347751800noreply@blogger.comtag:blogger.com,1999:blog-9028922528361045176.post-47589389494946759682014-05-15T18:11:13.359+05:302014-05-15T18:11:13.359+05:30package com.tarnea;
import java.io.File;
import j...package com.tarnea;<br /><br />import java.io.File;<br />import java.io.FileInputStream;<br /><br />import jxl.Sheet;<br />import jxl.Workbook;<br /><br />import org.testng.annotations.Test;<br />import org.openqa.selenium.By;<br />import org.openqa.selenium.OutputType;<br />import org.openqa.selenium.TakesScreenshot;<br />import org.openqa.selenium.WebDriver;<br />import org.openqa.selenium.firefox.FirefoxDriver;<br />import org.testng.annotations.AfterTest;<br />import org.testng.annotations.BeforeTest;<br />import org.testng.annotations.Listeners;<br /><br />import atu.testng.reports.listeners.ATUReportsListener;<br />import atu.testng.reports.listeners.ConfigurationListener;<br />import atu.testng.reports.listeners.MethodListener;<br /><br /><br />//@Test @Listeners({ ATUReportsListener.class, ConfigurationListener.class,MethodListener.class })<br />public class Excel_Data<br />{<br /><br /> public WebDriver driver;<br /> Sheet s;<br /> int k=0;<br /> public String uname;<br /> public String pass;<br /> <br /> //This is for establishing the driver connection<br /> @BeforeTest(description=" : This is for establishing the driver connection")<br /> public void sales_Order1_setUp() throws Exception<br /> {<br /> driver = new FirefoxDriver();<br /> }<br /> <br /> @Test(priority=1)<br /> public void Login_Test() throws Exception<br /> {<br /> driver.get("http://103.19.88.39/");<br /> driver.manage().window().maximize();<br /> FileInputStream fi=new FileInputStream("D:/Automation/Life-Care/Data_sheet.xls");<br /> Workbook w=Workbook.getWorkbook(fi);<br /> Sheet sh = w.getSheet(0); <br /><br /> for(int rows=0;rows<sh.getRows();rows++)<br /> { <br /> for(int cols=0;cols<sh.getColumns();cols++)<br /> { <br /> driver.findElement(By.id("_58_login")).clear();<br /> driver.findElement(By.id("_58_login")).sendKeys(sh.getCell(cols, rows).getContents().trim());<br /> Thread.sleep(1000);<br /> <br /> driver.findElement(By.id("_58_password")).clear();<br /> driver.findElement(By.id("_58_password")).sendKeys(sh.getCell(++cols, rows).getContents().trim());<br /> Thread.sleep(1000);<br /> } <br /> driver.findElement(By.id("_58_rememberMeCheckbox")).click();<br /> driver.findElement(By.xpath("/html/body/div/div/div[2]/div/div/div/div/div/div/div/form/div/span/span/input")).click();<br /> Thread.sleep(2000);<br /> //This is for writing image or snapshots<br /> File scrFile = ((TakesScreenshot)driver).getScreenshotAs(OutputType.FILE);<br /> org.apache.commons.io.FileUtils.copyFile(scrFile, new File("D:/InvalidValidLogin"+ ++k+".png")); //Data_sheet.xls <br /> } <br /> <br /> }<br /> <br /> <br /> <br /> //This is for releasing the driver connection<br /> @AfterTest(description=" : This is for Releasing the driver")<br /> public void releaseDriver() throws Exception<br /> {<br /> driver.quit();<br /> }<br />}<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9028922528361045176.post-33637166852644942552014-05-11T18:53:46.034+05:302014-05-11T18:53:46.034+05:30Can you share you error message...Can you share you error message...Adminhttps://www.blogger.com/profile/15096936763273601422noreply@blogger.comtag:blogger.com,1999:blog-9028922528361045176.post-52854346517224244112014-05-07T13:01:46.248+05:302014-05-07T13:01:46.248+05:30 XSSFWorkbook workbook =new XSSFWorkbook(fa); sho... XSSFWorkbook workbook =new XSSFWorkbook(fa); shown remove argument error in this lineAnonymoushttps://www.blogger.com/profile/12415168476063739404noreply@blogger.comtag:blogger.com,1999:blog-9028922528361045176.post-43784916227692521552014-04-25T14:01:31.108+05:302014-04-25T14:01:31.108+05:30I am getting error as "Editor does not contai...I am getting error as "Editor does not contain a main type" Please helpAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-9028922528361045176.post-57457622289923743442014-04-09T08:44:14.127+05:302014-04-09T08:44:14.127+05:30when i changed my string path like C:\\data.xls
i...when i changed my string path like C:\\data.xls <br />iam getting below error <br /><br />ava.lang.NoClassDefFoundError: org/apache/xmlbeans/XmlObject<br /> at scripts.ReadXLS.getData(ReadXLS.java:22)<br /> at scripts.Sampletestdriven.test1(Sampletestdriven.java:42)<br /> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br /> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)<br /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)<br /> at java.lang.reflect.Method.invoke(Unknown Source)<br /> at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:45)<br /> at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)<br /> at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:42)<br /> at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)<br /> at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)<br /> at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:263)<br /> at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:68)<br /> at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:47)<br /> at org.junit.runners.ParentRunner$3.run(ParentRunner.java:231)<br /> at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:60)<br /> at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:229)<br /> at org.junit.runners.ParentRunner.access$000(ParentRunner.java:50)<br /> at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:222)<br /> at org.junit.runners.ParentRunner.run(ParentRunner.java:300)<br /> at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50)<br /> at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)<br /> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)<br /> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)<br /> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)<br /> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)<br />Caused by: java.lang.ClassNotFoundException: org.apache.xmlbeans.XmlObject<br /> at java.net.URLClassLoader$1.run(Unknown Source)<br /> at java.net.URLClassLoader$1.run(Unknown Source)<br /> at java.security.AccessController.doPrivileged(Native Method)<br /> at java.net.URLClassLoader.findClass(Unknown Source)<br /> at java.lang.ClassLoader.loadClass(Unknown Source)<br /> at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)<br /> at java.lang.ClassLoader.loadClass(Unknown Source)<br /> ... 26 more<br /><br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9028922528361045176.post-8636476831913570632014-03-13T17:24:28.606+05:302014-03-13T17:24:28.606+05:30Hi i am facing error "Source not found",...Hi i am facing error "Source not found", when i debug my script.<br />Please reply ASAP thanks in advanceMukul Goelhttps://www.blogger.com/profile/04974860952867435091noreply@blogger.comtag:blogger.com,1999:blog-9028922528361045176.post-8505941119890882472014-02-01T12:59:45.619+05:302014-02-01T12:59:45.619+05:30Use above function with some additional modificati...Use above function with some additional modification, while reading data from xls sheet store row number of corresponding data in array list.<br /><br />create a function for writing xls file using row number.<br /><br />you should have use exception handling in your code with throws, If your code executed for set of data just update pass in xls file and in failed condition using catch block you update failed status for that row. Adminhttps://www.blogger.com/profile/15096936763273601422noreply@blogger.comtag:blogger.com,1999:blog-9028922528361045176.post-83080560001057759762014-01-27T19:09:37.645+05:302014-01-27T19:09:37.645+05:30I'm getting an error after giving a correct pa...I'm getting an error after giving a correct path of DataSheet.xlsx file...<br />java.lang.NullPointerException<br /> at test.ReadXLS.getData(ReadXLS.java:26)<br /> at test.SearchCountry.testSearchCountry(SearchCountry.java:37)<br /> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br /> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)<br /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)<br /> at java.lang.reflect.Method.invoke(Unknown Source)<br /> at org.testng.internal.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:84)<br /> at org.testng.internal.Invoker.invokeMethod(Invoker.java:714)<br /> at org.testng.internal.Invoker.invokeTestMethod(Invoker.java:901)<br /> at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:1231)<br /> at org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:127)<br /> at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:111)<br /> at org.testng.TestRunner.privateRun(TestRunner.java:767)<br /> at org.testng.TestRunner.run(TestRunner.java:617)<br /> at org.testng.SuiteRunner.runTest(SuiteRunner.java:334)<br /> at org.testng.SuiteRunner.runSequentially(SuiteRunner.java:329)<br /> at org.testng.SuiteRunner.privateRun(SuiteRunner.java:291)<br /> at org.testng.SuiteRunner.run(SuiteRunner.java:240)<br /> at org.testng.SuiteRunnerWorker.runSuite(SuiteRunnerWorker.java:52)<br /> at org.testng.SuiteRunnerWorker.run(SuiteRunnerWorker.java:86)<br /> at org.testng.TestNG.runSuitesSequentially(TestNG.java:1224)<br /> at org.testng.TestNG.runSuitesLocally(TestNG.java:1149)<br /> at org.testng.TestNG.run(TestNG.java:1057)<br /> at org.testng.remote.RemoteTestNG.run(RemoteTestNG.java:111)<br /> at org.testng.remote.RemoteTestNG.initAndRun(RemoteTestNG.java:204)<br /> at org.testng.remote.RemoteTestNG.main(RemoteTestNG.java:175)Anonymoushttps://www.blogger.com/profile/03495187740168579671noreply@blogger.comtag:blogger.com,1999:blog-9028922528361045176.post-39405787124525963652014-01-21T13:03:54.667+05:302014-01-21T13:03:54.667+05:30hi..
Can you provide the code to write the result...hi..<br /><br />Can you provide the code to write the result to Excel sheet for the data set which has been passed from the Excel to the Selenium Webdriver. ?<br />rajeevhttps://www.blogger.com/profile/11259748150417766125noreply@blogger.comtag:blogger.com,1999:blog-9028922528361045176.post-25440460649035868892014-01-02T22:03:54.265+05:302014-01-02T22:03:54.265+05:30Hi
I have downloaded the poi jar files from
but...Hi <br />I have downloaded the poi jar files from <br /><br />but all the below functions in the tests are having compilation errors I mean Im not able to import the files<br />XSSFWorkbook,XSSFSheet,XSSFRow,XSSFCell<br /><br />can anyone help ??<br />ThanksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-9028922528361045176.post-87588983726805848632013-12-03T16:17:22.862+05:302013-12-03T16:17:22.862+05:30hi, could you post the webdriver java code for upd...hi, could you post the webdriver java code for updating the status as pass/fail against the data rows that's fetched..Anonymoushttps://www.blogger.com/profile/03086574233377281115noreply@blogger.comtag:blogger.com,1999:blog-9028922528361045176.post-41149467235147168682013-12-03T11:17:15.505+05:302013-12-03T11:17:15.505+05:30hi, i need help, how write the result in existing ...hi, i need help, how write the result in existing excel sheet, can you plz help....Anonymoushttps://www.blogger.com/profile/15237286531640289688noreply@blogger.comtag:blogger.com,1999:blog-9028922528361045176.post-83951791668203642782013-11-21T17:17:55.510+05:302013-11-21T17:17:55.510+05:30Please help me what we need to jar files.i tried p...Please help me what we need to jar files.i tried poi jar file and selenium server,selenium client ,testng jar file used.But not working properly.please help me how to use jar file.some time i used argument type to list .but working.please suggestion me . khttps://www.blogger.com/profile/10826458291142452690noreply@blogger.comtag:blogger.com,1999:blog-9028922528361045176.post-69536996753895920572013-09-23T22:36:50.122+05:302013-09-23T22:36:50.122+05:30Hello sree kanth
ReadXLS class is not in poi jar ...Hello sree kanth<br /><br />ReadXLS class is not in poi jar file,I created this class with the help of poi jar.<br /><br />You should see ReadXLS class in this post, First code is related to this.<br /><br /> Adminhttps://www.blogger.com/profile/15096936763273601422noreply@blogger.comtag:blogger.com,1999:blog-9028922528361045176.post-53856565392262954882013-09-23T13:05:10.702+05:302013-09-23T13:05:10.702+05:30package org;
import java.io.File;
import java.uti...package org;<br /><br />import java.io.File;<br />import java.util.List;<br />import java.util.concurrent.TimeUnit;<br />import org.openqa.selenium.By;<br />import org.openqa.selenium.WebDriver;<br />import org.openqa.selenium.firefox.FirefoxDriver;<br />import org.testng.Assert;<br />import org.testng.annotations.AfterSuite;<br />import org.testng.annotations.BeforeSuite;<br />import org.testng.annotations.Test;<br />import jxl.Sheet;<br />import jxl.Workbook;<br />import org.apache.poi.hssf.usermodel.*;<br />public class SearchCountry {<br /> private WebDriver driver;<br /> private String baseUrl;<br /><br /> @BeforeSuite<br /> public void setUp() throws Exception {<br /> driver = new FirefoxDriver();<br /> baseUrl = "http://www.wikipedia.org/";<br /> driver.manage().timeouts().implicitlyWait(30, TimeUnit.SECONDS);<br /> }<br /><br /> @Test<br /> public void testSearchCountry() throws Exception {<br /><br /> driver.get(baseUrl + "/wiki/Main_Page");<br /> ReadXLS readXls = new ReadXLS();//Unable find the ReadXLS class i added poi jar to classpath .<br /> List dataList = readXls.getData();<br /><br /> for (int i = 1; i < dataList.size(); i++) {<br /> String[] testCase = new String[5];<br /> String[] test = (String[]) dataList.get(i);<br /> String countryName = test[0];<br /> String countryDesc = test[1];<br /><br /> driver.findElement(By.id("searchInput")).clear();<br /> driver.findElement(By.id("searchInput")).sendKeys(countryName);<br /> driver.findElement(By.id("searchButton")).click();<br /> String str = driver.findElement(<br /> By.xpath("//h1[@id='firstHeading']/span")).getText();<br /> System.out.println(countryDesc);<br /> Assert.assertTrue(str.contains(countryName));<br /> }<br /> }<br /> <br /><br /> @AfterSuite<br /> public void tearDown() throws Exception {<br /> driver.quit();<br /> }<br />}Anonymoushttps://www.blogger.com/profile/13742106273335515148noreply@blogger.comtag:blogger.com,1999:blog-9028922528361045176.post-14437549916701425032013-09-23T13:00:29.448+05:302013-09-23T13:00:29.448+05:30Hello,
i m facing a error at ReadXLS unable to fin...Hello,<br />i m facing a error at ReadXLS unable to findAnonymoushttps://www.blogger.com/profile/13742106273335515148noreply@blogger.com