![]() ![]() Public static String ReadCell(int column,int row) Returns the Cell value by taking row and Column values as argument For Demo purpose the excel sheet path is hardcoded, but not recommended :) Wrkbook = Workbook.getWorkbook(new File(ExcelSheetPath)) Public ExcelSheetDriver(String ExcelSheetPath) throws BiffException, IOException * Description: Reusable Library file to perform Excel related operations * Date : Create a function to read from the Dictionary Create a Dictionary to store Excel Sheet Column nameĥ. Read Cell value from a specified locationĤ. Step 1 : Create a library file with all the below mentioned functionalityģ. The library file need to have following basic functionality in hand, let say In order to perform data driven testing, all we need to do is create a reusable library file just for Excel using JXL. ![]() Well, for this I don’t want to bore you guys with lot of theoretical contents which you can always find some way or other, but I would like to show the real working code. ![]() How can I use this in my Selenium framework which I have? What are the steps which has to be taken care to make my framework a data driven framework? But the greatest question of the day is, how to use JXL for data driven testing ?. ![]() We have learned what is Data driven testing and how we can use JXL to read data from Excel Sheets in Part 1 of our previous post. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
May 2023
Categories |