Data Driven Software Testing with Selenium Apache POI Tool

Abstract

The concept of quality in software means that the software meets needs and expectations of the customers and also is free from defects or deficiencies. Quality software saves time and money since it is unlikely to occur errors in testing and maintenance stages. Assuring the quality of the software is related with software testing processes. Testing is the process of controlling the system carefully from different aspects, either manually or automatically, to see if it coincides with customer requirements. There are many reasons to test the software such making sure the product quality before it is presented to the customer, reducing rework and development costs and detecting errors in the early stages of the development process and preventing them from spreading further stages. The aim of the study is that investigating and giving a brief information about both Apache POI library of Selenium test tool and data driven testing. Therefore, in the context of the study, a data driven test application is implemented with Apache POI library of Selenium in order to perform our test scenario. Then the test methods are executed and test results are examined. Finally, it is understood that data driven testing can be carried out easily with built in methods of Apache POI library and can be installed for free by users for testing purposes.

Keywords

• Software Testing
• Data Driven Testing
• Selenium
• Apache POI
• Software Quality

References

1. [1] B. Uzun and K. Koruyan, “An overview and approaches to status reporting in the software test process”, Journal of Management Information Systems, vol. 5, no.1, pp. 52–63, Dec. 2019.
2. [2] ITU Bilgi İşlem Daire Başkanlığı. (2013) Yazılım Testi ve Test Süreçleri. [Online]. Available: https://bidb.itu.edu.tr/seyir-defteri/blog/2013/09/08/yaz%C4%B1l%C4%B1m-testi-ve-test-s%C3%BCre%C3%A7leri
3. [3] H. A. Yener, F. Baştürk and B. Meçik, “General Mobile Productivity Increase with Software Development and Test Automation: General Mobile”, Karamanoglu Mehmetbey University Journal of Engineering and Natural Sciences, vol. 1, no. 1, pp. 172-196, 2019.
4. [4] P. Yadav and A. Kumar, “An Automation Testing Using Selenium Tool”, International Journal of Emerging Trends and Technology in Computer Science (IJETTCS), vol. 4, no. 5(2), pp. 68-71, 2015.
5. [5] J. S. Raju and V. Vaidhehi, “Design and Implementation of Hybrid Test Automation Framework for Web Based Application”, International Journal of Innovative Research in Advanced Engineering (IJIRAE), vol. 4, no. 3, pp. 108-112, 2017.
6. [6] Chandraprabha, Kumar, A. and Saxena, S., Data Driven Testing Framework using Selenium WebDriver, International Journal of Computer Applications, 118:18-23, 2015.
7. [7] Gojare, S., Joshi, R. and Gaigaware, D., 2015, Analysis and Design of Selenium Webdriver Automation Testing Framework, Prodecia Computer Science – 2nd International Symposium on Big Data and Cloud Computing (ISBCC’15), 50: 341-346.
8. [8] Devi, J. ve diğ., 2017, A Study on Functioning of Selenium Automation Testing Structure, International Journal of Advanced Research in Computer Science and Software Engineering, 7(5): 855-862.

9. [9] Quan, D. M., 2018, Implementing test automation with Selenium WebDriver, Lathi University of Applied Sciences, Degree Programme in Business Information Technology, Bachelor’s Thesis.
10. [10] ITU Bilgi İşlem Daire Başkanlığı. (2013) Yazılım Testi ve Test Süreçleri. [Online]. Available: https://bidb.itu.edu.tr/seyir-defteri/blog/2013/09/08/yaz%C4%B1l%C4%B1m-testi-ve-test-s%C3%BCre%C3%A7leri