Home > Microsoft Excel

Manual testing tutorial

Manual testing tutorials Download free sample testcase template Checklist for software application testing Software design specification - Importance in UI testing Early involvement of testing team in requirement phase Test case for button, password, form, links What is AB testing Checklist and device matrix for Responsive Testing Code to get screen resolution Test cases for drop-down list (multiple selection)

This Article is TAGGED in . Read more

Java Apache POI: Read or Modify data in excel file

Read and write excel file in java Pre-requisite:Download latest apache poi library.  Add below mentions jar files in build path from downloaded compressed file. commons-codec-1.11.jar commons-logging-1.2.jar jaxb-api-2.3.0.jar junit-4.12.jar poi-excelant-4.0.0.jar poi-scratchpad-4.0.0.jar commons-collections4-4.2.jar commons-math3-3.6.1.jar jaxb-core-2.3.0.1.jar log4j-1.2.17.jar poi-ooxml-4.0.0.jar xmlbeans-3.0.1.jar commons-compress-1.18.jar curvesapi-1.05.jar jaxb-impl-2.3.0.1.jar poi-4.0.0.jar poi-ooxml-schemas-4.0.0.jar activation-1.1.1.jar   Class which contains read and write function. [crayon-664a41c62d37d317896932/]   Read and write functions from ExcelReadWrite class used. [crayon-664a41c62d38b288403129/] Code Execution Result: Changes in excel file before and after code execution.       Selenium Tutorial >>

This Article is TAGGED in , , . Read more

Test bulk urls using Excel VBA macro

To verify page load errors, specific text for thousands of web page it is possible using simple excel Macro.  To perform testing on thousands of URL we can easily use below macro code to verify page load error 404, verification of specific text or any other data validation requirment. [crayon-664a41c62e0cd847434199/]   >> Manual Testing

This Article is TAGGED in , , . Read more

Read data from excel sheet using Katalon Studio

It it very easy to get data from excel using Katalon Studio. For Data driven test cases we need excel sheet. In this article will see how to use excel sheet in KATALON studio by using findTestData method. Select Menu File -> New -> Test Data (Katalon studio will show "New

This Article is TAGGED in , . Read more

How to Create Dependent drop down lists in Excel

To populate the list based on selection,microsoft excel is providing feature of dependent drop down list.In this article will see based on selection of country drop down related city drop down should get populated.Step 1) Create the Country list then select those country and create the named list.To Create the named

This Article is TAGGED in , , . Read more