Refresh internal excel data

Web Testing
5

Hello neamehbaydoun66,

You can try this

import com.kms.katalon.core.testdata.reader.ExcelFactory

//create an instance
ExcelData excel = ExcelFactory.getExcelDataWithDefaultSheet("yourExcelPath.xlsx", "SheetName", true)

//pass your test case variables
excel.getValue("tc_variable", 1)

Where
-First parameter will be the excel path
-Second parameter will be the sheet name. You can change sheet name on run time just put a string variable
-Third, make it true if you want to make the first row as headers or false if you want to make the first row as plain record

Hope that helps. . . :smiley:

1 Like