rahulk-calfus
commented
9 months ago how to read the excel from one drive using selenium with java
Open ianwart opened 8 years ago
rahulk-calfus
commented
9 months ago how to read the excel from one drive using selenium with java
DEEPAK, IT SEEMS YOU STRUGGLE WITH THESE TWO PARTS IN THE BEGINNING, IF YOU CAN FOLLOW EXACTLY THIS INTRODUCTION, I AM SURE BOTH OUR INSTRUCTOR WOULD APPRECIATE! HOPE THIS HELPS A LITTLE. THANKS.
Question: Tell me about yourself. I have Over 7+ years of working experience as QA Engineer in the industry in different domain, including Financial & Health Care Proficient in both Manual and Automation Testing with ability to manage the automation of the entire testing cycles and leading the testing team Extensive experience creating and designing Test Strategy Documents, Test Plan, Test schedules, Test Cases, Test Procedures and Test Scenarios Strong Business expertise in Requirements Analysis utilizing Automated tools to import and document specifications I have expertise in Smoke Testing for overnight builds I am proficient in System, Functional, Integration, Regression, Progression, Security, as well as UAT. Excellent Documentation Management and creative skills including Test Plan, Test Case Specifications, Test Requirements, Test Case Matrix and Defect Reports I have specific experience in Java Language that use for Selenium WebDriver to develop the complete automation framework from scratch. I am experienced working in different S.D.L.C. methodologies like Agile and Waterfall model. My experiences cover using different Test Management system like A.L.M. and QC, Jira, and Version One, to write and execute the test case and follow the defect management life cycle. Extensively used SOAP UI to test Web Service/Rest API.
Question: Tell me your Selenium experiences and involvement My basic involvement in selenium is to develop the code for automation on the basis of successful manual test cases, using the language java, rooted on the test case flow of the application, using the Selenium WebDriver I.D.E. tools eclipse. Also most involvement is to develop automation framework using Page Object Model P.O.M and □ Applying its’ inbuilt page object model Page factory. □ Where ever it’s necessary I use created configured property file, I call them from using. (Dot)load operator and File-Input-Stream method. □ Also for data driven test I use excel data ‘work book’ and sheet. Then using TestNG to drive the test to execute the test cases. For the tests better reports I use Extent Reports that generates the complete visual graphical report as well as the test result data. Also I am experienced in Cucumber to execute the test using Gherkin Language following the BDD Behavioral Driven Development. My experiences covers the using GitHub Repository in order to share the code I write in the GitHub Repository that others can share their part. //Also I have experience in Maven automation framework
Question: how to Properties File Read
I will have my existing property file, which formed in HashMap pattern with key and value,
o I will declare the new variable
Properties newVarPropFile = new Properties(); Then I will instantiate the FileInputStream by passing the file location parameter FileInputStream fileinputstream = new FileInputStream, (pass the location path of the property) Then I call the load method for the fileinputstream newVarPropFile.load(fileinputstream); Then I use System out print where I pass the user directory path and file location System.out.println(System.getProperty("user.dir") + "location"); Then I pass the key name in System out print using get.Property method System.out.println(prop.getProperty("project")); System.out.println(prop.getProperty("name"));