You need to write a java code, Sample code:
FileInputStream excellFile = new FileInputStream(new File("C:\\excel1.xlsx"));
XSSFWorkbook workbook = new XSSFWorkbook(excellFile);
XSSFSheet sheet = workbook.getSheetAt(0);
int empId = Integer.parseInt(testExec.getStateValue("EmployeeID"));
for (int j = sheet.getFirstRowNum(); j <= sheet.getLastRowNum(); j++)
{
XSSFRow row = sheet.getRow(j);
XSSFCell cell = row.getCell(row.getFirstCellNum());
int empid_sheet = Integer.parseInt(cell.getStringCellValue());
if(empid_sheet == empId )
{
flag = true;
for (int k = row.getFirstCellNum()+1; k < row.getLastCellNum(); k++)
{
//Set all the values for each colum as shown below
testExec.setStateValue("Role", role);
}
break;
}
In vsi, you can call these properties using {{}}.
Revert if more help required.