select 1 data with input taken from excel file

1. This is the code I use for my excel data. maybe It'll come in handy.
2.  

3. 1. Retrieve the data from the Excel file:

   javascript

    

let excelApp = Sys.OleObject("Excel.Application");
let workbook = excelApp.Workbooks.Open("path_to_your_excel_file");
let sheet = workbook.Sheets("Sheet1");
let data = sheet.Cells(1, 1).Value;

• 2. Use UI automation to locate and interact with the Status box in your application:

  javascript

   

let appProcess = Sys.Process("Your_Application_Process_Name");
let window = appProcess.Window("Your_Window_Name");
let statusBox = window.FindChild("Your_Status_Box_Name");
statusBox.Click();

• 3. Optionally, add necessary delays or synchronization points before proceeding further.

• 4. Simulate typing the data into the Status box:

  javascript 

   

statusBox.Keys(data);
//Or for setItem
statusBox.setItem(data);

Make sure to replace "path_to_your_excel_file" with the actual path to your Excel file, "Sheet1" with the name of the sheet in your Excel file, "YourAppProcessName" with the actual process name of your application, and "Your_Status_Box_Name" with the proper name or identifier of the Status box in your application.

Please let me know if you encounter any issues or if there's any additional information I can provide to assist you further.

I don't work with Keyword Tests either, scripting is the way forward 😁

I suggest you break things down into smaller pieces,

• Record a keyword test to click the Status control, and then select the item Request.
• Replace 'Request' with a variable
• Record a keyword test to read data from your source
• Store the data into a variable

You should then be able to tie the two scenarios above, into one. 

There's plenty of examples on the SmartBear website such as Data-Driven Testing. 

Here's an example based on the following website https://www.w3schools.com/howto/tryit.asp?filename=tryhow_js_filter_list. "Billy" is entered into the field, the item is found. The item "Billy" is then clicked.

It's difficult to explain step by step, but you have the option to change e.g. the value of "Front-end" to a variable, where myvariable = "Front-end"

Here's how you read a value from Excel and use it in a keyword test

https://support.smartbear.com/testcomplete/docs/testing-with/working-with-external-data-sources/excel/read.html

See how far you can get with this and I can help after that!